CASE STUDY
Coffee Shop Sales & Optimization
- Category
- Data Analytics
- Year
- 2026
- Stack
- Power BI · SQL · Data Cleaning
The Problem
High inventory waste and unmonitored peak sales hours due to manual tracking.
The Solution & Value
Utilized Excel UNIQUE and XLOOKUP to clean 95% of data anomalies. Engineered a robust relational Star Schema database in Power BI, writing complex DAX queries to dynamically segment peak sales periods.
Sales Funnel Impact
Calculated 9,489 orders ($84.7K revenue). Proven the Pareto Principle where the top 5 items generated 80% of revenue. Provided actionable combo offers to pair top-sellers with lower-performing items, cutting waste and optimizing sales.
Want to achieve similar results for your business?
Connect directly with Amr Mousa to discuss your project requirements.