Introduction
Welcome back to Workout Wednesday. This week we get to combine our love for data and the Olympics by building an Olympic medal tracker!
This is a design challenge. I have created a sample for inspiration, but feel free to build the report in any way your creative heart desires. In this challenge you’ll scrape data from the web, create simple measures to rank the leaders, and add additional info that’s important to you. I added the number of days and events remaining because I’m on the edge of my seat to see how each country fares.
I used only out of the box visuals with the exception of the Olympics logo. See what you can do with Power BI’s core visuals! I also challenge you to use what you learn here to track your other favorite events!
Find the data and instructions to complete the challenge below, and as always, have fun!
Requirements
Get data and build visuals
- Get data from a website of choice – I used ESPN.
- Transform your data
- Do any data cleaning you need in Power Query
- Create measures in Power BI if you need them. I created measures for both metrics and formatting.
- Add visuals to the canvas. Be sure add at least:
- an informative title
- a table with medal standings
- a visual displaying what team has the highest # of medals overall
- a background image/logo
- buttons to use for custom navigation
- Add any other design elements that you’d like
- Ensure that all visuals meet the minimum standards of having alt text, that the tab order in your report makes sense, and that your color choices meet the minimum contrast standards.
- To keep your tracker up-to-date, be sure to set up a scheduled refresh in the Power BI service.
- If you’re not publishing to the service, you can mimic a scheduled refresh by selecting refresh in the ribbon of Power BI desktop.
- As always, mix up the design in any way you see fit! This should be fun!
Dataset
This week you’ll scrape data from the web to build your report. I used data from ESPN and added a couple of tables manually, including the Olympic dates and the refresh date.
Share
After you finish your workout, share on Twitter or LinkedIn using the hashtags #WOW2024 and #PowerBI, and tag @MMarie, @shan_gsd, @KerryKolosko.
Also make sure to fill out the Submission Tracker so that we can count you as a participant this week in order to track our participation throughout the year.
Solution
Solution File available for download from the data stories gallery.
HI , I am just learning Power BI . Can u please tell the other table which are there have you created seperately or all are connecting directly through from ESPN ….As when I am connecting through Web I am getting Total by Medal Table only
You can download the completed PBIX file from the Data Stories Gallery: https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Workout-Wednesday-2024-Week-32/m-p/4085707#M12936. That will likely answer your question.