Case 4: Joining data
These cases are offered in Excel and Alteryx and use real-world data. The cases are accompanied by how-to videos.
Suitable courses: Accounting information systems; Data analytics
Case 3: Advanced text extractions and unique identifiers
These cases are offered in Excel and Alteryx and use real-world data. The cases are accompanied by how-to videos.
Suitable courses: Accounting information systems; Data analytics
Case 2: Basic text extractions and unique identifiers
These cases are offered in Excel and Alteryx and use real-world data. The cases are accompanied by how-to videos.
Suitable courses: Accounting information systems; Data analytics
Case 1: Identifying data problems
These cases are offered in Excel and Alteryx and use real-world data. The cases are accompanied by how-to videos.
Suitable courses: Accounting information systems; Data analytics
The Overview case covers fundamental considerations in the ETL process and requires students to confirm their understanding. This case can be used as an assessment tool.
These cases are offered in Excel and Alteryx and use real-world data. The cases are accompanied by how-to videos.
Suitable cou...
This case provides students a background on the DuPont Method and then requires students to analyze financial statement data for various companies across industries using this method to form investment recommendations. This case is offered in Tableau and R and is accompanied by how-to videos.
Suit...
This is a five-part case in which students are asked to assume the role of an auditor for Digital Assets Inc., a company that allows its customers to pay invoices in bitcoin, a common cryptocurrency that makes up approximately 50% of the market cap of all cryptocurrencies (as of May 2021).
EY has...
This case asks students to consider cybersecurity risks and their potential impact on the financial statements and to learn more about best practices for password policies to help mitigate cybersecurity threats. Students are asked to perform manual audit procedures on a sample of user names and pass...
This case asks students perform select cybersecurity audit procedures on actual Enron Corporation emails (approximately 27,000), preserved by federal investigators, to look for employee violations of hypothetical company policies. The case is offered in Alteryx, which is a powerful tool for both ETL...
This case is designed to have students perform a cybersecurity penetration test of password strengths at Blue Yarrow Unicorns. Students are provided with over 5,100 usernames, hashed passwords and job unit descriptors of Blue Yarrow's employees. Using a dictionary of nearly 2 million plain text comp...
This case asks students to perform descriptive and text analyses on purchasing card data for BioPhirma, an innovative, global health care leader, to assess compliance with policies and to help investigate a whistle-blower tip about possible fraud being committed through purchasing card transactions....
The Apollo Investments Research case is designed to provide students a hands-on opportunity to develop their analytics mindset by working directly with alternative data, which is satellite imagery of parking lots for four major companies (Home Depot, Lowe’s, Target and Walmart). Students will assume...