This case is designed to have students perform ETL procedures in R on a random selection of over a million, real-world customer transactions spanning a three-year period for Swift Arrow convenience stores (Swift). Swift operates in over 160 cities in the US and has over 180 stores.
Suitable course...
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 provides an opportunity for students to explore Inline XBRL data from the Securities and Exchange Commission’s (SEC) Electronic Data Gathering, Analysis, and Retrieval (EDGAR) system. Tesla is used as the example company for exploration.
Suitable courses: Introduction to accounting; Fin...
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...