In this Data and Analytics case study, our fictitious company, Pixystems Toy Company, Inc., hires your students to analyze their business processes and controls through the analysis of the fictitious data provided. Students will leverage Excel and Tableau. They will work in groups to complete their analysis and provide their recommendations. This project can potentially be used for students who have completed an intermediate accounting and audit class and/or possess a basic understanding of the accounting and processes associated with accounts payable. Case study materials include a professor guide, a kick off presentation on data analysis, a student assignment document, the fictitious data to be analyzed, a checkpoint worksheet for students and some sample results for professors to see possible solutions produced by our intern pilot group. To request these case study materials, please click here.
This case study provides students the opportunity for exposure to data preparation, data discovery and visualization and statistical analysis. The materials could potentially be used in an Accounting Information Systems (AIS or CIS) course, a Data Analytics course of an Advanced Audit course. Students will work with large data files for inventory, purchases, sales, purchases prices and vendor invoices. The materials include instructional components utilizing SQLite and Tableau and case study exercises to apply the skills addressed. Schools with access to other similar tools can easily adapt the exercises. To request these materials, please click here.