Turn Data Tables into Interactive Dashboards

Visuals are important when you need a quick glance at the data.  Your staff and community stay engaged longer when information is easily retained and accessible.  

Let me share with you how I went from a plain chart to a dashboard that updates in real time!

It is easy to take a simple google spreadsheet and transform it into an interactive chart that updates in real time.

Step 1:  Open any existing Google Spreadsheet.  

We are currently tracking COVID19 cases in the district.  However, you can use any spreadsheet that you currently have in your google account.

2.  Open Data Studios

  Click Choose Create Report (top left of the screen/dashboard)

3.  Choose Add Data

4. A selection of GOOGLE CONNECTORS will appear.  Click Google Sheets (if applicable to your data source)

5. Locate your spreadsheet from the list.  

For me, I chose School ISD COVID Tracker.

6. Use the text fields to draw text boxes and select fonts and color options.

7.  Select Your Data to Place in your Chart.

Here is the part that can be a bit tricky to figure out.  From the Available Fields section, drag your data into the type of graph you previously selected.  For example, I wanted to graph Active Student Cases and Active Staff Cases.   Therefore, I selected these two and dragged them onto the dashboard and right into the bar graph I selected.  If the graph does not satisfy your needs, simply delete it and pick another type of chart or remove some of the metrics/dimensions.

8.  Share Your Report

I wanted my report to be a “live” document on the district’s website, so I used the link option to share it. Please note that if you download it in a PDF the document is not live.  However, if that is not a problem for you, PDF is a great choice.  

I am also thinking about the Schedule Email Delivery option for the future.  For some projects, it would be great to see the data either at the beginning or end of each week to see how it changes.

I hope you have enjoyed this short tutorial.  

Picture of Stephanie McConnell

Stephanie McConnell

I’m Stephanie, and I’m the face behind Principal Principles. I’m a former principal turned educational consultant, presenter, and edupreneur. I’m obsessed with giving school leaders the tools they need to lead a successful school.

4 Responses

  1. Love love love this…I would love it more if you could do a quick video of how you got that information in data studio…I am playing with it, and got lost when I added the graph.

  2. I would love a tutorial, too! This is great! I am a testing coordinator, and this is a great tool that I could use!

Leave a Reply

Your email address will not be published. Required fields are marked *

Hi, I'm Stephanie

Hello friend! Welcome to Principal Principles. I’m Stephanie, and I’m the face behind Principal Principles. I’m a former principal turned educational consultant, presenter, and edupreneur. I’m obsessed with giving school leaders the tools they need to lead a successful school.

Categories

Join the Facebook Group

Join over 63,000 leaders in our Facebook group!  Principal Principles Leadership is a professional learning network for future and current school leaders. We share ideas and resources every day!

Sign up for the newsletter.

A description of what the benefit is of joining your list.  Updates, sale notifications, resources?  

New in the SHop

You might also be interested in....