Case 5: Using VBA to transform 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 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 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...
The Overview case is designed to give students exposure to the various types of alternative data and to learn about the growing importance of alternative data and its use by professionals in decision-making. Students will also learn about and consider the challenges and risks in use of alternative d...