Developing Business Process and Query Skills for Solving Business Problems

Abstract

This case offers learning experiences for (1) following a business process diagram for car dealers’ recording of sales and sales returns of new cars and the car manufacturer’s subsequent recording of the same transactions and (2) querying a database to determine why dashboards maintained by the dealers and the manufacturer do not always agree. Scaffolding resources (videos and script with screenshots) enable learners with no querying experience to work the case as they develop basic query skills. For learners with query skills, the case (without scaffolding resources) can be used as a data analysis project covering all major query operations. The data can be queried in any structured query language (SQL) platform. The case offers practice and quiz questions for assessing business process skill and the query skills of joining tables, aggregating data, setting criteria, using built-in functions, developing expressions, and verifying query correctness.