Cars Store Sales Analysis

An end-to-end sales analysis project focused on transforming raw sales data into a structured data model and an interactive dashboard for business insights.

? Project Overview

This project analyzes sales performance for a car store by cleaning, structuring, and modeling the data before building a dynamic Excel dashboard.

The goal was to create a reliable data pipeline from raw database tables to a fully interactive reporting solution.

? Tools & Technologies

SQL – Data cleaning, normalization, ID generation

ODBC – Database connection to Excel

Excel Power Query – Advanced queries using CTE statements

Excel Power Pivot – Data modeling & relationships

Excel Dashboard – Data visualization & reporting

? Project Workflow

1️⃣ Data Cleaning & Normalization (SQL)

Cleaned inconsistent and duplicate records

Normalized raw data into structured tables

Generated unique IDs for proper relational modeling

Ensured data integrity and consistency

2️⃣ Data Import (ODBC Connection)

Connected SQL database to Excel using ODBC

Imported structured tables directly into Excel

3️⃣ Data Transformation (Power Query)

Used Advanced Queries with CTE (Common Table Expressions)

Extracted only the required datasets for reporting

Optimized queries for performance and clarity

4️⃣ Data Modeling (Power Pivot)

Created relationships between fact and dimension tables

Built a structured relational model

Designed measures and calculated fields

5️⃣ Dashboard Development

Developed an interactive dashboard

Added performance KPIs

Enabled filtering and dynamic analysis

? Key Insights Delivered

Sales performance trends

Top-performing car models

Revenue breakdown analysis

Customer purchase patterns

Regional performance comparison

? Project Outcome

This project demonstrates:

Strong SQL data preparation skills

Understanding of relational data modeling

Ability to connect databases to Excel

Advanced Excel reporting using Power Pivot

End-to-end business intelligence workflow