Coffee Shop Sales Dashboard
The client faced significant inventory waste and unpredictable staffing needs due to a complete lack of visibility into peak sales hours and top-performing product margins from a dirty, unstructured 10,000-row transaction dataset.
Digitized, structured, and cleaned 95% of transaction data using Excel UNIQUE and XLOOKUP. Designed and built a robust Power BI Star Schema model to track hourly sales performance, product profitability, and identify offers' impact.
Discovered the Pareto Principle where the top 5 items generated 80% of revenue. Provided actionable combo offer recommendations to bundle high-margin and low-performing items, driving sales optimization and efficiency.
Note: If the Microsoft Power BI service is blocked on your network, use the media tabs above.