Skip to main content
HomeCode-alongsData Analysis

Analyzing Carbon Footprints in SQL

In this code-along, we’ll use SQL to explore data of product carbon footprints.
Feb 2023
Code along with us onCode Along

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


Learn Topics Related to This Code-Along

Live Training: Analyzing Olympics Data with SQL and Python

Learn how to load data from different sources and perform exploratory analyses.


Spend Less Time in Spreadsheets with SQL

Hate wrangling data in spreadsheets? SQL does it better.



Exploring Astronaut Activities in SQL

In this live training, we use string cleaning to process and analyze a database
Justin Saddlemyer's photo

Justin Saddlemyer


Exploratory Data Analysis in SQL for Absolute Beginners

Learn the basics of exploring new datasets using SQL.
Jasmin Ludolf's photo

Jasmin Ludolf


Getting Started with Data Analysis in Snowflake using Python and SQL

In this code-along session, you will learn how to use Snowpark Python and SQL to perform data analysis in the Snowflake Data Cloud.
Vino Duraisamy's photo

Vino Duraisamy


Analyzing NASA Planetary Exploration Budgets in SQL

We're using SQL and DataCamp Workspace to explore a dataset on NASA's budget
Richie Cotton's photo

Richie Cotton


Using Joins to Analyze Book Sales in SQL

Learn how to join data together to get it into a state for analysis.
Tim Sangster's photo

Tim Sangster


Free Trial Performance Analysis in SQL

Learn how to use SQL to analyze marketing data for a free trial of a product
John Brazier-Beckett's photo

John Brazier-Beckett

See MoreSee More