The objective of this project is to analyze car manufacturers based on the features offered in their various models. By identifying models with the most preferred features, the project aims to rank car makers according to consumer feature preferences. This analysis will help stakeholders understand market trends, customer priorities, and which brands are leading in delivering feature-rich vehicles.
This project focuses on analyzing car models and manufacturers based on customer-preferred features. It identifies models with the highest number of desirable features, compares car makers on feature-rich offerings, and highlights top-rated features across all models. The analysis also explores customer satisfaction, fuel efficiency, and segment-wise feature distribution, along with recommendations for adventure driving, child safety, and preferred body types. The goal is to provide actionable insights for both consumers and manufacturers through a feature-centric dashboard.
An interactive and data-driven dashboard that helps consumers, analysts, and manufacturers make informed decisions about cars based on real-world feature preferences and segment performance.
- Microsoft Power BI
- Excel/CSV for data input
- DAX for custom KPIs and measures
Which car model offers the highest number of preferred features? Which car maker has the highest number of models with top-rated features? What is the average number of preferred features per car maker? Which features are most commonly preferred across all models? Which car maker has the highest customer satisfaction rating based on features? What is the distribution of preferred features across car segments (SUV, Sedan, Hatchback)? What percentage of a car maker's models include the top 5 preferred features? Which car maker leads in safety, entertainment, and performance features? Which car maker offers the best fuel efficiency? Which car is best suited for adventure driving? Which car model is best for child safety features? Which car body type is most preferred by customers?
- Dashboard Interaction View Dashboard
- Verify data for any missing values and anomalies, and sort out the same.
- Made sure data is consistent and clean with respect to data type, data format and values used.
- Created kpi according to the questions asked.
- load all all tables into one dashboard and apply slicer to make dynamic.
The feature-based car analysis provides valuable insights into how different car models and manufacturers align with customer preferences. By identifying the most feature-rich models and top-performing car makers, the analysis supports informed decision-making for both buyers and industry stakeholders. Key findings highlight the dominance of certain features, preferred body types, and the significance of segment-wise offerings. Overall, this project emphasizes the importance of feature integration in driving customer satisfaction, brand competitiveness, and market success.