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