Autoplay
Autocomplete
HTML5
Flash
Player
Speed
Previous Lecture
Complete and continue
Build Dashboards With Google Sheets and Data Studio
Chapter 1: Course Introduction
Lesson 1: Introduction (3:28)
Lesson 2: About the Author (2:20)
Lesson 3: How is this course structured? (1:22)
Lesson 4: Why use Google Sheets to build your dashboards? (4:25)
Lesson 5: What is a dashboard? (6:28)
Join the course Facebook Group
Chapter 2: Static Sales Dashboard
Lesson 6: Introduction to the Static Sales Dashboard (1:20)
Lesson 7: The raw data (8:34)
Lesson 8: Setting up the Summary Data Table (4:00)
Lesson 9: Introduction to Pivot Tables (7:57)
Lesson 10: Creating the Revenue Chart (5:21)
Lesson 11: Using Pivot Tables to breakdown Sales by Channel (5:21)
Lesson 12: Creating the Sales Channel Chart (3:16)
Lesson 13: More pivot table practice! (4:39)
Lesson 14: Creating a Geographic chart to show sales by US State (5:28)
Lesson 15: Advanced features of pivot tables to find the Top 10 products (5:07)
Lesson 16: Building our Sales Dashboard Part 1 (9:47)
Lesson 17: Building our Sales Dashboard Part 2 (6:22)
Lesson 18: Building our Sales Dashboard Part 3 (9:32)
Lesson 19: Building our Sales Dashboard Part 4 (5:40)
Lesson 20: Sharing your dashboard (10:14)
Chapter 3: Dynamic dashboards
Lesson 21: Interactive dashboard introduction (1:38)
Lesson 22: The raw data for the interactive dashboard (4:56)
Lesson 23: Named ranges in Google Sheets (alternative method to lesson 23) (4:38)
Lesson 24: Interactive dashboard data validation (4:57)
Lesson 25: Interactive dashboard staging tables 1 (10:24)
Lesson 26: Interactive dashboard staging tables 2 (10:59)
Lesson 27: Dynamic charts (4:44)
Lesson 28: Interactive dashboard build 1 (15:24)
Lesson 29: Interactive dashboard build 2 (6:27)
Chapter 4: Dynamic Sales Dashboard
Lesson 30: Dynamic sales dashboard introduction (1:18)
Lesson 31: Interactive sales data validation (3:02)
Lesson 32: Dynamic Key Performance Indicators (4:26)
Lesson 33: Dynamic revenue table and chart (6:06)
Lesson 34: Dynamic sales channel chart (3:59)
Lesson 35: Dynamic sales geographic chart (6:49)
Lesson 36: Dynamic Top 10 table (9:35)
Lesson 37: Interactive sales dashboard final build (9:09)
Chapter 5: Real Estate dashboard using Google Forms
Lesson 38: Real estate dashboard introduction (3:42)
Lesson 39: Real estate dashboard raw data (2:20)
Lesson 40: Using Google Forms to collect data (8:42)
Lesson 41: Real estate sales funnel chart (9:04)
Lesson 42: Agent Performance stacked bar chart (6:50)
Lesson 43: Real estate financial charts (12:11)
Lesson 44: Real estate detailed agent breakdown charts (10:56)
Lesson 45: Real estate dashboard build 1 (11:59)
Lesson 46: Real estate dashboard build 2 (6:08)
Chapter 6: Digital marketing dashboard
Lesson 47: Digital marketing dashboard introduction (5:17)
Lesson 48: Creating a dashboard settings tab (5:49)
Lesson 49: Introducing the Google Analytics add-on (4:49)
Lesson 50: Advanced use of the Google Analytics add-on (14:18)
Lesson 51: Data staging part 1 (14:11)
Lesson 52: Data staging part 2 (15:16)
Lesson 53: Dashboard panels and sparklines for our Digital Marketing dashboard (15:10)
Lesson 54: Adding charts to our Digital marketing dashboard (9:50)
Lesson 55: Alternative sparkline chart (4:31)
Lesson 56: Advanced formulas to add context to our Digital marketing dashboard (7:27)
Lesson 57: Add comparison formulas for analysis to our Digital Marketing dashboard (19:13)
Lesson 58: Format the Digital Marketing dashboard to make it look professional (5:57)
Lesson 59: Fire emoji bonus! (5:45)
Chapter 7: Adding social metrics and customizing web dashboard with Apps Script
Lesson 60: Introduction to the Social Media metrics and Apps Script dashboard tricks (2:36)
Lesson 61: Import formulas to scrape social media data (12:10)
Lesson 62: Import formulas to scrape Alexa web ranking data (6:02)
Lesson 63: Introduction to the Apps Script language (11:28)
Lesson 64: Use Apps Script to save copy of social media data (10:49)
Lesson 65: Build social media panels in our dashboard (21:57)
Lesson 66: Build the Alexa web ranking panel in our dashboard (5:36)
Lesson 67: Add a website uptime monitor to our dashboard (13:39)
Lesson 68: Add themes to our dashboard with Apps Script (5:33)
Lesson 69: Automatically distribute dashboards via email using Apps Script (5:02)
Lesson 70: Set up triggers to run our dashboard automatically (5:48)
Chapter 8: Data Studio
Lesson 71: Introduction to Google Data Studio (8:33)
Lesson 72: The basics of Data Studio (20:28)
Lesson 73: Control data using filters in Data Studio (6:59)
Lesson 74: Data Sources and Calculated Fields in Data Studio (12:42)
Lesson 75: Mobile Reporting dashboard example in Data Studio (15:33)
Lesson 44: Real estate detailed agent breakdown charts
Lecture contents locked
Enroll in Course to Unlock
If you're already enrolled,
you'll need to login
.