In order to keep track of the performance of the most elite athletes in the world at the Rio 2016 Summer Olympics, I created a Power BI report using data found at www.rio2016.com.
This report was really simple and straightforward. First, I had to look around for places supplying the data in an easy to ingest table-based format. I found this at https://www.rio2016.com/en/medal-count-sports. This particular table had all the information I needed to track each medal by country by event.
I used the "Web" data source in Power BI. Connecting to this dataset brough in individual tables for each of the events. First thing I did was append all of them together into a single table. After doing this, and cleaning out the competitors name (I only wanted the countries), I had what I needed.
Next, I needed to unpivot the columns to get the data into a format I was comfortable with. I wanted a row for each medal at each event, but the data set had each event in a single row. Unpivoting the table got the data how I wanted it. There were some multiple entries in the bronze categories (for ties), so I needed to split that column by the tab delimiter and clean it up to resolve that issue.
Next, I created a couple of new columns to represent the numbers I wanted to use in my visualizations - one each for bronze, silver, gold, and total medal count. The rest was history.
eyJrIjoiMmVmNzBjZTktMjUyYy00OGFjLWJhMzAtNmM4YzNhOTVmMGM5IiwidCI6IjEzZjU3MGNkLTQ3YTctNDBmMC05MDkzLTc3MjcwNDVmODBjYSIsImMiOjN9
