1.Automotive Catalog Fuel Economy Analysis
Automotive Catalog Analyst · 2026
An automotive catalog analyst utilized a data cleansing tool to transform a messy legacy CSV export riddled with missing value question marks and incorrect numeric formatting into a clean dashboard. The resulting visualization compares vehicle performance from 1970 to 1982, revealing that Japan leads in efficiency at 30.4 mpg across 79 models, while the USA lags at 20.1 mpg across 249 models. Text insights highlight a strong inverse relationship of -0.832 between weight and mpg, supported by a line chart tracking the steady climb in average fuel economy.
What it shows:
Cleaned datasets enable accurate regional comparisons and reveal critical performance trends over time.




