The Walt Disney Company (Walt Disney World Themeparks)The Walt Disney Company (Walt Disney World Themeparks)

Modernized Revenue Management Reporting from Excel to Tableau

Forecasting Intern, Revenue Management & AnalyticsJun 2014 - Dec 2014

TableauSASProcess AutomationDashboard DesignForecasting Support

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.

Skills Exercised

Tableau Publishing & AdoptionSAS-to-Visualization WorkflowReporting AutomationForecasting Operations