This project is a submission for the #mavenslopeschallenge conducted by Maven Analytics. The aim of the challenge is to build a one-page dashboard that will help users choose their ideal ski resort based on their budget, location, and various other factors. I enjoyed the process of doing data analysis and creating this dashboard using #powerbi.
About the dataset
- This dataset contains 2 tables in CSV format
- The Resorts table contains information on 499 ski resorts around the world, including their location, slopes, lifts, prices, and ski season
- The Snow table contains supplemental data on the surface of the earth covered by snow for each month in 2022, by latitude & longitude
While working on this challenge, I found some helpful insights that will help users find their ideal ski resort destination.
Power BI Dashboard
This dataset included 499 resorts all across 5 continents: Europe, North America, South America, Oceania, and Asia. 72% of global ski resorts are located in Europe, where the average price per person per day is €41.55. North America ranks second, with 19.64% of global ski resorts and an average price per person per day of € 76.97.
Out of 499 resorts 99.20% of resorts are child friendly. If you are planning to ski in the summer season, 29 (5.81%) resorts are available with a summer ski option, and 295 (59.12%) resorts are present where you can plan for night skiing.
Breckenridge is the resort located at the highest point (3914 m) in the United States, with an average daily price of € 140. In Canada, the "Le Massif" resort is located at the lowest point of 36 meters and costs € 51.
Looking for the longest ski run?
The resorts with the longest 16-kilometer runs are Alpe d'Huez (France), Bansko (Bulgaria), and Les Deux Alpes (France). If you are looking for the ski resort with the most difficult slopes, Big Sky Resort (USA) has 126 difficult slopes. Les Sybelles-Le Corier (France) has the most intermediate slopes (239), while Les 3 Vallees (France) has the most beginner slopes (312).
If you're looking for resorts with free entry, consider the following options:
Yellowstone Club(United States)
Alpika Service(Russia)
High1 Resort(South Korea)
Palandoken-Ejder 3200 World Ski Center(Turkey)
Perisher(Australia)
Pragelato(Italy)
Puigmal(France)
Sun Mountain-Yabuli(China)
Uludag-Bursa(Turkey)
If you are planning to visit a ski resort, the best time would be from December to April because the most snow falls during this season.
Some key insights from the above analysis include:
- Out of the 499 resorts, 99% are child-friendly, 40.88% offer night skiing, and 5.81% offer summer skiing.
- Europe has 72% of the world's ski resorts, with North America coming in second with 19.64%.South America is at the bottom with seven (1.40%) resorts.
- Oceania, with 58% of beginners' slope, is suitable for people who are looking for beginners' slope. North and South America are the continents with the most difficult slopes. whereas Europe is suitable for intermediate slopes.
- Resorts in North America, with an average price of €77, are more expensive as compared to other continents and Asia, with the lowest average price of €33.
- The best time to plan a visit to a ski resort is between December and April, when the most snow falls.
- If this is your first trip, Europe is an excellent choice because the majority of the ski resorts are located there, are reasonably priced, and are suitable for intermediate skiers.
No comments: