Learn how to:

  • Set up your data spreadsheets to connect to Data Studio

  • Connect your spreadsheets (data resource) to Data Studio

  • Understand how to adjust basic formatting of charts, text, shapes, page layouts, and page views

  • Create basic charts such as tables, bar charts, line charts and score cards

  • Adjust the colors and fonts with themes

  • Create interactive filters for exploratory data

  • Learn how to share your dashboard with others via email, link, or downloadable PDF

Course curriculum

    1. Course Overview

    2. What's a Dashboard & Why Data Studio (Now Looker Studio)?

    3. Getting Your Data Ready

    4. Data Studio Layout Updates as of June 20, 2022

    5. Data Studio Interface

    6. Prepping for Success with Charts

    7. Things to Remember

    1. Introduction to Tables in GDS

    2. Tables with Bars & Tables with Heat Maps

    3. Formatting your Tables

    4. Things to Remember

    1. Scorecard Basics

    2. Scorecard Formatting & Conditional Formatting

    3. Blending Data & Showing Growth with Scorecards

    1. Pie & Donut Charts

    2. Bar Chart Basics

    3. Bar Chart Extras

    4. Combo Charts

    5. Pivot Tables

    6. Maps

    1. Design & Layout

    2. Quick Language Course Dashboard

    3. Themes, Images & Colors

    4. Filters & Controls

    5. Embedding Other Items in your Reports

    6. Connecting Google Forms

    1. Class Overview Dashboard Part One

    2. Class Overview Dashboard Part Two

    3. Simple Student Profile Dashboard Part One

    4. Simple Student Profile Dashboard Part Two

    5. Simple Student Profile Dashboard Part Three

    6. Simple Student Profile Dashboard Part Four

    7. Simple Student Profile Dashboard Part Five

About this course

  • $97.00
  • 41 lessons
  • 5.5 hours of video content


Instructor Bio:

Chris is an academic data specialist at Singapore American School. He helps school leaders and educators make sense of their data by turning it into information that informs effective decision-making. Chris has 25 years of experience in education. Starting off as an elementary classroom teacher for 17 years, he moved into an educational technology coaching role and eventually found himself helping others be more efficient with their work around data analysis and data literacy. When not jamming out on spreadsheet formulas and chart elements, Chris can be found ascending punchy climbs and bombing down drops in the jungle on his mountain bike.

Chris Smith

Academic Data Specialist