topic Re: Beijing 2022 - Report updated to show winter olympic results in Data Stories Gallery

Beijing 2022 - Report updated to show winter olympic results

AllisonKennedy — Sun, 06 Feb 2022 23:48:01 GMT

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

Re: Beijing 2022 - Report updated to show winter olympic results

IF — Mon, 27 Sep 2021 07:30:14 GMT

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,

Re: Beijing 2022 - Report updated to show winter olympic results

AllisonKennedy — Mon, 27 Sep 2021 21:36:06 GMT

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

Re: Beijing 2022 - Report updated to show winter olympic results

Anil2264 — Tue, 28 Sep 2021 05:03:02 GMT

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

Re: Beijing 2022 - Report updated to show winter olympic results

AllisonKennedy — Tue, 28 Sep 2021 10:05:22 GMT

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! 🙂

Re: Beijing 2022 - Report updated to show winter olympic results

Icad01 — Tue, 05 Oct 2021 08:41:59 GMT

Nice work 🙂

Re: Beijing 2022 - Report updated to show winter olympic results

ronaldbalza2023 — Fri, 08 Oct 2021 00:43:50 GMT

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