This training program provides a comprehensive introduction to Google Data Studio, Google Sheets, and Looker, designed to equip you with essential skills for data analysis and visualization. Over three days, you'll learn how to efficiently load data into Google Sheets, connect it to Google Data Studio, and work with tables, aggregations, and custom calculations. You'll also explore powerful visualizations such as pivot tables, time series graphs, and interactive dashboards. On Day 2, we delve into Looker and LookML, covering the fundamentals of data exploration, filtering, and modeling with LookML, as well as understanding how Looker integrates with BigQuery. This hands-on, practical training will help you master the tools necessary to create insightful and dynamic reports and dashboards.
Day 1
Module 1: Introduction
Loading Data into Google Sheets
Connecting to Google Data Studio
Overview of Google Data Studio
Module 2: Working with Tables
Introduction to Tables
Creating Tables
Formatting and Sorting Tables
Multiple Measures
Conditional Formatting
Module 3: Aggregation
Introduction to Methods of Aggregation
Methods of Aggregation
Comparison Calculations
Running Total Calculations
Drill Down
Working with Dates
Module 4: Pivot Tables and Card Visualizations
Introduction to Pivot Tables and ScoreCards
Creating Pivot Tables
Comparison Calculations
Card Visualization
Module 5: Slicers and Visualization Filters
Introduction to Slicers and Visualization Filters
Text Slicers
Numeric Slicers
Date Slicers
Text Visualization Filters
Numeric Visualization Filters
Date Visualization Filters
Example Filter
Day 2
Module 6: Custom Calculations
Introduction to Custom Calculations
Create Calculations
Year Month and Day
Case Statement
Practical Activity
Completed Practical Activity
Comparisons
Module 7: Time Series Graphs
Introduction to Time Series Graphs
Create Time Series Graphs
Changing Time Periods
Styles and Formatting
Time Series Chart Options
Area Graph
Module 9: Other Visualizations
Introduction to Other Visualizations
Column and Bar Graphs
Pie Graphs
Geographical Analysis
TreeMap Graph
Scatterplot Graph
Custom Visualization
Module 10: Publishing and Sharing Interactive Dashboards
Introduction to Dashboards
Publish and Sharing Interactive Dashboards Section
