Friday, February 14, 2020

Public K-12 Report Collection / Data Studio Filter by Email

I realized that it's been a few weeks since I posted an entry on the blog; mostly because I have been sharing small updates more regularly on Twitter. Please be sure to follow me @tiltondata for additional updates related to using data in support of teaching and learning, particularly with ideas related to the use of Google Data Studio!

Speaking of Data Studio, I have launched a new public K-12 Data Studio Report collection with entries from a number of districts and organizations nationwide. (I previously shared information about a collection of just my own reports, but wanted to expand this idea to a larger library.) I hope you'll check it out, and maybe even submit an entry of your own!

We received exciting news from the Google Development team yesterday, and that is the introduction of the Filter by Email feature in Data Studio. This feature provides "row-level" security to the data source that underlies the report, when the data source has a column/field that contains email addresses (one per row is currently supported). This means that we can create dashboards that will change based on WHO is logged in! Previously, the way to accomplish user-specific dashboards required using BigQuery as a data source and was a much more complex process, so this is a very welcome new feature!

You can read more about this new feature in the Google Help documentation here:

I invite you to try out my very basic "proof of concept" dashboard which displays the data resulting from a Google Form in both a filtered and unfiltered way. (You will need to be logged into a Google account to access it.) I hope to share additional (more edu-specific) ideas and templates in the coming weeks.

Want to learn more about using Google Data Studio in support of teaching and learning? Check out the list of events below, or reach out if you'd like to host a workshop for your district or collaborative.

No comments:

Post a Comment