Interactive excel dashboard analyzing chocolate sales across products and countries.
This project showcases an interactive Excel dashboard analyzing chocolate sales data over three years (2022-2024). The dashboard is designed to help marketing and sales teams identify trends, monitor performance, and make data-driven decisions.
The dataset includes the following columns:
- Salesperson
- Country
- Product
- Date
- Amount (USD)
- Boxes shipped
The dashboard includes the following key features and visualizations:
- KPI Metrics: Total revenue and total orders for quick performance overview
- Product Demand by Country: chart showing which products are most in demand in each country
- Number of Orders by Country: chart visualizing order distribution across countries
- Chocolate Sales Analysis:
- Average revenue by country
- Top 5 best-performing products
- Orders Trend: Line chart showing monthly number of orders over 2022, 2023, and 2024
- Sales Trend: Line chart showing monthly sales trends over the same period
- Slicers/Filters: Interactive slicers to filter data by country, product, and salesperson
Some of the insights that can be derived from this dashboard include:
- Top-performing products and countries
- Monthly trends in orders and sales
- Patterns in revenue and order volumes to support business decisions
- → interactive Excel dashboard
- → screenshots of the dashboard for quick preview
- Open the Excel file to interact with the dashboard
- Use the slicers to filter data by country, product, or salesperson
- Explore trends over the three years (2022-2024) using the line charts for orders and sales