Title: Olympics Performance Explorer
Tool: Microsoft Power BI
Author: L_Divya_
Opening Statement
The Olympics Performance Explorer is a Power BI report designed to analyze more than a century of Olympic history across countries, eras, seasons, athletes, and sports. The objective was to build an interactive, narrative‑driven analytical experience that connects long‑term performance patterns with athlete‑level stories. The report focuses on clarity, accessibility, and guided exploration so users can move through insights in a structured and intuitive way.
Tools and Approach
The report was created using Microsoft Power BI, supported by DAX for calculations and bookmarks for view management. The design approach centered on a story‑first structure: beginning with historical context, moving into high‑level metrics, and then guiding the user into deeper analytical sections. Transparent images, Olympic‑themed color palettes, accessible tab order, and clear navigation tiles were incorporated to maintain consistency and usability across pages. Multiple views were built with bookmarks to simplify complex comparisons without overwhelming the layout.
Report Walkthrough
The report consists of five interconnected pages.
The first page introduces the history and purpose of the Olympic Games and provides a clear call to action to begin the exploration.
The second page serves as the navigation hub, displaying the core KPIs total medals, athletes, games, and participating countries along with tiles that lead to the detailed analytical views.
The Country Performance Explorer allows comparisons over time through line charts, ribbon charts, bar charts, and maps.
The Eras and Seasons page presents two perspectives using bookmarks: long‑term historical evolution and contrasts between Summer and Winter Games.
The final Summary page brings together athlete centered insights and sport-level patterns, including searchable tables, panel toggles, and discipline-based visuals.
Each page is structured to maintain a logical flow and ensure that users understand both the data and the story behind it.
Challenges and Lessons Learned
The main challenges involved balancing visual density with clarity, ensuring that the report remained easy to navigate despite its breadth. Bookmark management required careful planning to avoid conflicts between hidden visuals and tab order. A significant learning outcome was the importance of accessibility features such as structured tab sequences, alt text for visuals, and consistent labeling, all of which improve navigation for every user. Designing transparent custom icons and maintaining a cohesive theme across pages also reinforced how much consistent visual identity contributes to user experience.
Link to LinkedIn or Portfolio
(20) L Divya | LinkedIn
