This repository contains an Excel-based Coffee Order Analysis that provides insights into sales performance across various coffee types, roast categories, customer segments, and time periods. The dashboard helps users quickly understand trends, identify top performers, and make data-driven decisions.
- Interactive Dashboard with charts and slicers for easy exploration
- Sales breakdown by coffee type, roast, size, and region
- Top customer insights based on total sales
- Year-over-year comparison to identify performance changes
- Clean, visually appealing layout for better readability and presentation
-
Coffee Order Analysis.xlsx
- Contains the full dataset
- Includes an automated and interactive dashboard
- Packed with pivot tables, slicers, and visualizations
This dashboard is designed to help analysts, managers, and teams understand sales behavior quickly and effectively. It can be used for business presentations, academic projects, or supply-chain planning.
- Download the Excel file from this repository.
- Open it in Microsoft Excel (2016 or later recommended).
- Use slicers to filter data by Year, Coffee Type, Roast, or Customer.
- Explore each chart for detailed insights.
- Microsoft Excel (recommended: Excel 2016 or later)
- Macros are not required
- Pivot Table support needed
Feel free to contribute improvements—such as adding new visuals, cleaning data, or expanding insights. Pull requests are welcome!