Business Intelligence project showcasing KPIs, Charts and Report for sales growth and understanding key metrics using Power BI
🚗 Car Sales Analysis – Power BI Business Intelligence Project 📌 Project Overview
This project delivers an end-to-end Business Intelligence solution using Power BI to analyze car sales data and enable KPI-driven, data-backed decision-making. It covers the full analytics lifecycle — from business requirement analysis and ETL to advanced DAX, time intelligence, and executive reporting.
🎯 Business Problem
Sales data was fragmented and reported through static reports, limiting visibility into:
Time-based sales trends
Pricing and volume movement
Regional and dealer-level performance
The goal was to design a scalable, interactive dashboard that transforms raw transactional data into actionable business insights.
📊 Dataset Details
Total Records: 23,906
Total Columns: 16
Data Domains
Customer demographics
Dealer demographics and regions
Car attributes (company, model, engine, transmission, body style, color)
Sales parameters (price, transaction date)
🛠️ Technical Work Performed 🔹 Data Engineering & ETL
Executed a complete ETL pipeline using Excel and Power Query
Performed data cleaning, validation, and transformation
Normalized data types and structured relationships
Built an optimized star-schema data model for reporting efficiency
🔹 Time Intelligence Implementation
Created a Calendar Table using DAX
Implemented date hierarchies:
Year
Month
Week
Enabled advanced time-based analysis using:
TOTALYTD()
TOTALMTD()
SAMEPERIODLASTYEAR()
Supported YTD, MTD, PYTD, and YoY performance comparisons
🔹 KPI & DAX Development
Developed advanced DAX measures for:
YTD & MTD Total Sales
YTD & MTD Average Price
YTD & MTD Cars Sold
YoY Growth metrics
PYTD variance analysis
Applied conditional logic and calculations to support executive-level insights.
🔹 Data Modeling & Optimization
Designed efficient relationships between fact and dimension tables
Managed filter context and evaluation context for accurate calculations
Applied conditional formatting to highlight trends, variances, and performance gaps
🔹 Data Visualization & Reporting
Designed an interactive Power BI dashboard with:
Weekly YTD sales trend (line chart)
Sales distribution by body style and color (pie charts)
Regional sales performance using map visuals
Company-wise sales trends in tabular format
Detailed transaction-level drill-through table
Focused on UX clarity and executive readability.
🔹 Business Analysis & Insights
Identified seasonality and sales growth patterns
Analyzed pricing vs volume impact on revenue
Evaluated dealer and regional performance
Derived business requirements and strategic recommendations from KPI behavior
🧰 Tools & Technologies
Power BI
DAX (Time Intelligence, Measures, Calculated Columns)
Power Query (ETL & Data Transformation)
Excel
Business Intelligence & Data Visualization
📈 Business Value Delivered
Centralized and automated sales reporting
Improved pricing and product strategy decisions
Enhanced regional and dealer performance tracking
Shift from static reports to continuous KPI monitoring
📁 Repository Contents
Power BI Dashboard (.pbix)
Business Problem Statement
Project Report
Executive Presentation (PPT)
✅ Key Takeaway
This project demonstrates strong hands-on experience in business requirement analysis, data modeling, advanced DAX, and executive storytelling, effectively bridging the gap between raw data and strategic decision-making.
Recruiter Note: This repository reflects real-world BI workflows, including requirement analysis, ETL, modeling, and insight generation — not just dashboard creation.