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

Materials

• Student spreadsheet

• Solution spreadsheet

• Original dataset