Exploratory Power BI dashboard analyzing hiking routes in Málaga, focusing on the relationship between distance, elevation gain and relative effort across different difficulty levels.
This project is designed as a lightweight analytical use case, emphasizing data exploration, visual storytelling and clarity over complexity.
The goal of this dashboard is to understand how route characteristics influence perceived effort, and to identify patterns across route difficulty and geographic location.
Key questions addressed:
- How do distance and elevation gain relate to relative effort?
- How does effort vary by difficulty level?
- Where are the most demanding routes geographically concentrated?
- Average Distance (km)
- Average Elevation Gain (m)
- Average Relative Effort
- Route difficulty (Low / Medium / High)
A scatter plot highlighting the relationship between distance and elevation gain, with bubble size representing relative effort. This visualization helps identify how route difficulty influences overall effort.
A geographic view showing the spatial distribution of routes, using color to represent difficulty and bubble size to indicate relative effort.
- Clean and simple data model focused on analytical clarity
- Difficulty levels standardized and ordered for consistent interpretation
- Measures designed to support average-based comparison across routes
- Power BI Desktop
- Data modeling
- DAX measures
- Exploratory data analysis
- Visual storytelling
👉 View the interactive dashboard (Power BI Service):
Open dashboard
-
Routes classified as high difficulty show significantly higher elevation gain even when total distance remains similar, suggesting that effort is more influenced by terrain than by route length.
-
Medium and low difficulty routes tend to have comparable distances, but differ notably in elevation, which impacts the relative effort required.
-
The analysis shows that relative effort correlates more strongly with elevation gain than with distance, highlighting elevation as a key factor in route difficulty.
-
Geographical visualization reveals that more demanding routes are concentrated in specific areas, which could be useful for route planning and user recommendations.
This project is intentionally exploratory and complements more business-oriented dashboards in the portfolio. It demonstrates analytical reasoning, data visualization choices and the ability to communicate insights clearly.