07-24-2021 03:54 AM - last edited 02-06-2022 15:48 PM
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/
@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 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