BMW Project
My Project
Project Title: BMW project
Status : Completed
Real-time data , Structured data , Qualitative and Quantitative data
This project involved analyzing BMW sales data to derive actionable insights and identify key performance trends. The dataset included columns such as Model, Country, Channel, and Countries, and focused on the following KPIs:
– Quantity Sold: A comparative analysis of units sold in the previous year versus the current year.
– Revenue Analysis: Assessment of total revenue generated, broken down by model, channel, and country.
– Highest Sold Model: Identification of the top-performing model based on sales volume.
– Most Expensive Model: Insights into the highest-priced car in the inventory.
– Channel of Purchase: Evaluation of sales distribution across different channels (e.g., online, dealerships).
Analytical Features:
– Slicers for Models: Enabled users to filter and explore the average price of each car model.
– Country Performance: Highlighted countries with the highest number of purchases and revenue contributions.
Tools and Techniques:
– Power BI: Leveraged for creating interactive and visually appealing dashboards.
– DAX (Data Analysis Expressions): Used for complex calculations and deriving meaningful metrics.
– Visualizations: Included bar charts for year-over-year sales comparison, heatmaps for country performance, pie charts for channel distribution, and trend lines for revenue growth.
The project successfully provided a comprehensive overview of BMW’s sales performance, helping stakeholders identify growth opportunities, optimize pricing strategies, and focus on high-performing regions and channels.