Create a user-friendly analytics dashboard with Google Data Studio
Last week with my colleagues from Sutter Mills analytics team, we decided to set ourselves a challenge: create a practical and pretty analytics dashboard with the recently released Data Studio from Google. As part of our job is to help our clients choose the tools that best meet their needs, we thought it could be interesting to share an opinion.
Data Studio is one of the data visualization platforms that aim at creating pretty, interactive, dynamic and shareable dashboards, using your data. You can connect various sources, including AdWords, BigQuery, YouTube Analytics, Google Analytics, and many more which you can mix to feed a single report.
Still in beta version, Data Studio is a free tool which was launched last summer and is available in France since September.
I can already say that I find it is a fantastic, user friendly, professional and highly efficient tool for people who need to create dashboards quickly and independently.
Nevertheless, my colleagues and I noticed some quick wins detailed later on in this article, that we hope to see implemented in the foreseeable future!
The first thing you have to do is select your data sources as well as the Google account you have access to. Then, connect your account with Data Studio and start configuring your data. For example, you’ll have to select the format you want to display: number, text, etc.
You are now ready to start working on your first report!
2. Create your report
You can either use a Google template or create your own:
If you prefer the Google template option, just pick a template and customize it depending on what you need, and what you think is useful and/or easy to read. To do so, you have to select one or several data sources which you have to import in Data Studio beforehand.
In case you want to create your own report starting from a blank page, you just have to drag and drop the widgets you need on your page: image, pie chart, text, map, table chart and so on.