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

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

blog

The 4 Best Data Analytics Bootcamps in 2024

Discover the best data analytics bootcamps in 2024, discussing what they are, how to choose the best bootcamp, and you can learn.

Kevin Babitz

5 min

blog

A Guide to Corporate Data Analytics Training

Understand the importance of corporate data analytics training in driving business success. Learn about key building blocks and steps to launch an effective training initiative tailored to your organization's needs.

Kevin Babitz

6 min

tutorial

How to Use the XLOOKUP Excel Function with Multiple Criteria

This tutorial discusses the purpose and syntax of the XLOOKUP Excel function, its advantages concerning its predecessors, the two main ways of using XLOOKUP with multiple criteria including their pros and cons, extending functionality through the optional parameters, and the way of running a similar search in older Excel versions.
Elena Kosourova's photo

Elena Kosourova

0 min

tutorial

How to Calculate Confidence Intervals in Excel

A beginner-friendly, comprehensive tutorial on understanding Confidence Interval calculations in Microsoft Excel.
Arunn Thevapalan's photo

Arunn Thevapalan

8 min

tutorial

Monte Carlo Simulation in Excel: A Complete Guide

A beginner-friendly, comprehensive tutorial on performing Monte Carlo Simulation in Microsoft Excel, along with examples, best practices, and advanced techniques.
Arunn Thevapalan's photo

Arunn Thevapalan

9 min

code-along

Getting Started With Data Analysis in Alteryx Cloud

In this session, you'll learn how to get started with the Alteryx AI Platform by performing data analysis using Alteryx Designer Cloud.
Joshua Burkhow's photo

Joshua Burkhow

See MoreSee More