20110621 vc_value_event_businessinsight_mivb
TRANSCRIPT
Comprehensive Enterprise Reporting at STIB-MIVBOmar AkabiDomain Manager BI – FI
Rob RoemersPartner Taurus-i
June 21, 2011Syntra Tour&Taxis, Brussels
MIVB – STIB
Taurus-i
Where we Started
Vision and Roadmap
Methodology
Current progress
Future challenges
MIVB-STIB Regional Public Transportation for the Brussels Area founded in 1954
Employees: 6500Operating Budget: 207.150.040,8 EUR
Kilometers serviced to passengers:Metro: 3.636,1 MillionsTram: 1.669,5 MillionsBus: 1.466,9 Millions
Customers:1.100.000 Inhabitants350.000 Commuters
Public Sector Organisation
290,6 million journeys
STIB provided no less than 290.6 million journeys in 2009. This is an increase of 1.56% in relation to the previous year, and 4.5 million additional trips.
The number of journeys has continuously risen for the last 10 years. The division of journeys is as follows:
80.9 million bus journeys 76.3 million tram journeys 133.4 million metro journeys
MIVB – STIB
Taurus-i
Where we Started
Vision and Roadmap
Methodology
Current progress
Future challenges
Taurus-i
At Taurus-i, we believe that your core business is not about implementing SAP. That is why our Performance Management consultants are extraordinary people with an expert business background and a strong no-nonsense mentality.
They will guide you in your process from idea to ROI
MIVB – STIB
Taurus-i
Where we Started
Vision and Roadmap
Methodology
Current progress
Future challenges
Legacy Problems (as seen from IT)
Main painpoints
Growing disconnect between IT and business Low user confidence Poorly maintained reports Priviliged relationships between business and IT Business developing on their own and bringing in
own consultants IT responsible for data quality
Legacy Problems (as seen from Business)
Main painpoints
Data is incorrect or partially correct in systems Correcting data is too timeconsuming IT reacts too slow My excel has all the data we need Why doesn´t IT use this as a basis? I do this every month, can´t we automate this? Data “magically” changes after closure/approval
Where we started
How we started to tackle this situation Development of a BI Roadmap to achieve
Stable system environment Harmonised team structure BI Competence Center BI Quality Procedures
Enterprise Reporting Methods KPI & Report Libraries Standards & Procedures Business Sponsors & Data Owners
MIVB – STIB
Taurus-i
Where we Started
Vision and Roadmap
Methodology
Current progress
Future challenges
Long term vision
Project Mode Operational mode
Standard KPI & Reports
Enterprise reports
Daily Monitoring
Quality ManagerSupport
KPI GovernanceBoard
Business Users
High Level Roadmap for BI (IT)
Phase 1:Standards & Procedures
Phase 2:Stable Environment
Phase 3:Operational Competence Center
April 2011
December 2011
June 2012
MIVB – STIB
Taurus-i / Keneos
Where we Started
Vision and Roadmap
Methodology
Current progress
Future challenges
New IT Organisation
Advantages Clear IT – Business contact
No more priv. Relationships
Clear lines of escalation
Single Quality Manager
Operational & Project team
Leading Principals
Continual Improvement
Application Lifecycle
Management
Release Management
• Focused on increasingthe effectiveness and/or efficiency of an organisation to fulfill itspolicy and objectives.
• Covers the entire history of a software solution. Provides processes to optimize business continuity and agility.
• Align Business and IT Goals to achieve the Business operational objectives derived from the Enterprise strategy
What is the source?
Incoming business requestswhere all for “strategic” type reporting while in many areas “operational” level was notyet functional.
Created awareness amongbusiness users and willingness to invest time once the link was clear.
Analysis Process
“What do I do to answerquestion X?”
Created awarenesswithin the business thatanalysis of data alsofollows specific steps.
Leading to better specsand harmonised reports
MIVB – STIB
Taurus-i
Where we Started
Vision and Roadmap
Methodology
Current progress
Future challenges
Only one more resource tackling daily issues
Down from 3 to 4
Data loading stabilised, Reporting availability up
Internal SLAs
Harmonising Report layouts
Documenting formulas and content
Negociating Data Contracts with Data Providers
Data Quality no longer responsibility of IT
Team Structure clarified (within IT and Business)
4 releases per year
Quality control implemented
Current Progress:
In the IT organisation
High visibility Project for Executive Commitee
Covering all three business modes (Bus, Tram, Metro)
Topdown project (dashboards to operational reports)
Re-using existing developments, correcting and
creating new ones
Current Progress:
In the business – Comex Operations
Current Progress:
In the business – HR Reporting
Spin-off of Comex: HR definitions were quite clear and
HR department had a dedicated Metrics Manager that
served as a sponsor.
He also distributed a (manual created) dashboard
based on SAP data. This is now automated.
Current Progress:
In the business – Dispatching
Current Progress:
In the business – Planning in BPC
IRIS handles all dispatching events for Bus, Metro and
Tram and is crucial for the operation of the network.
Currently limited reporting is only possible for a 30 day
history (response time OLTP). This data will be made
available via SAP BI for full analysis and dispatching
terminology is being harmonised across modes.
Implemented BPC to improve planning processes and
make sure all data is available in SAP Systems.
Currently a pilot to provide mandatory reporting to the
National Bank of Belgium.
Current Progress:
In the business – DOTEvery time a vehicle door is opened or closed the time
and location are recorded. This data is analysed by
our department of transport (DOT) to find out if
schedules are kept, they look for anomalies in delay or
advance times and tweak to have optimal punctuality.
This data is loaded into SAP BI and is now available
on a daily basis to the analysts. In the past this data
was provided in hardcopy, once a month after
preparation by the department.
Current Progress:
In the business – SAP Standard
Lots of processes in our ECC are not modelled
according to SAP standard (CO, AA,…) we are slowly
removing the custom ABAP and implementing the
standard. Leading to more transparency in our source
MIVB – STIB
Taurus-i
Where we Started
Vision and Roadmap
Methodology
Current progress
Future challenges
Master Data Harmonisation
Discipline
For Quality Control
For Releases
For “Single version of the Truth”
Strong Sponsorship
Keep (and rebuild) trust of business in BI
Build business knowledge on IT side
Integrate BI reporting from top to bottom into the
enterprise
Link between operation initiatives and strategic
changes
Future Challenges