Car Pricing Analysis (ETL) is a data analytics project focused on extracting meaningful insights from raw car pricing datasets using Excel and Power Query. The project emphasizes data cleaning, transformation, automation, and visualization to uncover pricing trends and financial patterns that support informed decision-making.
📂 Dataset
The complete dataset along with charts and Power Query transformations can be downloaded below:
🔽 Download Excel File: CARDATASET with chart and powerquery.xlsx
This file includes: • Cleaned dataset • Power Query transformation steps • Pivot tables • Interactive charts • Pricing analysis reports
⸻
Project Objective
Car pricing data often contains inconsistencies, unstructured entries, and complex financial parameters. Manual analysis is time-consuming and prone to errors.
This project aims to: • Perform ETL (Extract, Transform, Load) using Power Query • Analyze pricing trends across car models and manufacturers • Identify key financial parameters and percentage-based metrics • Provide stakeholders with structured, data-driven insights
⸻
Problem Statement • Raw car pricing data is unclean and inconsistent • Manual reporting leads to repetitive work and inefficiencies • Lack of automated transformation processes • Difficulty in identifying pricing trends and KPIs quickly
⸻
Proposed Solution
This project implements: • Automated data cleaning and transformation using Power Query • Structured data modeling within Excel • Dynamic pivot tables for flexible reporting • Visual dashboards and charts for pricing insights • Percentage-based and financial metric analysis
⸻
Key Features
1️⃣ Comprehensive Data Analysis • Cleaned and structured raw pricing data • Identified trends across: • Car models • Manufacturers • Market categories • Derived financial insights and pricing patterns
⸻
2️⃣ ETL Using Power Query • Extracted raw dataset • Transformed data through: • Data type correction • Column restructuring • Missing value handling • Standardization • Loaded clean data into Excel for reporting
This automation ensures: • Accuracy • Efficiency • Scalability for large datasets
⸻
3️⃣ Pivot Tables & Dynamic Reports • Designed interactive pivot tables • Summarized KPIs and financial metrics • Enabled flexible filtering and comparison • Highlighted pricing distribution and percentage contributions
⸻
4️⃣ Data Visualization & Insights • Created charts to visualize: • Pricing trends • Percentage analysis • Financial comparisons • Delivered actionable insights through visual storytelling • Focused on business-aligned recommendations
⸻
Visualizations Used • Bar Charts (Model-wise pricing comparison) • Column Charts (Manufacturer trends) • Pie Charts (Percentage distribution) • KPI-based summary reports
⸻
Tools & Techniques Used • Microsoft Excel • Pivot Tables • Advanced Formulas • Conditional Formatting • Power Query • ETL Process • Data Cleaning • Data Transformation • Data Visualization • Interactive charts • Structured reporting dashboards
⸻
ETL Process Overview
Extract: Imported raw car pricing dataset.
Transform: • Cleaned inconsistencies • Standardized financial parameters • Calculated percentage metrics • Structured columns for reporting
Load: Loaded processed data into Excel for dynamic analysis and visualization.
⸻
Use Case
This project is suitable for: • Business analysts analyzing pricing strategies • Automobile market researchers • Students learning ETL using Excel • Professionals building automated reporting systems
⸻