Skip to main content
HomeCode-alongsData Analysis

Live Training: Analyzing a Marketing Funnel in Spreadsheets

Learn to query data from multiple sources, perform aggregations and visualize it
Oct 2022
View Dataset

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

Materials

Topics
Data Analysis
Spreadsheets

Learn Topics Related to This Code-Along

Spend Less Time in Spreadsheets with SQL

Hate wrangling data in spreadsheets? SQL does it better.

Webinars

Data Science for Spreadsheet Users

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

Webinars

Working with Pivot Tables in Excel

Learn how to organize rows and columns, add values, find the sum of a value, and apply filtering to select a subset of a given dataset. We’ll learn how to apply this in Excel with a retail dataset example.

Blog post