Elevate-Labs-Internship-Task-4

Bike Sales in Europe Dashboard

Overview

This project analyzes European bike sales (2011–2016) using Power BI. The dashboard provides interactive insights into sales trends, product performance, customer demographics, and profitability across countries.

Dataset

• Bike Sales in Europe - Kaggle
• Columns: Date, Year, Month, Country, State, Product Category, Subcategory, Product, Customer Age, Gender, Order Quantity, Unit Price, Profit, Revenue, etc.

Dashboard Features

• KPIs: Total Revenue, Profit, Orders, Avg Order Value, Profit Margin
• Trends: Sales and profit over time
• Product Analysis: Top categories, subcategories, and products
• Customer Demographics: Sales by gender and age group
• Geo Analysis: Sales by country/state
• Profitability: Profit margin by product category/subcategory
• Interactivity: Slicers for year, country, category and age group

How to Use

1. Open Bike Sales in Europe Analysis.pbix in Power BI Desktop.
2. Use slicers to filter by year, country, product category, etc.
3. Explore trends and breakdowns to answer business questions.

Files

• Bike Sales in Europe Analysis.pbix – Power BI dashboard
• README.md – Project documentation
• Screenshots/ – Dashboard images

Credits

Dataset: Kaggle - Bike Sales in Europe