Designing an Automated Retail Analytics Pipeline for a Student-Run Store

Publication Date

2026

Presentation Length

Poster/Gallery presentation

College

College of Sciences & Mathematics

Department

Math and Computer Science, Department of

Student Level

Undergraduate

Presentation Type

Poster

Summary

Student-run retail businesses often collect sales data through point-of-sale systems, but this data is rarely integrated into tools that support meaningful analysis and decision-making. At Bruin Bodega, a student-run store at Belmont University, transaction data from Clover and additional operational records are stored across multiple sources, making reporting and performance analysis largely manual.

This project explores the design of an automated analytics pipeline that centralizes retail transaction data into a structured database and aims to support exploratory analysis, financial reporting, and revenue forecasting. Sales data will be integrated from multiple sources, organized into relational tables, and analyzed using Python and SQL. The project aims to demonstrate how a system can help small retail operations increase efficiency, evaluate performance, and make more informed financial decisions.

This document is currently not available here.

Share

COinS