For the past few months we’ve been building dashboards with Google’s Data Studio. A visualiation tools that can easily be connected to a multitude of data sources. We have uploaded most of our data to Big Query to be able to easily (and with much better speed!) query the data into a multitude of dashboards.
BQ in combination with Google’s Data Studio is an easy-to-use combination to implement basic dashboards needed in a media house. Here are some examples of dashboards that we’ve built the past months:
- A live report on the NPS for our site, including open ended comments, shown on a screen at the news desk
- A dashboard showing which articles generate the most registrations
- Amounts of sold subscriptions per type, date and per area
- A vis on the demographics of the registered users (showing demo data):
Data Studio is very easy to use and set up to work with different data sources. You don’t even need to do any coding to access the data in Big Query, but then again, the options on how to plot your data are limited. What you gain on the swings you lose on the roundabouts…
The plot types are quite basic, simple time series, bar charts, pie charts, tables etc. One nice feature though is the geo map that allows you to visualise your data on a map:
But us non-US users still will have to wait for the zoom level to have other options than just the country for areas outside the US
Formatting your visualisation can, however, by no means be compared to e.g. Tableau or even Power Point. Limited options for formatting margins etc. mean that effective use of space on your dashboard is difficult. And you can forget about formatting any of the nitty gritty details on your chart.
Nevertheless, Data Studio makes it really easy to visualise your data and is a handy tool with a low learning curve. And it’s free. So why not try it out? And I’d love to hear your comments on it, so please pitch in in the comment section!