This project aims to build an interactive Microsoft Excel dashboard that allows users to quickly identify trends in coffee bean sales. Users can compare these sales across different bean types and countries.
- Microsoft Excel
- Data Transformation
- Data Visualization
To create an interactive dashboard in Excel that allows users to efficiently visualize and compare coffee sales data.
This project involves all stages of data analysis in Excel, from data collection and data cleaning to transformation and, finally, creating actionable insights in the form of a dashboard.
- Dynamic, interactive dashboard
- Advanced Excel formulas and functions
- Multiple slicers for data filtering
- Timeline filter for date-based insights
-
Sales Trends Over Time 📈:
- Sales show significant fluctuations month to month, with notable peaks observed in 2021.
- Among the different coffee types (Arabica, Excelsa, Liberica, and Robusta), each shows unique trends, with Liberica appearing to maintain consistently higher sales.
-
Sales by Country 🌍:
- The United States leads in total sales, contributing the highest revenue by a large margin compared to other countries.
- Ireland and the United Kingdom have much lower sales, indicating potential areas for growth or targeted marketing efforts.
-
Top 5 Customers 🏆:
- Allis Wilmore ranks as the top customer, generating $317 in sales, followed closely by Brenn Dundredge.
-
Product Preferences ☕:
- The dashboard includes filters for different roast types (Dark, Light, Medium) and sizes (0.2 kg, 0.5 kg, 1.0 kg, 2.5 kg), providing flexibility to analyze which combinations are most popular.
- A loyalty card filter indicates that there may be valuable data on how loyalty programs impact purchasing behavior, useful for customer retention strategies.