Analyzing Carbon Footprints in SQL

Have you ever wondered about the carbon footprint of your jeans or soft drink? In this code-along, we’ll use SQL to explore product carbon footprints at companies like Levi’s and Coca-Cola.

Understanding emissions along a product’s lifecycle is important to achieving the steep carbon reductions required to meet global carbon goals. Our dataset shows how product emissions have changed over the years, and which part of the product’s life is most problematic for the environment. Watch this code-along and use your SQL powers for planet earth!

Key Takeaways

• Filter data to spotlight information of interest

• Calculate metrics to summarize data

• Analyze and visualize data changes over time