Vail Resorts interview question

Design a dimensional model to solve this analytical problem