- Project number
- Project / 015
- Year
- 2024
- Category
- Analytics
- Status
- Completed
Excel Coffee Sales Dashboard
Coffee sales trends and customer segmentation in an interactive Excel dashboard.
- Stack
- Excel
- Tags
- Dashboard
01 /Overview
Sales data is hard to read in rows; decision-makers need the trends at a glance.
02 /What I built
- Pivot tables and pivot charts for summaries
- Slicers and drop-downs for interactive filtering
- Conditional formatting to highlight key figures
- Documentation for updating the data
03 /Outcome
An interactive Excel dashboard of coffee orders that a beginner can filter and explore.
04 /What I learned
A well-designed spreadsheet dashboard can answer most day-to-day questions before a BI tool is needed.
