PowerBI Dashboard: Car Sales
In this project, I developed two Power BI dashboards—Overview and Details—to analyze car sales data. The dashboards provide real-time insights into key metrics such as Year-to-Date (YTD), Month-to-Date (MTD), and Year-over-Year (YOY) growth. Using interactive visualizations like line charts, pie charts, and map charts, the project helps track sales trends, distribution by car body style, color, and region, and offers a detailed data grid for all sales.
Project Scope:
The dashboards were designed to track key performance indicators (KPIs) such as Year-to-Date (YTD), Month-to-Date (MTD), and Year-over-Year (YOY) growth. I created interactive visualizations, allowing users to explore car sales data by body style, color, dealer region, and other attributes, as well as view a detailed breakdown of each sale.
Key Features:
Sales Overview Dashboard:
KPI Metrics: Real-time display of YTD, MTD, and YOY sales growth, along with average price analysis. These metrics help track the overall performance of the dealership.
Weekly Trend Analysis: A line chart that visualizes weekly sales trends throughout the year, helping to identify sales fluctuations over time.
Sales by Body Style & Color: Pie charts that break down sales by car body styles (e.g., sedan, SUV) and car colors, providing insights into customer preferences.
Sales by Dealer Region: A map chart that visualizes the geographical distribution of sales across different dealer regions, offering insights into regional performance.
Details Dashboard:
Comprehensive Data Grid: A detailed table showing all relevant car sales information such as car model, body style, color, sales amount, dealer region, and date of sale. This helps users drill down into specific sales and gain granular insights.
Company-Wise Sales Tracking: A grid displaying the YTD sales for each car manufacturer, allowing users to analyze which companies are performing best in terms of sales volume.
Interactive Features:
Navigation Buttons: These buttons allow users to seamlessly switch between the Overview and Details dashboards, enhancing the user experience.
Filters: Users can filter data by car body style, color, and region to explore different dimensions of the data, enabling a deeper analysis of sales trends.
Link to the dashboard file: Click here
