Skip to content
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.