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?

    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:

After being a classroom teacher for 17 years, Chris is now an educational data specialist and coach. He works directly with district administration, coaches, teachers and students. He currently serves on a data team and is in charge of the academic side of data collection. Chris is a Google Innovator, an Apple Distinguished Educator, and an Apple Professional Learning Specialist. He has a passion for making the lives of teachers easier by creating automated systems for mundane tasks. He is a life-long learner and continues to search for new innovations to allow both teachers and students to be creative. In his spare time, he enjoys curling up next to a good spreadsheet.

Chris Smith

Academic Data Specialist