An interactive analytical solution that transforms raw transaction data into actionable insights to optimize operational decisions and understand customer behavior.
Coffee Shop Sales Performance Dashboard
Coffee shop businesses often struggle to interpret high-volume transaction data to identify peak hours and underperforming segments. This project aims to bridge that gap by building a dynamic dashboard that visualizes sales performance, footfall trends, and customer behavior metrics to support data-driven business decisions.
Microsoft Excel: Main platform for the interactive dashboard and visualization.
Power Query Editor: Used for robust data connection and automated cleaning.
Power Pivot: Leveraged to enhance the data modeling workflow.
Excel Developer Tools: Utilized for advanced interactivity and dashboard features.
Data Context: Analyzed a publicly available retail dataset containing over 149K transaction records, including sales figures, timestamps, and product categories.
Data Cleaning (ETL): Utilized Power Query Editor to connect to raw data, remove unnecessary white spaces, and handle data transformations to ensure accuracy.
Data Modeling: Leveraged Power Pivot to create structured table relationships and manage complex data calculations efficiently.
Visualization & Design: Built a dynamic visual layer using Line, Bar, and Clustered Column charts to identify seasonal trends and high-growth product categories.
Financial Health: Achieved $698K in Total Sales with a total footfall of 149K customers.
Customer Spending: Identified an Average Bill per Person of $4.69 and an average of 1.44 orders per person.
Peak Operations: Pinpointed the 8 AM – 10 AM morning rush as the peak order time.
Product Performance: Barista Espresso emerged as the top-selling product, while Coffee & Tea was the highest revenue category.
Upselling Opportunity: Identified that Saturday is the lowest sales day and average orders are below expectations, suggesting a need for targeted upselling strategies.
Email: [mraza28067@gmail.com]
WhatsApp: [+92-336-1890356]