Comparative PampL Statements gt Power BI Dashboards Presented by David Bridge Introduction to the Hotel Industry Current State of MI What we need and why Solution Benefits and ROI The Future ID: 714232
Download Presentation The PPT/PDF document "EiB Case Study: Hotel Analytics from In..." is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
EiB Case Study:
Hotel Analytics from Incomplete Data > Comparative P&L Statements > Power BI Dashboards
Presented by David BridgeSlide2
Introduction to the Hotel Industry
Current State of MIWhat we need and whySolution, Benefits and ROI The Future
AgendaSlide3
An Overview
Fragmented with differing stakeholdersMany data-locking legacy systemsOpaque due to control issuesLacks leadership for developmentSlide4
The Current State of MI
Different divisions - different software, different expertise
Dependence on “home-grown” Excel spreadsheetsConsolidation only in accounting Profitability by division not by “activity”No profitability by customer typeExcessive manual processingTime spent preparing rather than usingSlide5
Industry Requirement
Automated data capture and auditValidation and sharingTrend analysis and flexible drill downActivity tracking across all divisionsProfit-based yielding
Profit-based incentivesImproved forecasting and proactivityCommon hotel application and UIActionable Data To Drive StrategySlide6
Substantial increases in revenue not profit:
Incomplete tracking by activityCosts included in other departments
No recognition of capex investmentDecisions based on room’s revenue aloneCost of business acquisition ignoredOther income derived from same guest ignoredJudgement income-basedPoor trend tracking = inaccurate forecastingFacilities blocked by small groupsUncertainty = overstaffing in many departmentsMissed opportunities for bulk purchasingOffer and peak period pricing miscalculatedWeak cash and settlement controlThe Current Cost –Various HotelsSlide7
The Solution
EiB Analytics = data-sharing platformRedefine processes and check business logicDashboards for all level of management
Management skills from all divisionsUnderstanding activity profitabilityDecisions on up-to-date factsIT FLAIR + HOTEL EXPERIENCESlide8Slide9Slide10
Return on Investment
Selling and cost price monitoring
Labour productivityBulk purchasingRanking to drive competitionSales conversion acceleratedAll existing standards reviewed Time of day, day of week etc.Accurate forecasting
Legacy systems can be replaced
Effort switched from production to ACTIONSlide11
Some Quick Wins
With an investment of between £50k to £100k
Simple first stepsSavings purchasing - 5% on food and 1% on beverage - Labour efficiency - from 1% to 5+% - Discounting control – increase from 0.5% to 10% extra income at similar cost – Next stepsUse of facilities Demand pricingBetter tracking of guestsUse of profit as main measure Icing on the cakeSharing data across all managementCost aware sales team
Accelerated and improved conversion
BenchmarkingSlide12
The Future
Cloud based multiple propertiesCloud base reduces costs
PowerBI multi-view multi-deviceMultiple property platformData cleansing and automated validationAI = improved forecasting and increased profitabilitySlide13
EiB Case Study:
Hotel Analytics from Incomplete Data > Comparative P&L Statements > Power BI Dashboards
Presented by David Bridge