🚗 Vehicle Sales Analysis 📊📈

📄 Dataset

• link: (https://www.kaggle.com/datasets/syedanwarafridi/vehicle-sales-data/data)

Dataset Description

• Key Features:
  • Vehicle Details: Includes specific information about each vehicle, such as its make, model, trim, and manufacturing year.
  • Transaction Information: Provides insights into the sales transactions, including selling prices and sale dates.
  • Market Trends: MMR values offer an estimate of the market value of each vehicle, allowing for analysis of market trends and fluctuations.
  • Condition and Mileage: Contains data on the condition of the vehicles as well as their odometer readings, enabling analysis of how these factors influence selling prices.

🔨 Tools Used & Reason

• Python: Date Cleaning, Feature Extraction.
• Power Query: Data Transformation.
• PowerBI: Interactive Visualization.

📝 Analysis Topics ❓

• Average Selling Price: What is the average price for each car brand and model?

• Transmission Type: Compare the average selling prices, conditions, and odometer readings between automatic and manual transmission cars.

• Color Distribution: Examine the distribution of car colors and investigate if color influences the selling price.

• Condition vs. Price: Analyze how the condition rating of a car affects its selling price.

• Odometer Analysis: The effect of odometer readings on the selling price across different car makes and models.