Project


 

Data will be provided and students will be asked to review data over 12 months. This data will/may show a huge decrease in revenue during a specific quarter. Students will create a report using preset data. With the report, an analysis of what could be done to grow the business will be completed.

There are multiple files that can be used to review and generate your reporting and analysis. Filter through the data, create Pivots, graphs, and other learned material to provide a managerial insight with the informatics that is available if you find it relevant.

Data for Review: June 2018 – May 2019

Quarter needing specific review: Q3 2018

Location: Colorado Ski Resort Area

ER Doctor billing Student File-1.xlsx

Student File payer mix-1.xlsx

Aging_Student File ER and Physician-1.xlsx

Emergency Room Encounters_Student file.xlsx