User Profile
zackanalyst
Frequent Visitor
Joined 1 year ago
User Widgets
Contributions
Re: Olympic Legacy: A Century of Excellence (1896–2022)
Thank you for the feedback! You've actually spotted a classic data granularity issue in the source dataset. After a deep dive into the result_athletes bridge table, I discovered that it primarily maps individual events to athletes, but it is missing the many-to-many relationships for relay/team events.Olympic Legacy: A Century of Excellence (1896–2022)
Project Overview This comprehensive Power BI dashboard provides a deep-dive analysis of the Modern Olympic Games, spanning from the inaugural 1896 Athens Games to 2022. Designed with a premium, executive-level aesthetic, the report balances high-level historical trends with granular athlete performance data to tell the story of sporting greatness. Key Features & User Journey Immersive Landing Page: A high-impact entry point featuring a dynamic podium of the all-time top three nations (USA, China, and UK) to immediately establish the competitive context. Global Leaderboard (Countries): An interactive map and regional breakdown allowing users to explore "Continental Power" and national medal hauls through intuitive cross-filtering. Legends Gallery (Athletes): A dedicated search-and-discovery experience featuring "Athlete Bio Cards" and performance metrics for history’s most decorated Olympians. Advanced Filtering: Global slicers for Season (Summer/Winter), Games Year, and specific Sports allow for a highly personalized data exploration experience. Design Philosophy The dashboard utilizes a "Midnight Navy" and "Olympic Gold" color palette to evoke a sense of prestige and history. By adhering to strict UX principles, such as the F-pattern layout for quick scanning, the report ensures that complex historical data remains accessible and engaging for both analysts and casual fans. eyJrIjoiYzQyYTQ2YjEtOGE5OS00ZDkxLWEyYTktMDcyNWRkZGRhODU1IiwidCI6IjUyYzg0YjE2LWVlZDAtNDVjYy1hMDg3LTlmYzdmN2Q1ZGE3MSJ9
