Looker Studio TCEA CEC

Start

Data Dashboards Made Easy: Coach Like a Pro with Looker Studio

PRESENTATION

Start

Lookerstudio

PRESENTATION

Thanks

Resources

Examples

Create a Dashboard II

Create a Dashboard

Link the Data

Let's Make a Form

It starts with Data

Demonstration

Training Team

Getting Started

Why Looker Studio

Index

Your Training Team

Belinda howell

BA in History, Idaho State UniversityTaught Middle School Social Studies Campus Instructional Technology Specialist Employee Excellent Award, Spring ISD, 2021Digital Learning Coach / SS Coach Digital Learning Specialist in Aldine ISD

Dan Larson

Masters Degree in Education Leadership Elementary School Teacher in Spring ISDTeacher of the Year 2006/2020Digital Learning Coach in Spring ISDDigital Learning Specialist in Aldine ISDFounder of TechEdEdu

looker studio

Getting Started

Key benefits for administrators include:Simplified Data Monitoring: Create customizable dashboards to track key metrics like attendance rates, academic progress, and student demographics. Visualizations (charts, graphs, maps) make trends easy to spot and understand.Data-Driven Decision Making: Identify areas of strength and areas needing improvement, enabling targeted interventions and resource allocation.Enhanced Communication: Share visually appealing reports with teachers, staff, and parents, fostering collaboration and transparency.Time Savings: Automate report generation and reduce manual data analysis, allowing more time for strategic planning and student support.Looker Studio empowers administrators to move beyond spreadsheets and static reports, fostering a data-driven culture where informed decisions drive student success.

why looker studio?

Demonstration

Create your Dashboard

Access your data

https://bit.ly/TCEACECSet2

Collect Data:

Formats

Whether your a Google District using Google Forms or a Microsoft District using Forms, you first need to decide what information you want to collect for your dashboard

It starts with data

bit.ly/LSFormCopy

Demo Form Link

Together we will create a demonstration form for you to use to build your Looker Studio Dashboard. Click the link below to make a copy of our demo form.

Let's Make a Form

The more you do the better your Dashboard will be....

Take 5 minutes to fill in your practice Form with at least 5 different data sets. Choose different answers to get a good blend of data as we go through and set up you dashboard.

We Need Some Data

Using your Form, Link it to a new Spreadsheet

Time to Link our data to our Spreadsheet

A close up look at the Looker Studio dashboard features.Click on the blue buttons to learn more about that section.

Creating our looker studio dashboard

• Click add a chart
• Click on Scorecard - Total
• Use the Style Tab to adjust font, font size, font color and other settings of both control boxes just added.

• Click add a control
• Click on Date range Control
• Use the Style Tab to adjust font, font size, font color and other settings of both control boxes just added.

• Click add a control - Click Dropdown list
• Click on Chart SETUP tab
• Ensure timestamp is in Date Range dimension
• Enter 'Enter First Name Last Name in Control Field
• Insure Show values and Compact numbers are checked in Record Count

PROCESs set 6

Process set 5

PROCESs set 4

Let's build a dashboard

PROCESs set 3

• Determine if auto-created chart/graphs are valid
• Click on and delete
• Add a title to your Dashboard

PROCESs set 2

• Check data section to ensure all data fields have synced
• Select your theme and layout

Process set 1

• Open your Google Sheet
• Click on Extenstions
• Click on Looker Studio
• Click on Create a Report
• Select options
• Click Create button

• Click add a chart-add a Pie Chart
• Click on Chart SETUP tab
• Enter timestamp in Date Range dimension
• Place 8.6A TEK in Dimension field
• Place First Name, Last Name in Metric field

• Go to Menu Bar
• Click on Page
• Click on New Page
• Click on Manage Pages
• Name Dashboard pages
• Go to Page 2

• Click add a chart - add a table
• Ensure timestamp is in Date Range dimension
• Place Enter first name, last name in Dimension field
• Place Score in Metric field
• Click on Chart Style tab - explore different settings independently

• Let's look at FILTERS
• Go Back to Data SETUP tab and click on Add Filter
• Select:
• EXCLUDE
• 2.4 TEK
• Equal to
• 15

PROCESs set 12

• Click on Chart STYLE tab
• Click on Show Title
• Add a title
• Adjust title font and style
• Adjust table header
• Adjust table colors
• Adjust table body
• Adjust background and border

Process set 11

• Click add a chart - add a table
• Click on Chart SETUP tab
• Ensure timestamp is in Date Range dimension
• Enter 2.4C and Enter Name data in Dimension

PROCESs set 10

Let's build a dashboard

PROCESs set 9

PROCESs set 8

Process set 7

• Go to Menu Bar
• Click on Page
• Click on New Page
• Click on Manage Pages
• Name Dashboard pages
• Go to Page 3

PROCESs set 15

• Click on Chart STYLE tab
• Click on Show Title
• Add a title
• Adjust title font and style
• Adjust table header
• Adjust table colors
• Adjust table body
• Adjust background and border

Process set 14

PROCESs set 13

Let's build a dashboard

• Create a chart or graph on your own
• Prepare to share out what you created

examples and ideas

https://bit.ly/TechnicallyEducatingEducators

Technically Educating Educators Website LInk

bhowell.tee@gmail.com

dlarson.tee@gmail.com

resources

Belinda Howell

Daniel (Dan) larson

Menu Bar

Add Controls, Charts and Graphs

• Looker Studio Formats......with many others not listed.

Chart Style Section

Use this setion to determine what you want your data to look like on your dashboard charts and graphs. Adjust font, color, labels....

Data Dashboard

• This is where you build your data dashboard
• You can add additional pages
• Add a title and controls to your dashboard

Chart Setup Section

• Select which data you want to use to create different charts and graphs.
• Select the main dimension that you want to display on the dashboard
• You can determine how you want data sorted
• Use the filter tool to adjust the output to fit your specific need

Data

The data you connect to appears here. Notice the fields you can create your dashboard with are the columns from your data sheet.You can add more than one data sheet, using multiple sheets within your worksheet.You can also blend your data together pulling from different sheets collectively to use in one data set.