Embedded Files
(From Data Cleaning to Tableau Dashboard: Engine Impact on MPG)
In this project, I used Tableau to explore and visualize key patterns in the Auto MPG dataset. I created interactive dashboards that highlight relationships between engine characteristics and fuel efficiency, enabling users to intuitively explore data trends and insights.
Let's have a step by step look at my analysis using Tableau -
◾ My Goal -
◾ My Goal -
I analyzed how engine-related factors (horsepower, weight, displacement, cylinders, model year, origin) impact MPG (fuel efficiency).
◾ Prepared and Cleaned the data -
◾ Prepared and Cleaned the data -
The horsepower column had missing values shown as “?”.
I converted horsepower to numeric and replaced missing values using the median (to reduce the effect of outliers).'
◾ Imported data into Tableau -
◾ Imported data into Tableau -
Used the dataset in Excel and loaded it into Tableau for analysis.
◾ Build Tableau visualizations
◾ Build Tableau visualizations
In Tableau, I created clear visuals to communicate the relationships:
Scatter Plot: MPG vs Horsepower
Scatter Plot: MPG vs Horsepower
Scatter Plot: MPG vs Horsepower (shows MPG decreases as horsepower increases)
This plot shows a negative correlation between engine horsepower and miles per gallon (MPG). As horsepower increases, MPG tends to decrease. This trend suggests that vehicles with more powerful engines are generally less fuel-efficient. This is intuitive, as stronger engines often consume more fuel to deliver higher performance.
This plot shows a negative correlation between engine horsepower and miles per gallon (MPG). As horsepower increases, MPG tends to decrease. This trend suggests that vehicles with more powerful engines are generally less fuel-efficient. This is intuitive, as stronger engines often consume more fuel to deliver higher performance.
Scatter Plot: MPG vs Weight
Scatter Plot: MPG vs Weight
The second plot reveals a strong negative correlation between a vehicle’s weight and its fuel efficiency. Heavier cars typically consume more fuel, leading to lower MPG. The relationship is more pronounced compared to horsepower, emphasizing the impact of vehicle mass on fuel consumption.
The second plot reveals a strong negative correlation between a vehicle’s weight and its fuel efficiency. Heavier cars typically consume more fuel, leading to lower MPG. The relationship is more pronounced compared to horsepower, emphasizing the impact of vehicle mass on fuel consumption.
Scatter Plot: MPG vs Displacement
Scatter Plot: MPG vs Displacement
The third scatter plot also suggests a negative relationship between engine displacement and MPG. Displacement refers to the total volume of all engine cylinders, and larger displacement typically means higher fuel consumption. This plot indicates that cars with larger engines tend to have lower fuel efficiency.
The third scatter plot also suggests a negative relationship between engine displacement and MPG. Displacement refers to the total volume of all engine cylinders, and larger displacement typically means higher fuel consumption. This plot indicates that cars with larger engines tend to have lower fuel efficiency.
Scatter Plot: MPG vs Model Year
Scatter Plot: MPG vs Model Year (positive trend: newer cars → higher MPG)
Scatter Plot: MPG vs Model Year
Scatter Plot: MPG vs Model Year (positive trend: newer cars → higher MPG)
Unlike the others, this plot shows a positive correlation between model year and MPG. Newer cars tend to be more fuel-efficient, which aligns with industry trends toward better technology, stricter fuel standards, and increased consumer demand for efficiency. The gradual increase over time confirms that MPG has improved over the years.
Unlike the others, this plot shows a positive correlation between model year and MPG. Newer cars tend to be more fuel-efficient, which aligns with industry trends toward better technology, stricter fuel standards, and increased consumer demand for efficiency. The gradual increase over time confirms that MPG has improved over the years.
Hence, our visualizations reveal that horsepower, weight, and displacement are negatively correlated with MPG, while newer model years tend to have higher MPG. These insights confirm that lighter, less powerful, and newer cars are generally more fuel-efficient.
Hence, our visualizations reveal that horsepower, weight, and displacement are negatively correlated with MPG, while newer model years tend to have higher MPG. These insights confirm that lighter, less powerful, and newer cars are generally more fuel-efficient.
◾ Created a Tableau dashboard (final deliverable)
◾ Created a Tableau dashboard (final deliverable)
Combined the visualizations into an interactive dashboard so viewers can understand the key drivers of MPG at a glance.
DASHBOARD - Analyzing Automobile Engine Impact on MPG
◾ Final insights (what Tableau helped communicate)
◾ Final insights (what Tableau helped communicate)
Weight and horsepower are the strongest negative predictors of MPG.
Newer model years and non-US origins (Europe/Japan) tend to have better MPG.
Page updated
Google Sites
Report abuse