Pivot Tables with Google Sheets & Looker Studio Dashboard Tutorial

Learn Google Sheets & Excel Spreadsheets · Beginner ·📊 Data Analytics & Business Intelligence ·3y ago

About this lesson

Support This Channel https://www.patreon.com/chicagocomputerclasses Tutorial: Create Pivot Tables with Google Sheets data and present in a Looker Studio (Data Studio) dashboard. 00:00 Pivot Tables - Introduction 02:54 Create a Pivot Table with Google Sheets Data 17:59 Add Multiple Metrics, Values, Measures to Your Pivot Table 20:44 Create a Dashboard with Multiple Pivot Tables 24:42 Group Dates in Pivot Tables by Year, Month and more 27:27 Sort Results in a Pivot Table 28:52 Add Filters, Slicer Controls to Pivot Tables 31:45 Filter Pivot Tables by Date Range using Date range control 33:58 Rename Looker Studio Dashboard Pages 34:48 Add Calculated Fields to Pivot Tables 37:38 Expand-Collapse Rows in a Pivot Table 38:36 Optional Metrics in Looker Studio #pivottables #googlesheets

Original Description

Support This Channel https://www.patreon.com/chicagocomputerclasses Tutorial: Create Pivot Tables with Google Sheets data and present in a Looker Studio (Data Studio) dashboard. 00:00 Pivot Tables - Introduction 02:54 Create a Pivot Table with Google Sheets Data 17:59 Add Multiple Metrics, Values, Measures to Your Pivot Table 20:44 Create a Dashboard with Multiple Pivot Tables 24:42 Group Dates in Pivot Tables by Year, Month and more 27:27 Sort Results in a Pivot Table 28:52 Add Filters, Slicer Controls to Pivot Tables 31:45 Filter Pivot Tables by Date Range using Date range control 33:58 Rename Looker Studio Dashboard Pages 34:48 Add Calculated Fields to Pivot Tables 37:38 Expand-Collapse Rows in a Pivot Table 38:36 Optional Metrics in Looker Studio #pivottables #googlesheets
Watch on YouTube ↗ (saves to browser)
Sign in to unlock AI tutor explanation · ⚡30

Related Reads

Chapters (12)

Pivot Tables - Introduction
2:54 Create a Pivot Table with Google Sheets Data
17:59 Add Multiple Metrics, Values, Measures to Your Pivot Table
20:44 Create a Dashboard with Multiple Pivot Tables
24:42 Group Dates in Pivot Tables by Year, Month and more
27:27 Sort Results in a Pivot Table
28:52 Add Filters, Slicer Controls to Pivot Tables
31:45 Filter Pivot Tables by Date Range using Date range control
33:58 Rename Looker Studio Dashboard Pages
34:48 Add Calculated Fields to Pivot Tables
37:38 Expand-Collapse Rows in a Pivot Table
38:36 Optional Metrics in Looker Studio
Up next
This could be the most perfect data frontend
Matt Williams
Watch →