This case provides students with an overview of the database provided to them (data tables and their corresponding data fields). It requires students to query this database to create the data set needed for the process mining software to effectively analyze the activities (or events) in the order-to-cash process (this can also be referred to as an activity file). You can require students to complete the querying using SQL (option 1) or Microsoft Access Query Design View (option 2). The appendices of the case include the narrative and flowchart of the order-to-cash process from the Document the process case.
Suitable courses: AIS, Audit, Data Analytics
Link to download files (requires login)
Join EYARC for Full AccessTurn case studies into powerful teaching moments for your students. Active EYARC users can explore our experiential learning platform to access cutting-edge curricula and innovative teaching resources.
Try It NowAccess free resources to prepare students for the global marketplace. Resources include case studies, data sets, analytics workbooks, videos and many other tools focused on business and accounting topics.
To search by multiple tags, enter the search word followed by a comma and the next word, etc.
For example, entering "Audit, Excel, Intermediate" will list cases related to audit AND Excel AND intermediate difficulty.
To search by a single tag, enter it in the search box or click on the tag below in the Popular Tags area.