Coffee shop sales analysis
The business question
A coffee shop owner needed to understand which products, times of day, and customer patterns were actually driving revenue — and where operational inefficiency was quietly costing money.
What I did
Cleaned and structured 12 months of transactional data in Excel. Built dynamic Pivot Table dashboards segmented by product category, hour of day, and day of week. Applied VLOOKUP and IF-based formulas to flag underperforming SKUs and surface revenue concentration risk.
Key finding
Morning hours (7–10am) generated 61% of daily revenue despite representing only 23% of operating hours — recommending targeted staffing and upsell strategies during that window could lift daily revenue by an estimated 8–12%.