Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Data Analysis and Dashboards with Google Data Studio(Ian)
Introduction
Introduction (2:25)
Connect to the Google Sheets Training Data
Access the Learner Guide
Setting Up Google Data Studio
Setup Google Sheet (3:50)
Connecting to Google Sheets (5:41)
The First Report
First Report (7:26)
Practical Activity
The Scorecard Visualization
Create a Scorecard (5:20)
Practical Activity Scorecard
Method of Aggregation (9:55)
Practical Activity Method of Aggregation
Custom Calculations (4:19)
Practical Activity Custom Calculations
Custom Calcs with Tables (4:47)
Practical Activity Custom Calculations Tables
Comparison to Previous Period (7:32)
Practical Activity Comparison Period
Using Filters with Data Studio (5:12)
Practical Activity Using Filters
Year to Date Month to Date (7:33)
Practical Activity Year to Date
Filtering Scorecards (4:45)
Practical Activity Filtering Scorecards
Creating Dynamic Tables in Data Studio
Introduction to Tables (7:22)
Formatting Tables (4:27)
Practical Activity Tables
Tables with Previous Periods (4:05)
Practical Activity with Previous Periods
Year to Date, Month to Date and Similar Calculations (3:13)
Time Intelligence for Tables (8:01)
Practical Activity Time Intelligence
Time Series Graphs to learn about Trends
Time Series Graphs (6:23)
Changing the Time Frame (6:16)
Practical Activity Time Series
Styles and Formatting (7:32)
Time Series and Custom Filters (3:36)
Practical Activity Time Series
Area Graphs (5:36)
Column and Bar Graphs
Column and Bar Graphs (4:02)
Stacked Bar and 100 Percent Bar Graph (3:58)
Practical Activity Column and Bar Graph
Using Pie Graphs with Google Data Studio
Pie Graphs (3:51)
Practical Activity Pie Graphs
Mapping and Geographic Analysis
Mapping and Geographic Analysis (4:36)
Practical Activity Geographical Analysis
Scatterplot
Scatterplot (6:18)
Practical Activity Scatterplot
Publishing and Sharing Interactive Dashboards
Publishing and Sharing Interactive Dashboards (11:03)
Practical Activity Interactive Dashboards
Conclusion
Conclusion (0:46)
Connect to the Google Sheets Training Data
Download
0102 Connect to the Google Sheets Training Data.docx
Complete and Continue