Accéder au contenu principal

Live Training: Analyzing a Marketing Funnel in Spreadsheets

Learn to query data from multiple sources, perform aggregations and visualize it
25 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

Sujets

Apprendre les sujets liés à ce 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
Apparenté

Didacticiel

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

Didacticiel

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

Didacticiel

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

Didacticiel

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

Didacticiel

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

Didacticiel

Linear Programming with Spreadsheets

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

Avinash Navlani

Voir plusVoir plus