This project presents a comprehensive analysis of bike sales data, visualized through an interactive dashboard created entirely in Microsoft Excel. The goal is to uncover key insights and trends related to sales performance, customer demographics, and product popularity. This dashboard allows for dynamic filtering and exploration of the data, making it a powerful tool for business intelligence and decision-making.
The interactive dashboard provides a one-glance view of key performance indicators (KPIs) and trends.
- Total Revenue: Overall sales performance.
- Total Units Sold: Volume of bikes sold.
- Average Revenue Per Bike: Average price point of sales.
- Customer Count: Total number of unique customers.
- Dynamic Slicers: Filter the entire dashboard by:
YearCountry / RegionCustomer GenderAge Group
- Timeline Slicer: Effortlessly drill down into specific time periods.
- Sales Trend Over Time: A line chart showcasing revenue trends on a monthly basis.
- Sales by Country: A map chart or bar chart illustrating the geographical distribution of sales.
- Customer Demographics Breakdown: Donut charts showing the proportion of sales by gender and age category.
- Top Selling Bike Models: A horizontal bar chart highlighting the most popular products.
- Revenue vs. Profit Margin Analysis: A scatter plot or combination chart to analyze the profitability of different bike categories.
- Microsoft Excel:
- Data Cleaning & Processing: Power Query (Get & Transform Data)
- Data Modeling: Power Pivot & DAX Measures
- Core Analysis: PivotTables
- Visualization: PivotCharts, Slicers, and Timelines
- Download: Clone the repository or download the
.xlsxfile from this repository. - Open: Open the file using Microsoft Excel 2016 or a more recent version for full compatibility.
- Enable Content: If prompted, click "Enable Content" or "Enable Editing" to ensure all interactive features function correctly.
- Interact: Use the slicers on the main
Dashboardsheet to filter the data and explore different insights.
Here is a preview of the main dashboard interface.
The dataset used for this analysis was sourced from Kaggle. You can find the original data and notebook here: Bike Store Sales in Europe - Kaggle.
Feel free to reach out if you have any questions or suggestions!