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 25, 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

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
Related

tutorial

Spreadsheets with Tableau

In this tutorial, you will learn how to analyze and display spreadsheet data using Tableau and make more data-driven decisions.
Parul Pandey's photo

Parul Pandey

14 min

tutorial

Pivot Tables in Spreadsheets

Learn how to organize rows and columns, add values, find the sum of revenue, and finally apply filtering to select a subset of data from a given dataset.
Aditya Sharma's photo

Aditya Sharma

10 min

tutorial

Time Series Analysis with Spreadsheets Tutorial

In this tutorial, you'll learn basic time-series concepts and basic methods for forecasting time series data using spreadsheets.
Avinash Navlani's photo

Avinash Navlani

9 min

tutorial

Getting Started with Spreadsheets

This tutorial will give you a basic understanding of the terminology in spreadsheets along with learning how to create a basic table.
Ryan Sheehy's photo

Ryan Sheehy

5 min

tutorial

Graphs in Spreadsheets

In this tutorial, you'll learn how to create visualizations to display data and gain more meaningful insights with spreadsheets.
Aditya Sharma's photo

Aditya Sharma

12 min

tutorial

Linear Programming with Spreadsheets

Learn how to use spreadsheets to solve linear programming problems graphically.
Avinash Navlani's photo

Avinash Navlani

10 min

See MoreSee More