/SQL-and-Power-BI-Sales-and-Marketing-Analysis-End-to-End-Portfolio-Project

SQL-and-Power-BI-Sales-and-Marketing-Analysis-End-to-End-Portfolio-Project

Introduction:

Business Problem Statement:

This portfolio project involves a comprehensive analysis of a car sales dataset to provide insights into overall sales performance, customer preferences, fuel efficiency impact, price sensitivity, safety features' influence, and market trends.

Key Insights:

Overview of cars dataset:

  • Provides an overview of the dataset by defining the total unique car makes and car models.

Sales Performance Analysis:

  • Understands overall sales performance, identifies the best-selling models, and explores trends over the years.

Customer Preferences:

  • Analyzes customer preferences by examining the popularity of different car makes, models, body types, and colors.

Fuel Efficiency Impact:

  • Investigates the correlation between fuel efficiency (Mileage) and sales figures, identifying fuel-efficient models.

Price Sensitivity:

  • Determines the impact of pricing on sales, analyzing the relationship between car prices and customer ratings.

Safety and Features Impact:

  • Evaluates the influence of safety features, entertainment features, and overall vehicle features on customer ratings and sales figures.

Market Trend Analysis:

  • Identifies market trends by analyzing the popularity of different car makes and models over the years, investigating if certain body types or fuel types are gaining traction in the market.

Columns and Descriptions:

  • Car Make: The brand or manufacturer of the car (e.g., Toyota, Ford, Honda).
  • Car Model: The specific model name or designation of the car (e.g., Camry, Civic, F-150).
  • Year: The year the car was manufactured or released.
  • Body Type: The style or type of the car's body (e.g., sedan, SUV, truck, coupe).
  • Color Options: Different color choices available for the car.
  • Fuel Type: The type of fuel the car uses (e.g., gasoline, diesel, electric, hybrid).
  • Engine Size (L): The capacity of the car's engine (measured in liters or cubic centimeters).
  • Horsepower: The power output of the car's engine.
  • Torque (Nm): The twisting force generated by the car's engine.
  • Transmission Type: The type of transmission (e.g., manual, automatic, CVT).
  • Acceleration (0-60 mph): The time taken for the car to reach a certain speed (e.g., 0 to 60 mph).
  • Top Speed (mph): The maximum speed the car can achieve.
  • Mileage (MPG): The car's fuel efficiency in terms of miles per gallon (MPG) or liters per 100 kilometers (L/100 km).
  • Safety Features: A list of safety features included in the car (e.g., airbags, ABS, lane-keeping assist).
  • Entertainment Features: Features related to the car's audio and infotainment system.
  • Interior Features: Descriptions of the car's interior features and amenities.
  • Exterior Features: Descriptions of the car's exterior features and design elements.
  • Price ($): The cost of the car.
  • Customer Ratings: If available, include customer ratings and reviews for the car.
  • Sales Figures (Units Sold): If available, include sales data for the car.

Tools Used:

  • SQL for analyzing business problem statement
  • Power BI for visualization of the business problem statement
  • Word document for documentation

Key Insights:

  • The dataset includes information on 21 different car-making companies and 80 different car models.
  • Gasoline is the highest unit sold fuel type, surpassing electric and hybrid.
  • SUV and Sedan are the highest sold body types compared to others.

Thank You Note:

Thank you for exploring this project! For more interesting facts, feel free to explore the SQL and Power BI files.