Skip to main content

Live Training: Analyzing a Marketing Funnel in Spreadsheets

We will dig into the marketing funnel at Olist in this live training. We will cover querying data from multiple tables in a Google Sheet, processing date information, and performing aggregations on the resulting data.

Key Learnings

  • Join data from multiple locations in a Google Sheet

  • Process data in preparation for analysis

  • Perform aggregations and visualize data


  • Student spreadsheet

  • Solution spreadsheet

  • Original dataset

Ariel Hendrick Headshot
Ariel Hendrick

Director of Revenue Operations @ DataCamp

Recommended Content

Spend Less Time in Spreadsheets with SQL

Hate wrangling data in spreadsheets? SQL does it better.


Data Science for Spreadsheet Users

Use code to automate the routine tasks you hate to do in spreadsheets.


Pivot Tables in Excel

Analyze survey data using pivot tables and charts in Microsoft Excel.


Hands-on learning experience

Companies using DataCamp achieve course completion rates 6X higher than traditional online course providers

Learn More

Upskill your teams in data science and analytics

Learn More

Join 2,500+ companies and 80% of the Fortune 1000 who use DataCamp to upskill their teams.

Don’t just take our word for it.