skip to main content
Power BI
    • What is Power BI
    • Why Power BI
    • Customer stories
    • Data visuals
    • Security
    • Power BI Desktop
    • Power BI Pro
    • Power BI Premium
    • Power BI Mobile
    • Power BI Embedded
    • Power BI Report Server
  • Pricing
    • Azure + Power BI
    • Office 365 + Power BI
      • Energy
      • Healthcare
      • Manufacturing
      • Media
      • Retail
    • For analysts
    • For IT
      • Overview
      • Embedded analytics
      • Power BI visuals
      • Automation
      • Documentation
      • Community
    • Overview
    • Find consulting services
    • Partner showcase
    • Find a partner
    • Become a partner
    • Instructor-led training
    • Getting started
      • Overview
      • Online workshops
      • Self-guided learning
      • Webinars
      • Documentation
      • Roadmap
      • Overview
      • Issues
      • Give feedback
    • Blog
    • Business intelligence topics
    • Overview
    • Forums
    • Galleries
    • Submit ideas
    • Events
    • User groups
    • Community blog
    • Register
    • ·
    • Sign in
    • ·
    • Help
    Go To
    • Galleries
    • Community Connections & How-To Videos
    • COVID-19 Data Stories Gallery
    • Themes Gallery
    • Data Stories Gallery
    • R Script Showcase
    • Webinars and Video Gallery
    • Quick Measures Gallery
    • 2021 MSBizAppsSummit Gallery
    • 2020 MSBizAppsSummit Gallery
    • 2019 MSBizAppsSummit Gallery
    cancel
    Turn on suggestions
    Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
    Showing results for 
    Search instead for 
    Did you mean: 
    • Microsoft Power BI Community
    • Galleries
    • Data Stories Gallery
    • Tracking medal count at the Rio 2016 Olympics

    Tracking medal count at the Rio 2016 Olympics

    08-09-2016 09:52 AM

    jac_rod
    Regular Visitor
    2724 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    jac_rod
    jac_rod
    Regular Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    Tracking medal count at the Rio 2016 Olympics

    ‎08-09-2016 09:52 AM

    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

    Preview file
    133 KB
    Olympics.pbix
    Labels:
    • Labels:
    • Entertainment
    • Sports
    Message 1 of 3
    2,724 Views
    4
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic
    MatherC
    MatherC
    Frequent Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎08-10-2016 12:18 PM

    I Like it!!

     

    I looked at the PBIX file and I took the liberty of condensing your Power Query steps.  See attached file.

     

    Charlie Mather

     

     

    Preview file
    15 KB
    Message 2 of 3
    2,664 Views
    0
    Reply
    jac_rod
    jac_rod
    Regular Visitor
    In response to MatherC
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎08-16-2016 04:51 PM

    Thanks @MatherC,

     

    I'm glad you like it and it's cool to see suggestions from the community!  There's some things that could certainly be improved still (the ties for gold and silver in swimming aren't probably being calculated - I only handled the ties in Bronze) but I think it's a pretty fun use of Power BI.

    Message 3 of 3
    2,546 Views
    0
    Reply

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • Power Automate
    • Power Virtual Agents

    • Sign in
    • Sign up

    Browse

    • Solutions
    • Partners
    • Consulting Services

    Downloads

    • Power BI Desktop
    • Power BI Mobile
    • Power BI Report Server
    • See all downloads

    Learn

    • Guided learning
    • Documentation
    • Support
    • Community
    • Give feedback
    • Webinars
    • Developers
    • Blog
    • Newsletter

    © 2022 Microsoft

    Follow Power BI

    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Trademarks