This case series focuses on data normalization and writing SQL queries of a relational database to answer accounting questions. The real-world data represents travel expenses of Canadian government workers. These cases can each be assigned independently, or they can be sequenced to provide an overvi...
This case asks students to assume the role of a data analyst for IntegrateCo, a company that installs and services integrated building management systems. The task is to perform various analyses on payroll data. The real-world data for this case includes payroll transaction and human resource data....
This case asks students to assume the role of a chief technology officer and decide whether the information technology compliance training for their organization should be changed to a gamified training model from a non-gamified training model. The real-world data sets are smaller and represent surv...
This case series focuses on a fictitious company, Fairview Inc., a software-as-a-service company, that utilizes a travel expense reimbursement process for its sales and information technology employees who travel to customer locations. The Audit Committee would like to change its audit approach of t...
This case series focuses on a fictitious company, Fairview Inc., a software-as-a-service company, that utilizes a travel expense reimbursement process for its sales and information technology employees who travel to customer locations. The Audit Committee would like to change its audit approach of t...
This case series focuses on a fictitious company, Fairview Inc., a software-as-a-service company, that utilizes a travel expense reimbursement process for its sales and information technology employees who travel to customer locations. The Audit Committee would like to change its audit approach of t...
This case series focuses on a fictitious company, Fairview Inc., a software-as-a-service company, that utilizes a travel expense reimbursement process for its sales and information technology employees who travel to customer locations. The Audit Committee would like to change its audit approach of t...
This case is designed to have students use regular expressions (RegEx) to answer some basic questions about a small set of messy, unstructured customer data and then transform the data into a structured layout so it can be loaded into an application for analysis.
Suitable courses: Accounting info...
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