Power BI Report Summary - Evolution of Car Efficiency and Fuel Costs

Objectives:

The primary objectives of this Power BI report were to analyze information on the cheapest cars based on miles per gallon (MPG) and investigate trends over the years in average horsepower, average weight, cylinder size, and displacement. Additionally, the aim was to determine if there is a correlation between car weight and MPG.

Insights:

1. Weight and MPG Correlation:
   • A strong correlation was identified between car weight and MPG.
   • The reduction in vehicle weight over the years has significantly contributed to cheaper fuel costs, as lighter cars tend to have better fuel efficiency.
2. Cylinder Capacity Impact:
   • The study revealed a reduction in cylinder capacity over the years.
3. This decrease in cylinder size has played a role in making fuel more affordable, indicating that smaller engine capacities are associated with improved fuel efficiency.
4. Horsepower and Weight Trends:
   • Both horsepower and weight exhibited a decreasing trend over the years.
   • The reduction in horsepower suggests that modern cars do not require as much power, likely due to the overall decrease in vehicle weight.

Conclusion:

In conclusion, the analysis indicates a positive evolution in fuel efficiency and cost savings over the years. The key factors contributing to cheaper fuel include the reduction in car weight, cylinder capacity, and horsepower. The correlation between weight and MPG underscores the importance of advancements in vehicle design and technology, leading to a notable improvement in making cars more economical in terms of fuel consumption. This report provides valuable insights for both consumers and the automotive industry, highlighting the successful efforts to enhance fuel efficiency and reduce fuel-related expenses.