18 Jan 2020

Google Data Studio Dashboard for Messi, my blog and my Youtube videos

#65 Google Data Studio (GDS) Dashboard for Messi-goals, my blog and my Youtube videos

4/1/2021:
Today I made a new live Messi Goal Tracker dashboard, see:
https://worktimesheet2014.blogspot.com/2021/01/messi-goal-tracker-dashboard-in-google.html

4/4/2020:
Today I made my Messi-dataset (CSV-file with raw-data, that I used for my dashboard) available as 'open data' on Github, see:
https://github.com/mvanreek/Sports_data


Although this blog is mainly about Microsoft Office's Excel, for this post I took a look at
Google's G Suit ("Google Docs"), especially Google Sheets (a spreadsheet-tool like MS Exel) and Google Data Studio (GDS) (a BI/dataviz. tool like MS Power BI).
For more info about these Google products and a comparison with the 'equivalent' Microsoft products, see Literature below. Most important thing to know is that with GDS, Google wants to make Analytics accesible for anyone, not just for big companies with time, money and (tech) skills.

To test GDS, I first used the 'Messi-dataset' that I used to create dashboards in Excel+Powerview and Power BI for previous blog-posts, see:
http://worktimesheet2014.blogspot.com/2016/12/powerbi-dashboard-for-messis.html
http://worktimesheet2014.blogspot.com/2015/08/dashboard-for-messis-worldrecord-of-91.html

The 'Messi-dataset' was in Excel, and I converted it to Google Sheets (see Downloads below), and in GDS, I connected to this G-Sheets datasource.
For the GDS-report (see fig.1), I used the Excel + Power BI reports I made before as an example, but I made some changes to improve the 'story-telling' by the report, to give insight in how Messi made these goals (the 'mode', e.g. left-foot), where (in which team) and when. This lead to the following charts in the report:
- score-card with total goals
- stacked bar-charts for # goals by Team/Competition
- bar-charts for # goals by Mode
- stacked column-chart for # goals by Time/Competition

fig.1: Google Data Studio Report with Messi goals

https://datastudio.google.com/reporting/39453d65-7507-4819-aeea-b3603d227645


Embedded Youtube-video of maybe Messi's best goal:
https://www.youtube.com/watch?v=WkqecpHcIPw

GDS can connect to various datasources, and I tried 2 others:

-1: Google Analytics (for my blog), see fig.2 for the report. In this report I set the chart-property 'interactivity - filter' to 'on' for all charts, so that if you filter in one chart, this filter is applied to the other charts (see fig.2c, filter: Year = 2019). I also enabled the 'drill-down' option for the Geography and Time dimensions (see fig.2b-c, Continent = Europe).
For a look at the Google Analytics dataset (with facts/meassures and dimensions), see fig.2d.

NB: Google Analytics is also loaded with standard reports, see fig.3, which is good for getting insights for e.g. a business analyst, but if he wants to share these insights with others (e.g. management) in a presentation, he could use GDS to create a nicer report.

-2: Youtube Analytics  (for my YT-channel / some video's I uploaded once), see fig.4.


fig.2a: Google Analytics for my blog - page 1

https://datastudio.google.com/reporting/09d957cc-9cb3-4611-b8ae-37ec5a8af90c



fig.2b: Google Analytics for my blog - page 2: without filters



fig.2c: Google Analytics for my blog - page 2:  with filter on Year and drilldown (Continent > Country)




fig.2d: Google Analytics dataset




fig.3: Google Analytics standard dashboard for my blog




fig.4: Youtube Analytics  (for my YT-channel)

https://datastudio.google.com/reporting/14ca88f6-548d-4cf6-bfc5-ee662f29a4a4




I think with Google Data Studio it is possible to make really nice reports in an easy way, and the fact that is free, easy to share (just like any Google Docs file) and a 100% cloud solution makes GDS a very interesting option for your BI/dataviz.work. And even more so if your company is using Google G Suite, which happens to be the case in the company I work for (#Visma|Raet , part of #Visma)..


Literature

[1]
Google Data Studio: Pricing & In-depth Reviews

[2]
Google Data studio, a killjoy for Microsoft Power BI

[3]
I Evaluated 4 BI Tools: Power BI, Tableau, Google Data Studio, & Sisense. Here's What I Found


Downloads

Mirror #1

Messi-dataset (G-Sheets):
https://docs.google.com/spreadsheets/d/1ldQAt_EV9MqjNdpMDqIa6uzzkFDqPlTlVhM1NqqdKoM/edit#gid=0

Messi GDS-report + PDF:
https://datastudio.google.com/reporting/39453d65-7507-4819-aeea-b3603d227645
https://drive.google.com/open?id=1Lhb0CNO685Bl-zoCGlEdjK0IwH890Wc4



No comments: