Tokyo 2020 Is Finally Here! 10-07-2021 17:43 PM

[AllisonKennedy]

UPDATE Feb 2022: Have updated the data source to Beijing 2022 results from https://www.eurosport.com/olympics/medals/ as the Olympics.com source is timing out.

We use historic Olympic medal data in our Power BI Essentials Skills course, so I have been waiting anxiously for the Tokyo 2020 Olympics to arrive. I've spruced up the file we use in the course by adding a link to the live Olympics.com Tokyo 2020 results and updating them every 30 minutes. I'll be blogging about how I created this report, the refresh, data alerts and automated Tweets throughout the Olympic Games, so subscribe to learn more: https://excelwithallison.blogspot.com/

eyJrIjoiMGQyNDBjOTctYTQxZC00ZTFiLTlkZjItZDA2MzgyY2JmZWYwIiwidCI6IjBiOGU2NWNiLWRjMmUtNDQ0Yy1hOGUwLTE4MmYyYTdmODc1YyJ9

[ronaldbalza2023]

Awesome, great work indeed! I am a fan now 🙂

[Icad01]

Nice work 🙂

[Anil2264]

Hi, May i have the dataset so that i can also try to build the same report as a practice.

[AllisonKennedy]

@Anil2264  The dataset is all from the internet. Here's the first blog in the series for how I got the historical data: https://excelwithallison.blogspot.com/2021/07/tokyo-olympics-power-query-custom.html 

Not sure if the links have changed since then (now that Olympics aren't live anymore) so it may need some small modifications....

Let me know how you get on! 🙂 

[IF]

Very good report! At the bottom the pages are shown as "1 of 6" and it is also possible to see it with full screen. How did you do it? All the best,

[AllisonKennedy]

@IF  You can find the how to tutorials for most of the report on my blog: https://excelwithallison.blogspot.com/search/label/Tokyo%202020%20Olympics 

The page navigation is just the built in navigation from Power BI when using share to web/embed in site, but I do have another blog on creating custom page navigations: https://excelwithallison.blogspot.com/2021/09/welcome-to-level-3-lockdown-with.html