Description
Centers of Excellence combine the strategic role and governance of program management offices, business expertise of subject matter experts, and the technical knowledge of systems personnel.
Page 1
Confidential & Proprietary
Managing a Business Intelligence Center of
Excellence (BI COE) with Business Objects
A Case Study at Amtrak
Managing a Business Intelligence Center of
Excellence (BI COE) with Business Objects
A Case Study at Amtrak
Adam Getz
Manager, Enterprise Business Intelligence
Amtrak
Page 2 Confidential & Proprietary
Amtrak – National Passenger Railroad Corp
Amtrak – National Passenger Railroad Corp
Amtrak is a government-owned corporation organized in 1971
Provides intercity passenger train service in the United States
Rail network serves 527 destinations in 46 states and 3 Canadian Provinces
Incorporates over 21,000 miles of rail, and has over 20,000 employees
In 2010, Amtrak served 28.8 million passengers, and generated
$2.45 billion in revenue
Page 3 Confidential & Proprietary
What is a BI Center of Excellence?
What is a BI Center of Excellence?
Centers of Excellence combine the strategic role and governance of program
management offices, business expertise of subject matter experts, and the technical
knowledge of systems personnel.
BI COEs are centered and constructed around these foundations of an organization:
• Enterprise Coordination • Asset Management
• Common Solution Design • Infrastructure
Page 4 Confidential & Proprietary
Division 3
Division 2
Division 1
Corporate
Four Categories of BI COEs
Four Categories of BI COEs
2) Virtual BI COE 2) Virtual BI COE - -
Shared by Departments Shared by Departments
3) BI COE as Part of Operations 3) BI COE as Part of Operations- -
Overseeing Business Divisions Overseeing Business Divisions
BI COE
BI COE
COO
Division 2 Division 1
Division 3
IT Unit
IT Unit
CIO
BI COE
Finance Sales Marketing
4) Distributed BI COE 4) Distributed BI COE - -
Shared by Lines of Business Divisions Shared by Lines of Business Divisions
1) BI COE as an IT Unit 1) BI COE as an IT Unit
Implemented at Amtrak
Page 5 Confidential & Proprietary
BI COE Staff Organization at Amtrak
BI COE Staff Organization at Amtrak
Chief Information Office (CIO)
Chief Information Office (CIO)
Chief Architecture Officer (CAO)
Chief Architecture Officer (CAO)
Group Information Officers (GIOs)
Group Information Officers (GIOs)
Business Intelligence Center of
Excellence (BI COE)
Business Intelligence Center of
Excellence (BI COE)
Marketing
Mechanical
Engineering
Finance
Transportation
Operations
….
Marketing
Mechanical
Engineering
Finance
Transportation
Operations
….
Enterprise Information Group (EIG)
Enterprise Information Group (EIG)
Business Departments
and Groups
Information Technology Department
BI COE is a technology group with the
Information Technology Department
Application Teams
Marketing
Engineering
Mechanical
Finance
Transportation
Operations
Application Teams
Marketing
Engineering
Mechanical
Finance
Transportation
Operations
Page 6 Confidential & Proprietary
Business Objects & BI COE Team
Business Objects & BI COE Team
BI COE Team responsible for
Business Objects Environment
Page 7 Confidential & Proprietary
Responsibilities of Amtrak BI COE
Responsibilities of Amtrak BI COE
BI COE Team always
responsible for …
• Universe
• QAAWS / BI Web Services
Development of Crystal
Reports \ Web Intelligence \
Xcelsius Dashboards can
conducted by …
• Application (GIO) Team
• BI COE Team
Page 8 Confidential & Proprietary
Introduction to Amtrak BI COE
Introduction to Amtrak BI COE Introduction to Amtrak BI COE
BI COE Maintains and Supports Business Objects Environment & Projects
? Development of universes and dashboard middleware (QAAWS)
? Designs / implements BOBJ security
? Plans capacity of BI infrastructure
? Leverages best practices in BI implementation to efficiently use infrastructure and to produce successful
project results
? Leverages enterprise view of data (EDW and Data Marts)
? Conducts Application Support of Business Objects
Enterprise BI Projects Categorized as:
Turnkey “Heavyweight”
Shared “Lightweight”
Page 9 Confidential & Proprietary
Responsibilities of BI COE
Responsibilities of BI COE
Management of BusinessObjects Application Infrastructure
Application Administration
Application Performance Tuning
BusinessObjects Upgrades and Patches
Full Life-Cycle Projects (Turnkey & Shared Solutions)
Technical Responsibilities of BI COE
BusinessObjects Universe Design
BusinessObjects / Brio Administration
Brio to BusinessObjects Conversion
If Turnkey, BusinessObjects Report Development
If Turnkey, Xcelsius Dashboard Development
Application Support
Training / Knowledge Accelerator
Report / Dashboard Testing
Technical Oversight
Security Planning
Technical and Capacity Planning
Page 10 Confidential & Proprietary
Responsibilities of IT App / Business Teams
Responsibilities of IT App / Business Teams
IT Applications (GIO) Team Responsibilities
Project Management
Coordination with Business Teams
Budgeting / Funding for Projects
For Shared Projects, Development of BusinessObjects Reports / Dashboards
For Shared Projects, System Testing of Reports / Dashboards
Business Team Responsibilities
Documentation of Requirements
Report/Dashboard User Acceptance Testing (UAT)
Education of Casual Users
Page 11 Confidential & Proprietary
Shared “Light Weight” Solution
Shared “Light Weight” Solution
Application team gathers and documents requirements.
Application team develops, tests, supports reports and dashboards.
Application team performs functional and integration testing of reports / dashboards.
BI COE team provides technical oversight.
BI COE team designs and develops Business Objects universe, middleware, and the
security model.
BI COE team provides ongoing application support for the Business Objects platform
components of the solution.
BI COE team provides design and code reviews.
BI COE provides pre-deployment acceptance.
BI COE Team Shares Responsibilities with Application (GIO) Team
BI COE Team Shares Responsibilities with Application (GIO) Team
Page 12 Confidential & Proprietary
Turnkey “Heavy Weight” Solution
Turnkey “Heavy Weight” Solution
BI COE team designs and develops the entire solution, including the Business
Objects universe, middleware, security model, reports, and dashboards.
BI COE team works with Project Team to gather and document requirements.
BI COE team does all testing up to the point of user acceptance testing (UAT).
BI COE team provides ongoing application support for the Business Objects platform
components of the solution.
BI COE team provides design and code reviews.
BI COE provides pre-deployment acceptance.
BI COE Team Takes a Lead Role
BI COE Team Takes a Lead Role
Page 13 Confidential & Proprietary
BI Project Funding / Budgeting
BI Project Funding / Budgeting
Shared Project Turnkey Project
vs,
BI Project Budgeting
Application (GIO) Team or Business Team is responsible for budget funding
BI COE is responsible for providing LOE, Costs and Timetable estimates
Page 14 Confidential & Proprietary
Case for Shared / Turnkey Solution
Case for Shared / Turnkey Solution
Determination Criteria (Shared vs. Turnkey?)
Size / Scope / Complexity of Project
Project Schedule and Required Resources
Available Technical Resources within BI COE and Application (GIO)Team
Level of Interaction with Business
Existing State of Project
Breadth of Participating Business Units
Shared Project Turnkey Project
vs.
BI Project Initiation
Application (GIO) Team or Business submits an Project Service Request
Director, Enterprise Information Group (EIG) determines solution type
GIO, CAO, and KPI Governance Group mitigates when necessary
Page 15 Confidential & Proprietary
Services Provided by Amtrak BI COE
Services Provided by Amtrak BI COE
X X Technical Acceptance Testing
X X X Coordination of User Acceptance Testing
X X Report Development
X X X System / Functional / Integration Testing
X X Application Performance Tuning
X X X Coordination of End-User Training
X
Application / Application /
GIO Team GIO Team
Turnkey Solution Turnkey Solution
X
X
Application / Application /
GIO Team GIO Team
Shared Solution Shared Solution
X X Dashboard Development
X X BOBJ Security Planning
X X BOBJ Universe Design & Development
X X BOBJ Application Support / Maintenance
X X BOBJ Application Administration
X X Requirement Gathering & Documentation
BI COE BI COE BI COE BI COE
Service Service
Page 16 Confidential & Proprietary
BI COE – Access and Available Tools
BI COE – Access and Available Tools
Reports
Dashboards
InfoView Portal
Crystal Reports Designer
Web Intelligence
InfoView Portal
Central Management Console (CMC) *
Import Wizard *
Universe Designer*
QAAWS*
Xcelsius Designer
Crystal Reports Designer
Web Intelligence
InfoView Portal
Available Tools Available Tools
End User Access
Developer Access
Administrator
Access
Type of Type of
Access Access
Business Users
Application (GIO)
Team
BI COE
Group Group
* As The Central Management
Console (CMC), Import Wizard,
Universe Designer, and Query as a
Web Service (QAAWS) are all tools
designed and used for middleware
design and/or administration of
Business Objects environments, only
members of the BI COE will have
access to them.
Page 17 Confidential & Proprietary
Implementation of BI COE - Two Phase Plan
Implementation of BI COE - Two Phase Plan
Phase 1 (Coordination of Status)
Coordination of Status of all BI Projects
BI Projects continue as planned
BI Resources stayed in existing project teams
Phase 2 (Centralization of Projects / Resources)
BI COE responsible for Development/Deployment of BI Projects
New BI Projects must be approved by BI COE
Determination of Shared / Turnkey Projects
BI Resources managed by BI COE
Oversight of all Business Objects initiatives
Phase 1 Lasted Nine
Months
Phase 2 On-going
Page 18 Confidential & Proprietary
Centralization / De-Centralization of BI Projects
Centralization / De-Centralization of BI Projects
BI Center of Excellence BI Center of Excellence
Brio to BOBJ Conversion Universe Development
BOBJ Application
Administration
BOBJ Security
Planning
Technical Oversight
BOBJ Capacity Planning
BOBJ Performance
Testing
Application Support
CSPMI
CSPMI
eTicketing
eTicketing
Mechanical
Dashboard
Mechanical
Dashboard
BOD
Dashboard
BOD
Dashboard
Strategic Asset
Management
Strategic Asset
Management
COO
Dashboard
COO
Dashboard
Engineering
Dashboard
Engineering
Dashboard
Safety (ASIS)
Safety (ASIS)
MLOA
MLOA
Pension
Administration
Pension
Administration
Chief of Police
Chief of Police
Logistics
Logistics
Outside Circles
Business Intelligence Projects
Developed / Maintained by
Application Teams
Page 19 Confidential & Proprietary
Sample Business Intelligence Projects
Sample Business Intelligence Projects
Security, Technical Oversight, Application Support Shared E-Ticketing
Universe Development, Security, Performance Tuning, Technical Oversight,
Application Support
Shared Strategic Asset Management (SAM)
Universe Development, Security, Technical Oversight, Application Support Shared COO Dashboard
Universe Development, Security, Technical Oversight, Application Support Shared Board of Directors (BOD) Dashboard
Security, Technical Oversight, Application Support Shared Engineering Dashboard
Shared
Shared
Shared
Turnkey
Turnkey
Turnkey / Turnkey /
Shared Shared
Security, Technical Oversight, Application Support Mechanical Dashboard
Universe Development, Security, System Testing, Technical Oversight,
Application Support
Medical Leave of Absence (MLOA)
Universe Development, Security, Performance Tuning, Technical Oversight,
Application Support
Safety (ASIS)
Universe Development, Security, Web Intelligence Report Development, System
Testing, Technical Oversight, Application Support, Training, Project Management
Brio Report Conversion for Labor, TAPS,
STARS, CCMS, & RRDW
Universe Development, Security, Web Intelligence Report Development, Crystal
Reports Development, System Testing, Technical Oversight, Application Support
CSPMI
Services Provided by BI COE Services Provided by BI COE Project Project
Page 20 Confidential & Proprietary
Business Objects Support Process
Business Objects Support Process
Submits an Incident
Calls the helpdesk to
communicate incidents
with a clear description
of their issue.
Business Team
GIO Support
Team
BI COE
Help Desk
Records and Assigns
Generates an incident
(IM) and/or Service
Request (SR) into ISM
and assigns to
appropriate support
queue
ISM Support Queue
I-QHD
Provides Tier 2 Application Support
- Addresses/resolves the incident and
in case of report development
- Reassigns to BI COE in case of issue
with BOBJ infrastructure
- Reassigns to Data COE in case of
database related issue.
Examples of Teams/Projects
CSPMI Support (Justin Jose)
eTicketing Support (Justin Jose)
Dashboards (Robert Merrill)
Safety / ASIS (Olga Young)
ISM Support Queue
A-QINTRANET
A-QLFS
A-QDIS
A-QLMS
Maintains Business Objects / Brio
Infrastructure
- Addresses/resolves incidents related to
the infrastructure of Business Objects /
Brio
- Addresses/resolves incidents related
former Brio applications (Labor, RRDW,
STARS, TAPS, PCM)
- Conducts application administration of
Business Objects / Brio
Team Email Distribution Lists
DL BI COE Support
BRIOTECH
ISM Support Queue
A-QAMTBOBJ
A-QBRIO
Responsible for support/development of
Oracle & SQL Server Databases, EDW, &
ETL
ISM Queue
A-QTSDRM
Data COE
Team Email Address
DRMTECH
Client Services
Operations (CSO)
Responsible for maintaining
servers / operating systems ...
- Addresses/resolves the incident
with operating systems and servers
- Maintains OS level / patches /
maintenance / NetIQ Monitoring
- Works in the Data Center
ISM Support Queue
A-QCSO
Business Objects Support
(Maintenance) Process Flow
Management of Incidents
Page 21 Confidential & Proprietary
Enhancement Process Flow
Enhancement Process Flow
Enhancement Process Flow for
Business Intelligence and Enterprise Data
Management of ITPIRs – Small Enhancements
Submits an ITPIR
Initiates Enhancement
Request
Business Team
Project Management
Office (PMO)
Program Director,
COE
Business Sponsor
Approves the ITPIR
Approves
Enhancement Request
before being sent to IT.
Reviews & Assigns
the Request
Assigns enhancement
to GIO Project Team
Owner:
- M&PD
- Operations
- Enterprise Resources
GIO Project
Team Owner
Reviews and Clarifies
Enhancement
Submits a Center of
Excellence (COE)
Engagement Request
Further defines
enhancement request
and answers any open
questions related to
scope
Reviews & Signs Off on
COE Engagement
Request
Reviews & Provides
Level of Effort (LOE)
Reviews COE Engagement
Request and conducts
sign-off
Provides individual LOEs
and documents all Open
Engagement Requests
BI COE / Data COE /
GIO Teams
BI COE Team and Data
COE Teams of EIG Build
Enhancement
Program Office of EIG
governs both BI COE and
Data COE teams.
GIO Project Team
coordinates testing and
approvals from Business.
ITPIR
ITPIR
I
T
P
I
R
COE
Engagement
Request
Page 22 Confidential & Proprietary
Adoption of a BI COE has enabled:
Reports and dashboards deployed across Amtrak will be consistent and standardized
Streamlined business processes - due to incorporation of best practices
Managed deployments - consistent oversight incorporated into every stage of development
More accurate, consistent and repeatable project estimates
Higher project success rates
Better use and integration with the Enterprise Data Warehouse (EDW)
Higher confidence in IT department
BI COE team involvement across all BI projects:
Improves knowledge transfer and resource reuse
Creates a shared repository of information
Enhances value as subject matter experts to the business
Provides savings via improved and shared BI production support
Benefits of BI COE at Amtrak
Benefits of BI COE at Amtrak
Page 23 Confidential & Proprietary
Questions
Questions
Page 24 Confidential & Proprietary
Contact Information
Contact Information
Adam Getz
Manager, Enterprise Business Intelligence
Amtrak, National Passenger Railroad
Office: 202-906-4367
Mobile: 703.863.7202
E-mail: [email protected]
Check out www.bi-insider.com
doc_616028644.pdf
Centers of Excellence combine the strategic role and governance of program management offices, business expertise of subject matter experts, and the technical knowledge of systems personnel.
Page 1
Confidential & Proprietary
Managing a Business Intelligence Center of
Excellence (BI COE) with Business Objects
A Case Study at Amtrak
Managing a Business Intelligence Center of
Excellence (BI COE) with Business Objects
A Case Study at Amtrak
Adam Getz
Manager, Enterprise Business Intelligence
Amtrak
Page 2 Confidential & Proprietary
Amtrak – National Passenger Railroad Corp
Amtrak – National Passenger Railroad Corp
Amtrak is a government-owned corporation organized in 1971
Provides intercity passenger train service in the United States
Rail network serves 527 destinations in 46 states and 3 Canadian Provinces
Incorporates over 21,000 miles of rail, and has over 20,000 employees
In 2010, Amtrak served 28.8 million passengers, and generated
$2.45 billion in revenue
Page 3 Confidential & Proprietary
What is a BI Center of Excellence?
What is a BI Center of Excellence?
Centers of Excellence combine the strategic role and governance of program
management offices, business expertise of subject matter experts, and the technical
knowledge of systems personnel.
BI COEs are centered and constructed around these foundations of an organization:
• Enterprise Coordination • Asset Management
• Common Solution Design • Infrastructure
Page 4 Confidential & Proprietary
Division 3
Division 2
Division 1
Corporate
Four Categories of BI COEs
Four Categories of BI COEs
2) Virtual BI COE 2) Virtual BI COE - -
Shared by Departments Shared by Departments
3) BI COE as Part of Operations 3) BI COE as Part of Operations- -
Overseeing Business Divisions Overseeing Business Divisions
BI COE
BI COE
COO
Division 2 Division 1
Division 3
IT Unit
IT Unit
CIO
BI COE
Finance Sales Marketing
4) Distributed BI COE 4) Distributed BI COE - -
Shared by Lines of Business Divisions Shared by Lines of Business Divisions
1) BI COE as an IT Unit 1) BI COE as an IT Unit
Implemented at Amtrak
Page 5 Confidential & Proprietary
BI COE Staff Organization at Amtrak
BI COE Staff Organization at Amtrak
Chief Information Office (CIO)
Chief Information Office (CIO)
Chief Architecture Officer (CAO)
Chief Architecture Officer (CAO)
Group Information Officers (GIOs)
Group Information Officers (GIOs)
Business Intelligence Center of
Excellence (BI COE)
Business Intelligence Center of
Excellence (BI COE)
Marketing
Mechanical
Engineering
Finance
Transportation
Operations
….
Marketing
Mechanical
Engineering
Finance
Transportation
Operations
….
Enterprise Information Group (EIG)
Enterprise Information Group (EIG)
Business Departments
and Groups
Information Technology Department
BI COE is a technology group with the
Information Technology Department
Application Teams
Marketing
Engineering
Mechanical
Finance
Transportation
Operations
Application Teams
Marketing
Engineering
Mechanical
Finance
Transportation
Operations
Page 6 Confidential & Proprietary
Business Objects & BI COE Team
Business Objects & BI COE Team
BI COE Team responsible for
Business Objects Environment
Page 7 Confidential & Proprietary
Responsibilities of Amtrak BI COE
Responsibilities of Amtrak BI COE
BI COE Team always
responsible for …
• Universe
• QAAWS / BI Web Services
Development of Crystal
Reports \ Web Intelligence \
Xcelsius Dashboards can
conducted by …
• Application (GIO) Team
• BI COE Team
Page 8 Confidential & Proprietary
Introduction to Amtrak BI COE
Introduction to Amtrak BI COE Introduction to Amtrak BI COE
BI COE Maintains and Supports Business Objects Environment & Projects
? Development of universes and dashboard middleware (QAAWS)
? Designs / implements BOBJ security
? Plans capacity of BI infrastructure
? Leverages best practices in BI implementation to efficiently use infrastructure and to produce successful
project results
? Leverages enterprise view of data (EDW and Data Marts)
? Conducts Application Support of Business Objects
Enterprise BI Projects Categorized as:
Turnkey “Heavyweight”
Shared “Lightweight”
Page 9 Confidential & Proprietary
Responsibilities of BI COE
Responsibilities of BI COE
Management of BusinessObjects Application Infrastructure
Application Administration
Application Performance Tuning
BusinessObjects Upgrades and Patches
Full Life-Cycle Projects (Turnkey & Shared Solutions)
Technical Responsibilities of BI COE
BusinessObjects Universe Design
BusinessObjects / Brio Administration
Brio to BusinessObjects Conversion
If Turnkey, BusinessObjects Report Development
If Turnkey, Xcelsius Dashboard Development
Application Support
Training / Knowledge Accelerator
Report / Dashboard Testing
Technical Oversight
Security Planning
Technical and Capacity Planning
Page 10 Confidential & Proprietary
Responsibilities of IT App / Business Teams
Responsibilities of IT App / Business Teams
IT Applications (GIO) Team Responsibilities
Project Management
Coordination with Business Teams
Budgeting / Funding for Projects
For Shared Projects, Development of BusinessObjects Reports / Dashboards
For Shared Projects, System Testing of Reports / Dashboards
Business Team Responsibilities
Documentation of Requirements
Report/Dashboard User Acceptance Testing (UAT)
Education of Casual Users
Page 11 Confidential & Proprietary
Shared “Light Weight” Solution
Shared “Light Weight” Solution
Application team gathers and documents requirements.
Application team develops, tests, supports reports and dashboards.
Application team performs functional and integration testing of reports / dashboards.
BI COE team provides technical oversight.
BI COE team designs and develops Business Objects universe, middleware, and the
security model.
BI COE team provides ongoing application support for the Business Objects platform
components of the solution.
BI COE team provides design and code reviews.
BI COE provides pre-deployment acceptance.
BI COE Team Shares Responsibilities with Application (GIO) Team
BI COE Team Shares Responsibilities with Application (GIO) Team
Page 12 Confidential & Proprietary
Turnkey “Heavy Weight” Solution
Turnkey “Heavy Weight” Solution
BI COE team designs and develops the entire solution, including the Business
Objects universe, middleware, security model, reports, and dashboards.
BI COE team works with Project Team to gather and document requirements.
BI COE team does all testing up to the point of user acceptance testing (UAT).
BI COE team provides ongoing application support for the Business Objects platform
components of the solution.
BI COE team provides design and code reviews.
BI COE provides pre-deployment acceptance.
BI COE Team Takes a Lead Role
BI COE Team Takes a Lead Role
Page 13 Confidential & Proprietary
BI Project Funding / Budgeting
BI Project Funding / Budgeting
Shared Project Turnkey Project
vs,
BI Project Budgeting
Application (GIO) Team or Business Team is responsible for budget funding
BI COE is responsible for providing LOE, Costs and Timetable estimates
Page 14 Confidential & Proprietary
Case for Shared / Turnkey Solution
Case for Shared / Turnkey Solution
Determination Criteria (Shared vs. Turnkey?)
Size / Scope / Complexity of Project
Project Schedule and Required Resources
Available Technical Resources within BI COE and Application (GIO)Team
Level of Interaction with Business
Existing State of Project
Breadth of Participating Business Units
Shared Project Turnkey Project
vs.
BI Project Initiation
Application (GIO) Team or Business submits an Project Service Request
Director, Enterprise Information Group (EIG) determines solution type
GIO, CAO, and KPI Governance Group mitigates when necessary
Page 15 Confidential & Proprietary
Services Provided by Amtrak BI COE
Services Provided by Amtrak BI COE
X X Technical Acceptance Testing
X X X Coordination of User Acceptance Testing
X X Report Development
X X X System / Functional / Integration Testing
X X Application Performance Tuning
X X X Coordination of End-User Training
X
Application / Application /
GIO Team GIO Team
Turnkey Solution Turnkey Solution
X
X
Application / Application /
GIO Team GIO Team
Shared Solution Shared Solution
X X Dashboard Development
X X BOBJ Security Planning
X X BOBJ Universe Design & Development
X X BOBJ Application Support / Maintenance
X X BOBJ Application Administration
X X Requirement Gathering & Documentation
BI COE BI COE BI COE BI COE
Service Service
Page 16 Confidential & Proprietary
BI COE – Access and Available Tools
BI COE – Access and Available Tools
Reports
Dashboards
InfoView Portal
Crystal Reports Designer
Web Intelligence
InfoView Portal
Central Management Console (CMC) *
Import Wizard *
Universe Designer*
QAAWS*
Xcelsius Designer
Crystal Reports Designer
Web Intelligence
InfoView Portal
Available Tools Available Tools
End User Access
Developer Access
Administrator
Access
Type of Type of
Access Access
Business Users
Application (GIO)
Team
BI COE
Group Group
* As The Central Management
Console (CMC), Import Wizard,
Universe Designer, and Query as a
Web Service (QAAWS) are all tools
designed and used for middleware
design and/or administration of
Business Objects environments, only
members of the BI COE will have
access to them.
Page 17 Confidential & Proprietary
Implementation of BI COE - Two Phase Plan
Implementation of BI COE - Two Phase Plan
Phase 1 (Coordination of Status)
Coordination of Status of all BI Projects
BI Projects continue as planned
BI Resources stayed in existing project teams
Phase 2 (Centralization of Projects / Resources)
BI COE responsible for Development/Deployment of BI Projects
New BI Projects must be approved by BI COE
Determination of Shared / Turnkey Projects
BI Resources managed by BI COE
Oversight of all Business Objects initiatives
Phase 1 Lasted Nine
Months
Phase 2 On-going
Page 18 Confidential & Proprietary
Centralization / De-Centralization of BI Projects
Centralization / De-Centralization of BI Projects
BI Center of Excellence BI Center of Excellence
Brio to BOBJ Conversion Universe Development
BOBJ Application
Administration
BOBJ Security
Planning
Technical Oversight
BOBJ Capacity Planning
BOBJ Performance
Testing
Application Support
CSPMI
CSPMI
eTicketing
eTicketing
Mechanical
Dashboard
Mechanical
Dashboard
BOD
Dashboard
BOD
Dashboard
Strategic Asset
Management
Strategic Asset
Management
COO
Dashboard
COO
Dashboard
Engineering
Dashboard
Engineering
Dashboard
Safety (ASIS)
Safety (ASIS)
MLOA
MLOA
Pension
Administration
Pension
Administration
Chief of Police
Chief of Police
Logistics
Logistics
Outside Circles
Business Intelligence Projects
Developed / Maintained by
Application Teams
Page 19 Confidential & Proprietary
Sample Business Intelligence Projects
Sample Business Intelligence Projects
Security, Technical Oversight, Application Support Shared E-Ticketing
Universe Development, Security, Performance Tuning, Technical Oversight,
Application Support
Shared Strategic Asset Management (SAM)
Universe Development, Security, Technical Oversight, Application Support Shared COO Dashboard
Universe Development, Security, Technical Oversight, Application Support Shared Board of Directors (BOD) Dashboard
Security, Technical Oversight, Application Support Shared Engineering Dashboard
Shared
Shared
Shared
Turnkey
Turnkey
Turnkey / Turnkey /
Shared Shared
Security, Technical Oversight, Application Support Mechanical Dashboard
Universe Development, Security, System Testing, Technical Oversight,
Application Support
Medical Leave of Absence (MLOA)
Universe Development, Security, Performance Tuning, Technical Oversight,
Application Support
Safety (ASIS)
Universe Development, Security, Web Intelligence Report Development, System
Testing, Technical Oversight, Application Support, Training, Project Management
Brio Report Conversion for Labor, TAPS,
STARS, CCMS, & RRDW
Universe Development, Security, Web Intelligence Report Development, Crystal
Reports Development, System Testing, Technical Oversight, Application Support
CSPMI
Services Provided by BI COE Services Provided by BI COE Project Project
Page 20 Confidential & Proprietary
Business Objects Support Process
Business Objects Support Process
Submits an Incident
Calls the helpdesk to
communicate incidents
with a clear description
of their issue.
Business Team
GIO Support
Team
BI COE
Help Desk
Records and Assigns
Generates an incident
(IM) and/or Service
Request (SR) into ISM
and assigns to
appropriate support
queue
ISM Support Queue
I-QHD
Provides Tier 2 Application Support
- Addresses/resolves the incident and
in case of report development
- Reassigns to BI COE in case of issue
with BOBJ infrastructure
- Reassigns to Data COE in case of
database related issue.
Examples of Teams/Projects
CSPMI Support (Justin Jose)
eTicketing Support (Justin Jose)
Dashboards (Robert Merrill)
Safety / ASIS (Olga Young)
ISM Support Queue
A-QINTRANET
A-QLFS
A-QDIS
A-QLMS
Maintains Business Objects / Brio
Infrastructure
- Addresses/resolves incidents related to
the infrastructure of Business Objects /
Brio
- Addresses/resolves incidents related
former Brio applications (Labor, RRDW,
STARS, TAPS, PCM)
- Conducts application administration of
Business Objects / Brio
Team Email Distribution Lists
DL BI COE Support
BRIOTECH
ISM Support Queue
A-QAMTBOBJ
A-QBRIO
Responsible for support/development of
Oracle & SQL Server Databases, EDW, &
ETL
ISM Queue
A-QTSDRM
Data COE
Team Email Address
DRMTECH
Client Services
Operations (CSO)
Responsible for maintaining
servers / operating systems ...
- Addresses/resolves the incident
with operating systems and servers
- Maintains OS level / patches /
maintenance / NetIQ Monitoring
- Works in the Data Center
ISM Support Queue
A-QCSO
Business Objects Support
(Maintenance) Process Flow
Management of Incidents
Page 21 Confidential & Proprietary
Enhancement Process Flow
Enhancement Process Flow
Enhancement Process Flow for
Business Intelligence and Enterprise Data
Management of ITPIRs – Small Enhancements
Submits an ITPIR
Initiates Enhancement
Request
Business Team
Project Management
Office (PMO)
Program Director,
COE
Business Sponsor
Approves the ITPIR
Approves
Enhancement Request
before being sent to IT.
Reviews & Assigns
the Request
Assigns enhancement
to GIO Project Team
Owner:
- M&PD
- Operations
- Enterprise Resources
GIO Project
Team Owner
Reviews and Clarifies
Enhancement
Submits a Center of
Excellence (COE)
Engagement Request
Further defines
enhancement request
and answers any open
questions related to
scope
Reviews & Signs Off on
COE Engagement
Request
Reviews & Provides
Level of Effort (LOE)
Reviews COE Engagement
Request and conducts
sign-off
Provides individual LOEs
and documents all Open
Engagement Requests
BI COE / Data COE /
GIO Teams
BI COE Team and Data
COE Teams of EIG Build
Enhancement
Program Office of EIG
governs both BI COE and
Data COE teams.
GIO Project Team
coordinates testing and
approvals from Business.
ITPIR
ITPIR
I
T
P
I
R
COE
Engagement
Request
Page 22 Confidential & Proprietary
Adoption of a BI COE has enabled:
Reports and dashboards deployed across Amtrak will be consistent and standardized
Streamlined business processes - due to incorporation of best practices
Managed deployments - consistent oversight incorporated into every stage of development
More accurate, consistent and repeatable project estimates
Higher project success rates
Better use and integration with the Enterprise Data Warehouse (EDW)
Higher confidence in IT department
BI COE team involvement across all BI projects:
Improves knowledge transfer and resource reuse
Creates a shared repository of information
Enhances value as subject matter experts to the business
Provides savings via improved and shared BI production support
Benefits of BI COE at Amtrak
Benefits of BI COE at Amtrak
Page 23 Confidential & Proprietary
Questions
Questions
Page 24 Confidential & Proprietary
Contact Information
Contact Information
Adam Getz
Manager, Enterprise Business Intelligence
Amtrak, National Passenger Railroad
Office: 202-906-4367
Mobile: 703.863.7202
E-mail: [email protected]
Check out www.bi-insider.com
doc_616028644.pdf