View in EDS

Operational Analytics in Excel: A Transaction-Level Car Wash Case for Introductory Data Literacy.

Saved in:
Bibliographic Details
Title: Operational Analytics in Excel: A Transaction-Level Car Wash Case for Introductory Data Literacy.
Authors: Mentzer, Kevin1 Kevin.Mentzer@nichols.edu, Russo, Robert1 Robert.Russo@nichols.edu, Lawshe, Nathaniel1 Nathaniel.Lawshe@nichols.edu, Mullen, Elizabeth1 Elizabeth.Mullen@nichols.edu
Source: Information Systems Education Journal. Jul2026, Vol. 24 Issue 4, p106-112. 7p.
Subject Terms: *Information literacy, Transaction records, Business analytics, Data scrubbing, Car wash industry, Data visualization
Reviews & Products: Microsoft Excel (Computer software)
Abstract: This teaching case introduces introductory level students to data literacy through an applied operational analytics project based on a regional express car wash business. Students assume the role of an external consulting team hired by Soapy Noble Express Car Wash, a fast-growing chain operating eight locations in New England, to analyze transaction level point of sale data and develop actionable recommendations for management. Using approximately one year of transaction records at scale, students apply Excel based techniques such as data cleaning, descriptive statistics, pivot tables, and visualization to identify patterns in customer demand, service mix, location performance, and monthly unlimited plan usage. To extend analysis beyond the internal dataset, the case encourages students to locate and integrate relevant external sources, such as weather or demographic data, and to explain how these sources inform interpretation and recommendations. The case is designed for first year courses in data literacy, business analytics, or introductory CIS and includes team-based deliverables appropriate for nontechnical decision makers, including an analysis workbook and a concise executive memo and presentation. [ABSTRACT FROM AUTHOR]
Copyright of Information Systems Education Journal is the property of Information Systems & Computing Academic Professionals (ISCAP) and its content may not be copied or emailed to multiple sites without the copyright holder's express written permission. Additionally, content may not be used with any artificial intelligence tools or machine learning technologies. However, users may print, download, or email articles for individual use. This abstract may be abridged. No warranty is given about the accuracy of the copy. Users should refer to the original published version of the material for the full abstract. (Copyright applies to all Abstracts.)
Database: Education Research Complete
Description
Abstract:This teaching case introduces introductory level students to data literacy through an applied operational analytics project based on a regional express car wash business. Students assume the role of an external consulting team hired by Soapy Noble Express Car Wash, a fast-growing chain operating eight locations in New England, to analyze transaction level point of sale data and develop actionable recommendations for management. Using approximately one year of transaction records at scale, students apply Excel based techniques such as data cleaning, descriptive statistics, pivot tables, and visualization to identify patterns in customer demand, service mix, location performance, and monthly unlimited plan usage. To extend analysis beyond the internal dataset, the case encourages students to locate and integrate relevant external sources, such as weather or demographic data, and to explain how these sources inform interpretation and recommendations. The case is designed for first year courses in data literacy, business analytics, or introductory CIS and includes team-based deliverables appropriate for nontechnical decision makers, including an analysis workbook and a concise executive memo and presentation. [ABSTRACT FROM AUTHOR]
ISSN:1545679X
DOI:10.62273/?????