Ski Resort Challenge (Tableau & Excel)

Key Findings:

• The country with the most resorts is Austria with 89 resorts.
• There are nine free resorts across the world! One is located in the U.S. (Yellow Stone Club), two in Asia (High Resort and Sun Mountain Yubali), five in Europe (Pragelato, Puigmal, Alpika Serevice, UludagBursa, and PalandokenEjer World Ski Center) and lastly one in Australia (Perisha). Ever thought of skiing down under?
• Resorts priced over $100 are all located within the U.S. The most expensive resort is Bever Creek.
• Months with the highest snowfall across the world is February and March; lowest is September.

Prior to uploading the dashboard in Tableau I cleaned all the data in Excel. See below for the steps I took in Excel.

Excel Cleaning Demo:

1. Download the Ski Resorts Dataset from Maven Analytics.
2. Open resorts workbook and analyze columns A through Y.
3. Install the Ablebits Data Tab from Microsoft Excel.
4. Clean special characters and numbers from the ‘Resort’ column.
5. Trim leading and trailing characters from across the workbook.
6. Insert a Pivot Table to check for incorrect spellings in ‘Country’, ‘Continent’, ‘Season’, ‘Child Friendly’, ‘Snowpark’, ‘Night skiing’ and ‘Summer Skiing’ columns.
7. Checked for duplicates using conditional formatting in the ‘ID’ and ‘Resort’ columns.
8. Open the ‘Snow’ workbook and noticed ‘Longitude’ and ‘Latitude’ was rounded to the third decimal. In the ‘Resort’ workbook, I format columns ‘Longitude' and ‘Latitude’ columns to only three decimals to match the ‘Snow” workbook.
9. I noticed that there were ‘unknown’ variables in the ‘season’ column, so I did a bit of research and filled those in.
10. Once completed I uploaded both data sets into Tableau.