Excel examples for your work, sports and more.: January 2020

#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