Super UserWeek 3 (Final Chance) Olympic games Deep Dive
The report looks good. but the data in "Analysis" is incorrect.
It seems you used a table that is not loaded into the dataset (athlete medals).
For example, Michael Phelps is shown with 16 medals, when he actually has 28. Same with Larisa and the rest of athletes.
I only noticed this issue in that specific table, thats why probably it wasnt loaded
Advocate IVIn fact.. there's a problem with the databases. Once you link 'results' with 'results_athlete' (they're the same base) you see that there's a lot of missing information.
That's why if you try to recreate the Phelps career using 'results' you can only find 13 medals. I faced that problem, it only appears 13 times.
The 'athletes' database is complete but unlinkable with the others. Furthermore, athletes links are also incomplete and is used as a key to other bases..
- Juan-Power-bi
Indeed, I crosschecked the two tables and the data its not the same,
Slindasy even mentioned it in the general chat :
rampieKudo Commander
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.
LearningGuyAdvocate I
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.
