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