Modernized Revenue Management Reporting from Excel to Tableau
Forecasting Intern, Revenue Management & Analytics • Jun 2014 - Dec 2014
The Setup
Critical reporting and forecasting workflows relied on manual Excel processes that were time-consuming and limited leaders’ ability to explore data quickly and consistently.
Work Completed
Converted recurring Excel reporting into Tableau dashboards published on the department server. Built an interactive market report dashboard for directors using SAS and Tableau. Supported attendance planning work (Annual Operating Plan) and contributed to daily/weekly reporting to evaluate attendance versus forecasts.
Results
Improved reporting efficiency and accessibility by shifting manual Excel reporting to self-service Tableau dashboards, giving leaders faster visibility into key market and attendance metrics.