Power BI Dashboard
About this project
Project Purpose
The purpose of this project is to explore the impact of seasonal changes on Mount Everest expeditions. By analyzing real historical data, this report aims to reveal how success rates, death rates, and oxygen use vary depending on whether climbers attempt the summit in Spring, Summer, Autumn, or Winter.
Dataset
Final Dataset
The cleaned and processed dataset includes the following key tables:
- Expeditions – Includes each expedition’s year, peak, season, and country.
- Members – Contains individual climber details like age, gender, citizenship, success, oxygen use, and death status.
- Peaks – Metadata about climbing peaks, including Everest and others.
About This Project
Data Cleaning & Transformation
- Removed duplicate rows and fixed type mismatches
- Merged relevant columns using primary/foreign key relationships.
- Added new columns:
- Decade (e.g., 1990s, 2000s)
- Used DAX for custom measures and custom HTML to show custom visuals.
Report
The report is structured into multiple zones and visuals, covering expedition trends, strategy shifts, and record-breaking climbs. Highlights success and oxygen usage trends during the most popular climbing season.
Main Report (4 Pages)
- Landing Page – Overview with title, theme, and key seasonal insights.
- Spring Season
- Summer Season
- Winter Season
- Autumn Season
Insights
· Spring is the safest and most successful season
· The reliance on supplemental oxygen has grown over the decades
· Top Causes for death are mainly due to Fall and Avalanche
Additional project images
