Juan-Power-bi's avatar
Juan-Power-bi
Icon for Super User rankSuper User
7 months ago

Week 3 (Final Chance) Olympic games Deep Dive

Hi Data Lovers   This it's my final entry, as always I have learned a lot more about PowerBI , If you know me, you might know that I love Deneb and of course, Html Content, so used these custom vis...
World Champs ATL
Juan-Power-bi's avatar
Juan-Power-bi
Icon for Super User rankSuper User
7 months ago

Indeed, I crosschecked the two tables and the data its not the same,

Slindasy even mentioned it in the general chat :

 

rampie's avatar
rampie
Icon for Kudo Commander rankKudo Commander
7 months ago

Hi Juan, great report, really well done.
Are you planning to upload a walkthrough or guide to your channel?

Visually it’s excellent, but the incorrect medal data does take away some points, especially if you’re an Olympics fan. Any reason you didn’t use the Athletes table? It would’ve just been a matter of splitting the Medals column.

  • LearningGuy's avatar
    LearningGuy
    Icon for Advocate I rankAdvocate I
    7 months ago

    Rampie, the Athletes table doesn't resolve the issue as it creates a gap with the relationship between Games, Disciplines, Events and the actual medal. E.g. sure you can see 28 medals for michael phelps, however you can only see where he obtained 16 of those 28. There's an issue with the data, it's not the job of an intelligence analyst to fix data issues. 

    • rampie's avatar
      rampie
      Icon for Kudo Commander rankKudo Commander
      7 months ago

      You’re absolutely right, an athlete’s full career cannot be completely reconstructed from the Results table,

      That said, it would’ve been better to scope the analysis around the data that is reliable, rather than presenting visually strong insights on inaccurate numbers. Choosing accuracy over completeness is part of an intelligence analyst’s responsibility.

      • LearningGuy's avatar
        LearningGuy
        Icon for Advocate I rankAdvocate I
        7 months ago

        Well, in that case, I hope you noted that the entire results dataset is missing tonnes of discipline and event level data for literally every game ever held. 

  • Juan-Power-bi's avatar
    Juan-Power-bi
    Icon for Super User rankSuper User
    7 months ago

    Hi Rampie, As I mentioned I cross checked the two tables and when I realized that the data its not accurate , I was going to ask to Lindsay , however there were a lot people with the same concern.

     

    Having said this, if the idea was to find patterns and analyse the data over time I decided to go wit the Results Table for the medals insted of using the Athletes table, where we only have a summary of this