SlopeSearchers: A Company That Helps You Find Your Most Ideal Ski Destination!

The datasets used in this project consist of two tables: resorts (all the details about the 499 ski resorts around the world); snow (snow cover of different regions around the world). Using these datasets, the participants must create a one-page dashboard to help skiers find their ideal ski destination around the world.

SlopeSearchers is a fictitious company which is in the business of building dashboards for its clients/skiers. The concept of the dashboard is to let the users customize the selection and pick the ski resort they want as a result of the criteria they set. I converted the selection criteria into 7 different steps so that the dashboard becomes interactive enough for the user.

Here are the complete details of each step:

1. SKI PASS - This step lets the user set their minimum and maximum budget for 1 adult for a 1-day ski pass (in Euro).

2. CHILD FRIENDLY - This step asks the user if they are planning to bring a child with them in their ski activity.

3. NIGHT SKIING - Indicates whether the user is planning to ski during the night.

4. SUMMER SKIING - Asks whether the user prefers a ski resort that offers summer skiing.

5. COUNTRY - This step allows the user to search for the country in which they want to ski.

6. MONTH - It sets the month on when the user plans to ski.

7. SKI RESORT - Finally, this step identifies which ski resort/s is available for the user to analyze as a result of the previous 6 steps.

CLEAR ALL SELECTION - This is a button created to allow users reset or clear all the filters they set.

Once the user has set the criteria and picked the ski resort he/she wants, a summary of all the details about the chosen ski resort is presented. In this summary, details about the ski resort's ski season, slopes, lift system, and snow features are available to be analyzed. From then on, the user/skier can now decide if he/she wants to go to that ski resort.

SKI RESORT'S SEASON

1. Type of Ski Season - This identifies the type of ski season the chosen ski resort has. There are two types of ski season in the dashboard, Seasonal and Year-round. Seasonal ski season can be monthly or a series of months. Some ski resorts have one season only while others have three. Year-round, on the other hand, is a ski season that spans for the whole year.

I also indicated the months on which each ski resort's season starts and ends.

2. Snow Cover During The Same Month In 2022 - This is the snow cover of the geographic region in which the ski resort is located. The percentage indicates how covered the region is during the same month (selected month) in the year 2022.

SKI RESORT'S SLOPES

1. Longest Run (Kilometers) - This is the longest possible continuous run a skier can do in the ski resort.

2. Highest Point and Lowest Point (Meters) - It determines both the highest point and lowest point of the ski resort where skiers can ski.

3. Length of Slopes (Kilometers) - This shows how different slopes of the ski resort differ in terms of its length.

SKI RESORT'S LIFT SYSTEM

1. Lift System's Capacity (Person Per Hour) - This is the number of passengers the ski resort's lift system can accommodate in an hour.

2. Number of Lifts - It enumerates the different types of lifts and its quantity the ski resort has.

SKI RESORT'S SNOW FEATURES

1. Snow Cannons - The number of snow cannons that can be found in the ski resort.

2. Snowparks - It indicates whether the ski resort has snowparks (✓) or not (X).