smarter den with business intelligence (bi) and analytics · smarter den with business intelligence...
TRANSCRIPT
Smarter DEN with Business Intelligence (BI) and Analytics
SITA Air Transport IT SummitSmarter At Every Step
ROBERT KASTELITZ, Senior Vice President of Technologies - CIODENVER INTERNATIONAL AIRPORT, TECHNOLOGIES DIVISIONMay 26th, 2016
My agenda today
To share with you how a thoughtful Digital Strategy, and its careful execution, introduced critical Business Intelligence and Analytics capabilities to DEN stakeholders that..
• Made us smarter and greatly enhanced our competitive advantage
2
BI and Analytics:A Top DEN Strategic Initiative
DEN’s CEO and her Leadership’s vision for the BI and Analytics Strategic Initiative is to:
“Empower DEN with Data-Driven Decisions”… to enhance competitive advantage
Our goal:Sustain a Smart BI and analytics infrastructure to enable prediction and optimization to maintain DEN’s momentum and competitive edge
3
DEN BI Business Drivers
4
“My team can’t get to data and reports.”
“There’s too much data for my team to make sense of.”
“My team doesn’t have the tools or skills to make the
data actionable.”
We created a solid
foundation for BI service to address their requirements.
“Our financial data is now available for every leader and team to understand.” (Finance
dashboard)
“Without your support to unlock our data, we never
would have prioritized process improvements.” (Concessions
Revenue project)
“We have been able to free up analyst time so they can better
understand our data.”(Flight Operations)
Three years ago, our customers voiced
their needs…
We heard them and we took
action…
tools as part of their decision-making
processes…
divisions are using BIToday, several DEN
DEN BI Maturity Journey
DEN’s CompetitiveAdvantage
DEN’s Analytic Maturity
“Empower DEN with data-driven decisions”
Raw Data
ScorecardsAnd
Dashboards
2012-2016
Clean Data StandardReports
Ad-Hoc Reports
Predict & Optimize
Predictive Analytics
Optimize Performance
2017 - 2019
6
MATURITY
CA
PAB
ILIT
Y
Integrate additional Enterprise information
Upgrade BI platform to support new capabilities
Absorb data from new sources (Social, Sensor, Videos, …)
Extend traditional BI to predictive analysis, scenario playing, problem modeling, …
How do we improve customer experience
at DEN?
How can we work with our partners to
improve operational efficiencies/security?
How do we maximize sustainability and
optimize asset management?
How do we identify and predict ways to
positively effect financial
performance?
Advanced Analytics for ingestion, preparation, processing, persisting, publishing and visualizing information
Long-Term Strategy: Optimization
2012
ASQ web site
Manual data sources
Enterprise
Aerobahn
Infopilot
Gate Manager
PASSUR
Operations
AMS
Maximo
Propworks
Revenue/Finance
SDE
Excel
SharePointtask lists
Monitoring systems
Technologies
Canned reports are system provided…
A lot of time is spent working with labor-intensive, manual, raw data exports…
Siloed systems with minimal or no data integration…
Other systems
Smarter Every Year!2012: The Days of Traditional Canned Reports
2013
Aerobahn
Infopilot
Gate Manager
PASSUR
Operations
AMS
Maximo
Propworks
Revenue/Finance
Technologies
SDEExcelSharePoint task listsMonitoring systems
Metrics for service availability and monitoring
Other systems
Smarter Every Year!2013: The Start of DEN’s BI Initiative
2014
Technologies
AskITExcelOpenNMS (monitoring)SharePoint task lists
Flight Operations
Aerobahn
Initial flight data
cleanup, integration
and metrics
BI infrastructure refresh
Enterprise
ASQ web siteManual data sources
Smarter Every Year!2014: BI Supports Technologies Performance Management
Technologies
AskITExcel
OpenNMS (monitoring)SharePoint task lists
Revenue Management
AMSMaximo
Propworks
Flight Operations
Aerobahn
Enterprise
ASQ web siteManual data sources
Self-service CapabilitiesPerformance Dashboards
Advanced Analytics
2015BI infrastructure and SharePoint enhancements
Smarter Every Year!2015: Core DEN BI Service Established
We are rapidly moving into Advanced Analytics for:
• Prediction and Optimization
11
With a particular focus on:• Optimal DEN operations, and• Safe and efficient passenger journey
But We Are Just Getting Started…
DEN BI Future State Vision
D
“Empower DEN with data-driven decisions”
DEN Business Intelligence Services
Enterprise Reporting
Environment
Data
Data Catalogs“Information
Management”
Intelligence Action
End-User Service
Offerings
Improving DEN’s Competitive Advantage
Data Models“Single Source
of Truth”
Standard andAd-Hoc Reports
Scorecards& Dashboards
Self-Service Analytics Tools
Automated Reporting &
Delivery
Maturing DEN Analytics to Optimize Performance
Data Sources
Applications
Sensors & Devices
Predictive Analytics
Finance Dashboard
Concession Revenue Dashboard
TSA Wait Time DisplaysSITA south screening
POC
Predicting Wait Times & Impacts on DEN
RevenueASQ Traveler Satisfaction
Analyzing Overall Satby Terminal
Data Stewardship “Single Source of Truth”
Predictive Analytics with SITA at DEN:Predicting TSA Wait Times and Impact on DEN Operations
Business Case:
• Calculate and predict Wait Times
• Analyze dwell times
• Evaluate correlation of Wait Times to other DEN operations
• Enhance overall Passenger experience at DEN
Proof of Concept:
• Predict TSA Wait Times
• South Security Point at Jeppesen Terminal
Implementation:• All DEN security check points
13
Predictive Analytics with SITA at DEN:Predicting TSA Wait Times and Impact on DEN Operations
What is next:
• Integration with Location Based Services (Wi-Fi + Bluetooth using both effectively)
• Passenger flow pattern Analysis
• Dwell Time Analysis
• Correlations with other Airport operations data
14
Our Three Year BI Roadmap (2017 – 2019)
Internet of Things/Predictive Analytics
Improve Maintenance and Conveyance Efficiencies
“Partnering for operational
excellence”
Predictive Analytics/PerformanceOptimization
Improve Facility and Operational Efficiencies/Security
“Partnering for operational excellence”
Social Media/Sentiment AnalysisIncrease DEN Passenger
Satisfaction “Winning the hearts of our
customers”
Integrated Data(Internal and External)
Improve DEN Partner Operational Efficiencies via
Collaboration“Putting DEN on the world map”
Optimize Environmental and Operational Sustainability
“Excelling in financial performance”
Passenger/Behavior Analytics
Technologies Value Proposition?• Thoughtful DIGITAL STRATEGY and Execution to Transition from a Utilities
Provider to a Strategic Partner
Enterprise Strategic Objectives
Division Strategic ObjectivesBusiness Relationship Manager Feedback
2030 Financial PlanDEN Master Plan
IT and Airport Industry Trends
Technologies Future State Objectives
Technologies Strategic Programs
2017 GoalsBusiness Cases
Funding Requests
Projects
Roadmaps
2018 Goals
2016 Goals
2015 Goals
Business Context
Technologies Digital
Strategy
16
DISCLAIMER
Any use, republication or redistribution of this content is
expressly prohibited without the prior written consent of the
Author. Permission to copy and reproduce content may be
granted by the author, at their discretion, and by request
only.
Source: presentation of ROBERT KASTELITZ, DEN
at the 2016 SITA Air Transport IT Summit, Barcelona.
2016 Air Transport IT Summit. Confidential. © SITA 2016