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 -
I analyzed how engine-related factors (horsepower, weight, displacement, cylinders, model year, origin) impact MPG (fuel efficiency).
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).'
Used the dataset in Excel and loaded it into Tableau for analysis.
In Tableau, I created clear visuals to communicate the relationships:
Scatter Plot: MPG vs Horsepower (shows MPG decreases as horsepower increases)
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
Weight and horsepower are the strongest negative predictors of MPG.
Newer model years and non-US origins (Europe/Japan) tend to have better MPG.