Christmas in August?!?

Anyone reading this who works in a school district is probably running around like crazy preparing for the start to a very different school year. You may not have seen all the AMAZING updates to Data Studio which have appeared over the last two weeks, but have no fear, I'm here to fill you in! (Note that there are other new features but they aren't necessarily relevant to the use of Data Studio in K-12 education so I haven't mentioned them here.)

New Filter Controls

Previously, if you added a filter control to a Data Studio report, the default was a drop-down list, which could then be configured to (among other things) a fixed-size list. Now, fixed-size lists are one of six filter control types, with new options including a text input box (which you can configure to use EQUALS, CONTAINS, STARTS WITH, etc.), slider, and checkbox. These various options can be used to make your reports even simpler and easier to use! more info here

Parameters

I had a hard time wrapping my head around this one at first. Basically, it's a way to introduce a variable into your report that the user can change...which allowed me to create this cool algebraic Slope-Intercept explorer (which had been in my head a while but I had not figured out how to make it work with Data Studio.) The way this report works is that the data source is a range of x values, slope (m) and intercept (b) are parameters that the user can change, and then y is the result of a calculated field.

The report is just a scatter plot of x and y, which changes when the parameters are updated by the user. This is an example of a metric/numeric parameter - I am learning about some interesting ways to use dimensions/text as a parameter as well! more info here

Conditional Formatting in Pivot Tables

Previously, conditional formatting wasn't possible in Data Studio pivot tables, only regular tables. Now, pivot table conditional formatting options are single-color, so still limited, but it's certainly a huge improvement! more info here

Simplified CASE Statements for Calculated Fields

CASE statements are like IF/THEN statements in Data Studio that allow you to transform a field's values within a calculated field. In the past, you would write a CASE statement like this:

CASE

  WHEN field=value1 THEN result1

  WHEN field=value2 THEN result2

  WHEN field=value3 THEN result3

END

Now, you would write this:

CASE field

  WHEN value1 THEN result1

  WHEN value2 THEN result2

  WHEN value3 THEN result3

END

Honestly, isn't that big of a difference, and most of the time when I write a CASE statement I have to look up the syntax anyway, but it's definitely simpler to write statements this way. more info here

Filled Maps

There is a new option for "Filled Areas" within the Google Maps visualization. I updated the Massachusetts Cities and Towns report to show how this might work. Tip: if you want to sound super smart, use the word "chloropleth" instead of "filled area map." more info here

Embedded Data Sources

As you may know, until now, Data Studio reports and data sources were shown as separate items when on your Data Studio home page. If you wanted to share both a report and a data source with someone - you needed to share both items with the other person. Now, you have two options:

a) Create your data source first, then create a report and attach it to your data source. In this case, the data source is reusable, which means it's a separate item from the report. It can be used elsewhere but would need to be shared explicitly with someone who needs access. You'll still see the data source listed on your Data Studio home page.

OR

b) Create your report first, then create the data source from within the report. In this case, the data source is embedded, which means you can share the report and the data source all together. You won't see the data source listed separately on your Data Studio home page.

Just a note here that in either case, a person with view-only access to a report still does NOT have access to the data source, regardless of whether it's reusable or embedded! These really only come into play when you are sharing a report and data source for someone else to edit or copy. more info here

---------------

I look forward to seeing how YOU use these new features! (Particularly parameters which have TONS of potential!) As always, if you have new reports to share, please submit them for inclusion in the K-12 Data Studio Report Collection (recently added to Google's Data Studio Gallery) so we can all learn from each other. Best wishes for a smooth and healthy start to the school year!

Visualizing Plans for the Class of 2020

Many high schools publish a list of the plans of their graduates, but wouldn't it be fun to visualize this list on a map, to see where a school's students will disperse after graduation?

Here's a very simple template for any high school who wishes to display the plans of their 2020 graduates in a fun visual map format. Clicking on a row in the table will zoom in on the Google map to show the location, and the user can even use the "Pegman" to take a look around at Street View. Clicking the row again will bring the user back to the entire list/map.

To make your own version of this report, first create a simple Google Sheet with a single column with a header of "List." This column should have a single entry related to each student in the class, although the list would not include student names. So, for example, if two students are attending Cape Cod Community College, then "Cape Cod Community College" would appear twice in the first column of the spreadsheet. It doesn't matter what order the list is in. Most high school guidance departments would be able to export this list from Naviance or other college and career platform.

 After the Sheet is put together, you can make a copy of the report by clicking Use Template in the upper right corner of the report link. You can then connect your new Sheet as the data source for your copy of the report. If you need additional information about how to connect a report to a data source, please refer to these instructions.

You will want to check that the List field is of the type Geo > Address. You can check this through the Resource menu > Manage added data sources > Edit and check the Type column for the List field.

A few notes: Some Sheet entries may need to be tweaked to display correctly. For example, there may be multiple colleges with the same name (like Trinity College) so you may need to add a city/state in order for it to display correctly. Non-location generic entries such as "2yr college", "Employment," etc. will not display on the map but will display in the list.

You can then customize the colors, logos, etc. of the report to make it your own. (Tip: Try Extract Theme from Image using your school's logo!) I would love to see what you come up with - and congratulations to the class of 2020!

Google Maps in Data Studio

For a while now, Data Studio has had the ability to visualize data in map form. However, recently this feature was upgraded to be able to display "geo" data in Google Maps within a report. Geo data is essentially just data that represents a street address, city, country, etc. 

I had previously created a travel log report for a family member, which allowed them to update a Google Sheet with different locations they had visited, and it marked them on a map in the report. (Yes, I sometimes create reports for fun. Don't judge.) The travel log allows filtering by year, trip name, or trip operator, and I updated it to include the Google Maps functionality when it became available. Now, the map narrows in on an area of the globe when a trip is selected AND allows the user to zoom to street view and look around. Not education data, I know, but a fun way to revisit past trips until we can travel again. Check out a sample copy here (including directions to make your own). 

I started wondering if there were ways a report using this feature could become part of a student learning activity. I played around with exploring map data of Civil War battles using data I found online, but didn't get too far with it. I ended up creating a Massachusetts Cities and Towns report (based on Wikipedia entries) that allows the user to explore information like population, government type, county, and town seal. 

While I did create the data source for this report myself, I realized that it could just have easily been created by students submitting data via a Google Form. Wouldn't that be fantastic? Say your third grade has 350-ish students, and you ask them each to research one of 351 Massachusetts cities or towns, gathering population, government type, county, and a link to the town seal. Students put their findings into a Google Form, which results in a Sheet that becomes the source for a report like this one!

I would LOVE to hear some other ideas for learning activities like this, where data is collected by students, submitted via a form and then displayed on a map. If you've got an idea, I'll help you pull it off!

Google Maps in GDS: Examples and Resources

• Google Data Studio Help: Google Maps
• How to Use Google Maps in Google Data Studio from Michael Howe-Ely
• Travel Log from Laura Tilton
• Massachusetts Cities and Towns from Laura Tilton
• Road Trip Photo Album from Riccardo Zagaglia
• World Development Indicators from Michael Howe-Ely