Description
Business Intelligence Center of Excellence (BI COE) with Business Objects
Business Intelligence Center of Excellence
(BI COE) with Business Objects
A Case Study at Stanley Black & Decker
Business Intelligence Center of Excellence
(BI COE) with Business Objects
A Case Study at Stanley Black & Decker
Adam Getz
Practice Manager, Business Intelligence
DCS Consulting, Inc.
DCS Consulting - Corporate Overview DCS Consulting - Corporate Overview
About DCS Consulting:
DCS Consulting is a Business Intelligence and Data Warehousing (BI/DW)
professional services firm specializing in providing highly experienced
consultants.
• Located in Washington DC Area.
• SAP Business Objects – Extended Business Partner.
• Our customers range from DOD and Federal Civilian clients to Health
Care, Financial Services, Consumer Goods, & Energy.
• Technology Expertise:
• SAP Business Objects
• Visual Cue
• DOMO
• CGI Momentum Financials
DCS Consulting, Inc.
9048 John Sutherland Lane, Lorton, VA 22079 | P: 703-863-7202 | [email protected] | www.dcsfederal.com
Page: 2
Stanley Black & Decker - Overview Stanley Black & Decker - Overview
The Client:
Stanley Black & Decker is a manufacturer of tools and hardware and
provider of security products and locks.
• Headquarters: New Britain, CT
• Industry: Consumer Goods
• Products: Tools, Hardware, Security, Locks, Medical Equipment
• Revenue: $8.41 Billion (2010)
• Employees: 36,700 (2010)
• Merger: The Stanley Works acquired Black & Decker in 2010
DCS Consulting, Inc.
9048 John Sutherland Lane, Lorton, VA 22079 | P: 703-863-7202 | [email protected] | www.dcsfederal.com
Page: 3
Business Intelligence COE - Defined
DCS Consulting, Inc.
9048 John Sutherland Lane, Lorton, VA 22079 | P: 703-863-7202 | [email protected] | www.dcsfederal.com
Page: 4
Centers of Excellence (COE)
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:
• Architecture • Process
• Human Capital • Culture
Business Intelligence COE - Categories
DCS Consulting, Inc.
9048 John Sutherland Lane, Lorton, VA 22079 | P: 703-863-7202 | [email protected] | www.dcsfederal.com
Page: 5
Division 3
Division 2
Division 1
Corporate
2) Virtual BI COE -
Shared by Departments
3) BI COE as Part of Operations-
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 -
Shared by Lines of Business Divisions
1) BI COE as an IT Unit
Implemented at Stanley Black & Decker
Business Intelligence COE – Primary Tasks
DCS Consulting, Inc.
9048 John Sutherland Lane, Lorton, VA 22079 | P: 703-863-7202 | [email protected] | www.dcsfederal.com
Governance
Standardization
Compliance
Centralization
Integrity
Coordination
Oversight
o Governance of organization and system changes
o Standards across all deployments
o Compliance with regulations
o Centralization of administration
o Integrity of business process and systems
o Coordination of resources
o Oversight and control
Primary Tasks of BI COE at Stanley Primary Tasks of BI COE at Stanley
BI / DW Technologies Used at Stanley
DCS Consulting, Inc.
9048 John Sutherland Lane, Lorton, VA 22079 | P: 703-863-7202 | [email protected] | www.dcsfederal.com
The Business Intelligence and Data Warehousing (BI / DW)
Environment at Stanley consists of the following Technologies:
Category Technology(s)
Source Systems SAP, ACG, BAAN, Hyperion, JD Edwards
Data Integration (ETL) IBM Ascential Data Stage 7.5 and 8.1
Data Warehouse / Data Marts MS SQL Server 2000
Data Modeling Sybase Power Designer
Business Intelligence Applications
Business Objects 3.1, Web Intelligence, Desktop
Intelligence, Crystal Reports, Xcelsius, Qlikview
Business Intelligence Web Server Apache Tomcat
Page: 7
BI / DW Technologies at Stanley
DCS Consulting, Inc.
9048 John Sutherland Lane, Lorton, VA 22079 | P: 703-863-7202 | [email protected] | www.dcsfederal.com
Page: 8
BI COE at Stanley has responsibility over both BI and DW Environments
• ETL (Data Stage)
• Data Warehouse / Data Marts (MS SQL Server)
• Business Intelligence (Business Objects)
Challenges of a Shared BI Environment
DCS Consulting, Inc.
9048 John Sutherland Lane, Lorton, VA 22079 | P: 703-863-7202 | [email protected] | www.dcsfederal.com
Enterprise Governance
Defining the Common Enterprise Business Model
Technology Standards
Team Structures / Roles / Responsibilities
Corporate Communications
Internationalization and Multiple Languages
Established Processes
Organizational Change
Page: 9
Business Intelligence Model at Stanley
DCS Consulting, Inc.
9048 John Sutherland Lane, Lorton, VA 22079 | P: 703-863-7202 | [email protected] | www.dcsfederal.com
BI COE
CDIY
EMEA
IAR
SMS
Corp
SAT
Local Development of BI & DW Solutions across a Shared Architecture
- Facilitates local analysis and reporting delivery
- Utilizes the existing environment as a shared asset
- Mitigates risks of a shared environment
- Distributes workload
Application Development Teams For Each Business Unit:
- Corporate (Corp)
- Construction & Do It Yourself (CDIY)
- Industrial & Automotive Repair (IAR)
- Stanley Mechanical Security (SMS)
- Stanley Access Technologies (SAT)
- Europe, Middle East, Africa (EMEA)
Page: 10
BI COE
(inner circle)
Business Objects and the BI COE at Stanley
DCS Consulting, Inc.
9048 John Sutherland Lane, Lorton, VA 22079 | P: 703-863-7202 | [email protected] | www.dcsfederal.com
Business Objects Technologies Used at SBD:
Central Management Console
InfoviewPortal
Business Objects Universes
Web Intelligence
Web Intelligence Rich Client
Desktop Intelligence
Crystal Reports
Xcelsius Dashboards
Stanley Black & Decker has standardized on Business Objects as its Enterprise Reporting
Environment. The Stanley BI COE maintains the Business Objects Environment.
C
r
y
s
t
a
l
R
e
p
o
r
t
s
Administration
BI Center of
Excellence
(BICOE)
Business Objects and the BI COE at Stanley
DCS Consulting, Inc.
9048 John Sutherland Lane, Lorton, VA 22079 | P: 703-863-7202 | [email protected] | www.dcsfederal.com
Responsibilities of BI COE Related to Business Objects
Governance & Change Reviews
Technical and Design Reviews
Migrations of Components
Administration and Security
Communications and Announcements
Application (BusinessObjects) Management
Stanley Black & Decker has standardized on Business Objects as its Enterprise Reporting
Environment. The Stanley BI COE maintains the Business Objects Environment.
C
r
y
s
t
a
l
R
e
p
o
r
t
s
Administration
BI Center of
Excellence
(BICOE)
Business Intelligence Responsibilities at Stanley
DCS Consulting, Inc.
9048 John Sutherland Lane, Lorton, VA 22079 | P: 703-863-7202 | [email protected] | www.dcsfederal.com
The BI COE has the primary responsibility for :
- Common Infrastructure and Services
- Enterprise Standards
- Application Administration & Security
- Communications Amongst Teams
- Environment Migrations
- Design & Readiness Reviews
- Governance & Change Reviews
Business Unit Application Development
teams have responsibility for:
- Communications with Users / UAT
- Requirements Analysis
- Application Development
- Resources / Staffing
- Application Maintenance
Page: 13
BI COE – Access and Available Tools
DCS Consulting, Inc.
9048 John Sutherland Lane, Lorton, VA 22079 | P: 703-863-7202 | [email protected] | www.dcsfederal.com
Page: 14
Group
Type of
Access
Available Tools
BI COE
Administrator
Access
Central Management Console (CMC) *
Import Wizard *
Universe Designer
Xcelsius Designer
Crystal Reports Designer
Web Intelligence
InfoView Portal
Application Team Developer Access
Universe Designer
Xcelsius Designer
Crystal Reports Designer
Web Intelligence
InfoView Portal
Business Users End User Access
Reports
Dashboards
InfoView Portal
* As The Central
Management Console (CMC)
and Import Wizard are tools
designed for administration
of Business Objects
environments, only
members of the BI COE have
access to them.
Distributed Application Development at Stanley
DCS Consulting, Inc.
9048 John Sutherland Lane, Lorton, VA 22079 | P: 703-863-7202 | [email protected] | www.dcsfederal.com
Reasons for Distributed Application Development of
Business Intelligence Solutions at Stanley
- Synchronous Business Intelligence Development
- Alignment to Customers and Business Units
- Expanded Knowledge Base
- Appropriate Governance Models
- Shared Use of Technology
Page: 15
BI COE
CDIY
EMEA
IAR
SMS
Corp
SAT
Distributed Development Between BI COE and
Application Team Teams
Benefits of BI COE at Stanley
DCS Consulting, Inc.
9048 John Sutherland Lane, Lorton, VA 22079 | P: 703-863-7202 | [email protected] | www.dcsfederal.com
Adoption of a BI COE at Stanley has enabled:
Shared use of BI/DW technologies
Single point-of-contact for administration
Managed deployments - consistent oversight incorporated into every stage of
development
Increased level of communications amongst application teams
More accurate, consistent and repeatable project estimates
Higher project success rates
Better use and integration with the Stanley Data Warehouse (SDW) and Data
Marts
Improved sharing of knowledge amongst application teams
Decreased risk amongst projects
Consistency in design and technical reviews
Higher confidence in IT department
Page: 16
Questions
DCS Consulting, Inc.
9048 John Sutherland Lane, Lorton, VA 22079 | P: 703-863-7202 | [email protected] | www.dcsfederal.com
Page: 17
DCS Consulting - Contact Us
DCS Consulting, Inc.
9048 John Sutherland Lane, Lorton, VA 22079
703-966-5831
Adam Getz
[email protected]
WWW.DCSFEDERAL.COM
DCS Consulting, Inc.
9048 John Sutherland Lane, Lorton, VA 22079 | P: 703-966-5831 | [email protected] | www.dcsfederal.com
Page: 18
Check out www.bi-insider.com
doc_669871730.pdf
Business Intelligence Center of Excellence (BI COE) with Business Objects
Business Intelligence Center of Excellence
(BI COE) with Business Objects
A Case Study at Stanley Black & Decker
Business Intelligence Center of Excellence
(BI COE) with Business Objects
A Case Study at Stanley Black & Decker
Adam Getz
Practice Manager, Business Intelligence
DCS Consulting, Inc.
DCS Consulting - Corporate Overview DCS Consulting - Corporate Overview
About DCS Consulting:
DCS Consulting is a Business Intelligence and Data Warehousing (BI/DW)
professional services firm specializing in providing highly experienced
consultants.
• Located in Washington DC Area.
• SAP Business Objects – Extended Business Partner.
• Our customers range from DOD and Federal Civilian clients to Health
Care, Financial Services, Consumer Goods, & Energy.
• Technology Expertise:
• SAP Business Objects
• Visual Cue
• DOMO
• CGI Momentum Financials
DCS Consulting, Inc.
9048 John Sutherland Lane, Lorton, VA 22079 | P: 703-863-7202 | [email protected] | www.dcsfederal.com
Page: 2
Stanley Black & Decker - Overview Stanley Black & Decker - Overview
The Client:
Stanley Black & Decker is a manufacturer of tools and hardware and
provider of security products and locks.
• Headquarters: New Britain, CT
• Industry: Consumer Goods
• Products: Tools, Hardware, Security, Locks, Medical Equipment
• Revenue: $8.41 Billion (2010)
• Employees: 36,700 (2010)
• Merger: The Stanley Works acquired Black & Decker in 2010
DCS Consulting, Inc.
9048 John Sutherland Lane, Lorton, VA 22079 | P: 703-863-7202 | [email protected] | www.dcsfederal.com
Page: 3
Business Intelligence COE - Defined
DCS Consulting, Inc.
9048 John Sutherland Lane, Lorton, VA 22079 | P: 703-863-7202 | [email protected] | www.dcsfederal.com
Page: 4
Centers of Excellence (COE)
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:
• Architecture • Process
• Human Capital • Culture
Business Intelligence COE - Categories
DCS Consulting, Inc.
9048 John Sutherland Lane, Lorton, VA 22079 | P: 703-863-7202 | [email protected] | www.dcsfederal.com
Page: 5
Division 3
Division 2
Division 1
Corporate
2) Virtual BI COE -
Shared by Departments
3) BI COE as Part of Operations-
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 -
Shared by Lines of Business Divisions
1) BI COE as an IT Unit
Implemented at Stanley Black & Decker
Business Intelligence COE – Primary Tasks
DCS Consulting, Inc.
9048 John Sutherland Lane, Lorton, VA 22079 | P: 703-863-7202 | [email protected] | www.dcsfederal.com
Governance
Standardization
Compliance
Centralization
Integrity
Coordination
Oversight
o Governance of organization and system changes
o Standards across all deployments
o Compliance with regulations
o Centralization of administration
o Integrity of business process and systems
o Coordination of resources
o Oversight and control
Primary Tasks of BI COE at Stanley Primary Tasks of BI COE at Stanley
BI / DW Technologies Used at Stanley
DCS Consulting, Inc.
9048 John Sutherland Lane, Lorton, VA 22079 | P: 703-863-7202 | [email protected] | www.dcsfederal.com
The Business Intelligence and Data Warehousing (BI / DW)
Environment at Stanley consists of the following Technologies:
Category Technology(s)
Source Systems SAP, ACG, BAAN, Hyperion, JD Edwards
Data Integration (ETL) IBM Ascential Data Stage 7.5 and 8.1
Data Warehouse / Data Marts MS SQL Server 2000
Data Modeling Sybase Power Designer
Business Intelligence Applications
Business Objects 3.1, Web Intelligence, Desktop
Intelligence, Crystal Reports, Xcelsius, Qlikview
Business Intelligence Web Server Apache Tomcat
Page: 7
BI / DW Technologies at Stanley
DCS Consulting, Inc.
9048 John Sutherland Lane, Lorton, VA 22079 | P: 703-863-7202 | [email protected] | www.dcsfederal.com
Page: 8
BI COE at Stanley has responsibility over both BI and DW Environments
• ETL (Data Stage)
• Data Warehouse / Data Marts (MS SQL Server)
• Business Intelligence (Business Objects)
Challenges of a Shared BI Environment
DCS Consulting, Inc.
9048 John Sutherland Lane, Lorton, VA 22079 | P: 703-863-7202 | [email protected] | www.dcsfederal.com
Enterprise Governance
Defining the Common Enterprise Business Model
Technology Standards
Team Structures / Roles / Responsibilities
Corporate Communications
Internationalization and Multiple Languages
Established Processes
Organizational Change
Page: 9
Business Intelligence Model at Stanley
DCS Consulting, Inc.
9048 John Sutherland Lane, Lorton, VA 22079 | P: 703-863-7202 | [email protected] | www.dcsfederal.com
BI COE
CDIY
EMEA
IAR
SMS
Corp
SAT
Local Development of BI & DW Solutions across a Shared Architecture
- Facilitates local analysis and reporting delivery
- Utilizes the existing environment as a shared asset
- Mitigates risks of a shared environment
- Distributes workload
Application Development Teams For Each Business Unit:
- Corporate (Corp)
- Construction & Do It Yourself (CDIY)
- Industrial & Automotive Repair (IAR)
- Stanley Mechanical Security (SMS)
- Stanley Access Technologies (SAT)
- Europe, Middle East, Africa (EMEA)
Page: 10
BI COE
(inner circle)
Business Objects and the BI COE at Stanley
DCS Consulting, Inc.
9048 John Sutherland Lane, Lorton, VA 22079 | P: 703-863-7202 | [email protected] | www.dcsfederal.com
Business Objects Technologies Used at SBD:
Central Management Console
InfoviewPortal
Business Objects Universes
Web Intelligence
Web Intelligence Rich Client
Desktop Intelligence
Crystal Reports
Xcelsius Dashboards
Stanley Black & Decker has standardized on Business Objects as its Enterprise Reporting
Environment. The Stanley BI COE maintains the Business Objects Environment.
C
r
y
s
t
a
l
R
e
p
o
r
t
s
Administration
BI Center of
Excellence
(BICOE)
Business Objects and the BI COE at Stanley
DCS Consulting, Inc.
9048 John Sutherland Lane, Lorton, VA 22079 | P: 703-863-7202 | [email protected] | www.dcsfederal.com
Responsibilities of BI COE Related to Business Objects
Governance & Change Reviews
Technical and Design Reviews
Migrations of Components
Administration and Security
Communications and Announcements
Application (BusinessObjects) Management
Stanley Black & Decker has standardized on Business Objects as its Enterprise Reporting
Environment. The Stanley BI COE maintains the Business Objects Environment.
C
r
y
s
t
a
l
R
e
p
o
r
t
s
Administration
BI Center of
Excellence
(BICOE)
Business Intelligence Responsibilities at Stanley
DCS Consulting, Inc.
9048 John Sutherland Lane, Lorton, VA 22079 | P: 703-863-7202 | [email protected] | www.dcsfederal.com
The BI COE has the primary responsibility for :
- Common Infrastructure and Services
- Enterprise Standards
- Application Administration & Security
- Communications Amongst Teams
- Environment Migrations
- Design & Readiness Reviews
- Governance & Change Reviews
Business Unit Application Development
teams have responsibility for:
- Communications with Users / UAT
- Requirements Analysis
- Application Development
- Resources / Staffing
- Application Maintenance
Page: 13
BI COE – Access and Available Tools
DCS Consulting, Inc.
9048 John Sutherland Lane, Lorton, VA 22079 | P: 703-863-7202 | [email protected] | www.dcsfederal.com
Page: 14
Group
Type of
Access
Available Tools
BI COE
Administrator
Access
Central Management Console (CMC) *
Import Wizard *
Universe Designer
Xcelsius Designer
Crystal Reports Designer
Web Intelligence
InfoView Portal
Application Team Developer Access
Universe Designer
Xcelsius Designer
Crystal Reports Designer
Web Intelligence
InfoView Portal
Business Users End User Access
Reports
Dashboards
InfoView Portal
* As The Central
Management Console (CMC)
and Import Wizard are tools
designed for administration
of Business Objects
environments, only
members of the BI COE have
access to them.
Distributed Application Development at Stanley
DCS Consulting, Inc.
9048 John Sutherland Lane, Lorton, VA 22079 | P: 703-863-7202 | [email protected] | www.dcsfederal.com
Reasons for Distributed Application Development of
Business Intelligence Solutions at Stanley
- Synchronous Business Intelligence Development
- Alignment to Customers and Business Units
- Expanded Knowledge Base
- Appropriate Governance Models
- Shared Use of Technology
Page: 15
BI COE
CDIY
EMEA
IAR
SMS
Corp
SAT
Distributed Development Between BI COE and
Application Team Teams
Benefits of BI COE at Stanley
DCS Consulting, Inc.
9048 John Sutherland Lane, Lorton, VA 22079 | P: 703-863-7202 | [email protected] | www.dcsfederal.com
Adoption of a BI COE at Stanley has enabled:
Shared use of BI/DW technologies
Single point-of-contact for administration
Managed deployments - consistent oversight incorporated into every stage of
development
Increased level of communications amongst application teams
More accurate, consistent and repeatable project estimates
Higher project success rates
Better use and integration with the Stanley Data Warehouse (SDW) and Data
Marts
Improved sharing of knowledge amongst application teams
Decreased risk amongst projects
Consistency in design and technical reviews
Higher confidence in IT department
Page: 16
Questions
DCS Consulting, Inc.
9048 John Sutherland Lane, Lorton, VA 22079 | P: 703-863-7202 | [email protected] | www.dcsfederal.com
Page: 17
DCS Consulting - Contact Us
DCS Consulting, Inc.
9048 John Sutherland Lane, Lorton, VA 22079
703-966-5831
Adam Getz
[email protected]
WWW.DCSFEDERAL.COM
DCS Consulting, Inc.
9048 John Sutherland Lane, Lorton, VA 22079 | P: 703-966-5831 | [email protected] | www.dcsfederal.com
Page: 18
Check out www.bi-insider.com
doc_669871730.pdf