Project Objective:

This project focuses on building an end-to-end interactive dashboard in Power BI to analyze and visualize car sales data. The objective is to track sales trends over time, compare performance across various dimensions, and enable users to interact with the data through dynamic visuals and filters.

🔧 Data Preparation & Transformation:

• Performed data cleaning using Power Query, ensuring column consistency, correct data types, and removal of null or duplicate values.
• Assessed column quality and distribution to validate data integrity before modeling.
• Built a custom Calendar Table using DAX to account for non-sales days (e.g., weekends, holidays), enabling accurate data-based analysis.

🔗 Data Modeling:

Applied a Star Schema model with:

• Calendar table as the primary (dimension) table.
• Car Sales table as the fact table.
• Created one-to-many relationships between calendar and sales data for accurate aggregation and filtering.
• Enabled efficient slicing and time intelligence across multiple visuals.

📊 Key KPIs & DAX Calculations:

Developed dynamic KPIs using DAX time intelligence functions to calculate:

• YTD, MTD, YOY, and PYTD for Total Sales, Cars Sold, and Average Price.
• Difference between YTD and PYTD, with conditional formatting:
• Green indication for positive growth.
• Red indication for negative values.

📈 Dashboard Visuals:

• YTD Sales Weekly Trend – Area chart with a dynamic max point label.