SNOWsat Resort Dashboard Program
Overview
The customer-facing SNOWsat data dashboard interface transformed complex and cumbersome SNOWsat data into a user-friendly dashboard featuring useful metrics and comparisons. Developed at the request of Clifford Mann at Mammoth, who sought an easier way to understand spreadsheet data, this intuitive interface provided resorts with a comprehensive understanding of complex nightly data, as well as weekly, monthly, and yearly reports. It offered benchmarks, scores, and comparisons to facilitate data analysis. This innovative solution automated reports for multiple top resorts in North America, streamlining operations and enhancing decision-making processes.
The Reports (see live interactive reports below)
With over 31 individual resorts, 3 corporate summary reports and an annual comparison report of like resorts the program provided valuable data to the resorts. these resorts included
Cranmore
Cypress Mountain
Holiday Valley
Holimont Ski Club
Jiminy Peak
Lutsen
Sun Peaks
Sunday River
49 North
Boreal
Boyne
Corporate Reports
Alterra Corporate
Powdr Corporate
CRM Ops
Bromley
Keystone
Silver Mountain
Woodward Park City
Squaw Valley
Fairbank
Alpine Ski Club
Bear
Brighton
Copper
Mount Bachelor
Camelback
Diamond Peak
Giants Ridge
Sierra at Tahoe
Solitude
Sugarbush
Timberline
Mammoth
Seven Springs
Program Details
This innovative project provided a comprehensive visually appealing and easy to understand dashboard overview of grooming operations, including staff, equipment and surface information, on a nightly, weekly, monthly, and yearly basis. The Power BI-based system was build with a custom algorithm that ensured automated daily updates, enabling management to identify trends, strengths, weaknesses, and training opportunities effortlessly.
Additionally, this program enabled benchmarking with industry averages, empowering resorts to assess their performance against peers and identify areas for improvement. I also implemented benchmarking based on to track progress and make continuous improvements.
I analyzed the existing raw data to extract key insights, turning them into more relevant and useful metrics. The automated Power BI interface, updated daily, was accessible via password-protected microsites for real-time insights. I also provided ongoing support to resorts, addressing queries and delving into data nuances to drive continuous improvements.
Development Process
Daily Report (Operator and Cats)
The Operator and Labor Report consists of six pages of detailed information, providing a comprehensive understanding of each cat and operator's performance.
Page 1: Overview
The first page focuses on averages of the most important information at a glance. Each cat and/or operator can be selected using the option at the bottom, allowing for comparison against the nightly resort average. This report includes the operator score, summarizing four key indicators of nightly performance. It also provides the number of cats versus the total operational cats the resort owns, gallons per acre groomed, total acreage groomed compared to potential acreage, and department capacity compared to the potential if all operational cats worked a full shift.
Page 2: Score
The second page details the scoring for each operator, showing the recent shift compared to the previous shift. It breaks down the four main factors contributing to the score and how each operator performed. This helps identify top and bottom performers for training opportunities or recognition. You can select a specific operator for more detailed information.
Page 3: Fuel Details
The third page focuses on fuel consumption and related factors. It starts with overall averages, including total fuel consumption, gallons per acre groomed, gallons per acre groomed, and average RPM. This section then drills down into each operator's performance, providing RPM average vs maximum and gallons per acre tilled vs total fuel used. This helps gauge the effectiveness and efficiency of each operator and or recognize that they might have been ion the park or doing a special project. You can select a specific operator for more detailed information.
Page 4: Acre Details
The fourth page details the amount of terrain groomed, with averages of total acres groomed followed by the acres per hour average. The bottom section breaks down the acres per hour, total acres groomed, and acres groomed by each machine for each operator. You can select a specific operator for more detailed information.
Page 5: Time Details
This section focuses on time metrics, including averages of overspeed time, total operating time compared to break time, and a four-way comparison of total duration, moving time, tiller down time, and idle time. It also includes a comparison of moving time versus break time. You can select a specific operator for more detailed information.
Page 6: Resort Comparison Overview
The final section provides simple, easy-to-view average comparisons between the current and previous day, highlighting key metrics such as gallons per acre groomed, acres per hour groomed, break time, score, duration, and RPM. You can select a specific operator or cat for more detailed information.
Daily Report (Cat Only)
This report focuses solely on cat details and allows a directly comparison two resorts, for easy toggling between them. This also allows for the selection of different grooming areas / jobs, such as Flat Grooming (groomer), Park, Winch and Ramps, While it does not include individual operator data, it provides comprehensive information on each cat.
Navigating this report is similar to the previous report with subtle changes to reflect the cat-only information and direct comparisons between the two resorts.
Page 1: Overview
The first page scores each cat's performance based on a predetermined average from past data. It details the number of cats versus the total cats the resort owns that are operational and includes gallons per acre groomed, total acreage groomed compared to potential acreage, and department capacity compared to the potential if all cats worked a full shift or shifts.
Page 2: Score
The second page provides scoring details for each machine, including an overall score and a breakdown of the four main factors contributing to the score. This helps identify top and bottom performers for training opportunities or recognition.
Page 3: Fuel Details
The third page focuses on fuel consumption and related factors. It starts with overall averages, including total fuel consumption, gallons per acre groomed, gallons per acre moving, and average RPM. It then details each cat's performance, providing RPM averages and maximums, gallons per acre tilled, and total fuel used, giving insight into each cat's effectiveness and efficiency.
Page 4: Acre Details
The fourth page details the amount of terrain groomed, with averages of total acres groomed and acres per hour. The bottom section breaks down the total acres and acres per hour by cat.
Page 5: Time Details
This section focuses on time metrics, including averages of overspeed time, total operating time compared to brake time, and comparisons of total duration, moving time, tiller down time, and idle time.
Page 6: Resort Comparison Overview
The final section provides easy-to-view average comparisons between resorts, including gallons per acre groomed, acres per hour groomed, brake time, score, duration, and RPM.
Weekly Report
The weekly report functions similarly to the daily reports but includes month-over-month comparisons to track progress and departmental efficiency. It also provides a monthly summary of operators and cats. For detailed report structure, please refer to the daily report
Monthly Report
The monthly report functions similarly to the daily reports but includes month-over-month comparisons to track progress and departmental efficiency. It also provides a monthly summary of operators and cats. For detailed report structure, please refer to the daily report.
End of Season Report
The end of season report provides a summary of the season, allowing for an at-a-glance comparison with the previous season. It also enables you to drill down by operator and cat to see detailed performance data for the entire season.
End of Season Resort Comparison
In this report we categorized resorts by total equipment time and created groups of similar resorts for comparison. The report provides an average for each resort, allowing for easy at-a-glance comparisons by toggling a specific resort. This report is intended for groups of resorts with the same ownership and would not be shared with competitors or used for internal use.