Transcript Cognos Enterprise Business Intelligence for e

What is
Competitive/Business
Intelligence?
Reach - Deploying Information to the Masses
Q: What landmark device was invented in 1452?
A: The Printing Press
(Johannes Gutenberg)
What is CI/BI?
• CI/BI has two main dimensions:
– Richness
– Reach
Richness describes the usefulness of information
Reach describes the availability of information
Richness = Information Intelligence
• Useful information is information that allows one to make
decisions!
Data
• Disparate
facts
Information
• Data with
meaning (who,
what, where,
when)
Knowledge (CI/BI)
• Information
that affords
action (how,
why)
Reach = Information Availability
• Useful information is information that is available to
people making decisions!
•
CI/BI tools bridge the gap between users
and knowledge . . . delivering richness &
reach
•
Puts power in the hands of users
•
IT department no longer gatekeeper to
information
CI/BI Philosophy
“Give one a fish and they will eat
for a day. Teach one to fish
and they will eat for a lifetime!”
- Chinese Proverb
CI/BI Defined
•
CI/BI is a Process:
– that identifies the KPIs driving your business
– is delivered through an intuitive analytical interface
– is readily available to business users on a consistent and
timely basis
– information adapts to changing business needs
The Data Warehouse (DW)
•
The foundation for enterprise CI/BI
•
Provides a single, clean,
standardized repository of enterprise
information
Data Marts
•
Separate environment from
Transactional Systems
Data Warehouse
•
Specially designed for CI/BI reporting
& analysis
ETL – Extraction, Transformation, & Loading
“The DW building tool”
DBMS
ERP
Flat Files
SOURCE
EXTRACTORS
ETL Tool
DATA
ASSETS
SHARED
DIMENSIONS
COORDINATED
DATA MARTS
WITHIN DATA WAREHOUSE
Enterprise Reporting
• Allows reporting across all areas of the enterprise
• Allows reporting across multiple systems and platforms
• Allows transaction-level reporting
• Enables operational-level decision-making
Enterprise
Reporting
OLAP (On-Line Analytical Processing)
(that “cube” thing)
•
Multidimensional Analysis (OLAP)
– Easy, fast access to KPIs across one or many dimensions
– View your organization’s information from endless perspectives
– An information delivery framework, not “canned” reports
– Designed for self-service by information users
The OLAP Cube
• Enterprise data organized into business
terms & dimensions
• Presents information in top-down format
• Ideally focused on one subject area
• Optimized for fast navigation
• Use to look at information from endless perspectives
Slice & Dice Your Data
with OLAP!
Any
Database
Data
Warehouse
EXCEL
Spreadsheets
Industry Reports/
Secondary Data
Data Mining
(the “unasked” question)
•
Discover hidden
trends and patterns
in your data
•
Identify unsuspected
correlation to target
results
•
Supports predictive
modeling and “what
if” analysis
•
Supports the LEAST
structured questions
& decisions
Visualizations
(a picture is worth a thousand words)
Visualization
• Highest level view of information
• “Dashboard” of multiple data sources
• Geographic Information Systems (GIS)
Benefits
• Fast intuitive knowledge transfer of
complex data
• Pattern and Trend Analysis
• Consolidated view of cross functional
KPI’s
Corporate Performance Management (CPM)
 “Scorecard” of highly visual metrics
 Use cubes, queries or spreadsheets as data
sources
 Drill-Thru to underlying details
 Management by Objectives (MBO)
 Enterprise-wide monitoring & management of KPIs
Information Distribution
Extranet /
Portals
(Customers,
Suppliers,
Partners)
Third Parties
BI (Business Intelligence)
Enterprise Architecture
CPM
(Corp.
Performance
Management)
ETL (Extraction,
Transformation, &
Loading)
Data
Mining
OLAP
Transactional
Systems
Tactical
Databases
Web-Based
Transactions
Strategic
Transactional
GIS
Data Marts
Data Warehouse
Enterprise
Reporting
Operational
(ex. ERPs)
Global Customers using CI/BI
Heinz
Avon
Marriott
PECO
Dreyfus Union Bank
SmithKline
AT&T
James River American Express
OSRAM SYLVANIA
Hamilton Beech
French Navy
United Airlines
PTT Holland
Analog Devices
Paramount Pictures
Proctor Silex
NASA
EMI Records
Heineken
Pepsi
Omnicom
Allied Signal
Land Rover
Estee Lauder
All America
L.A. Times
Consumers Gas
US Department of Energy
Chrysler Engineering
Telia Sweden
US Post Office
Vanguard
Chevron
Siemens Corporation
Procter & Gamble
EMI Records
Abbot Labs
York International
Cisco Systems
Host Marriott
Boston Scientific
Southern California Edison
Johnson & Johnson
MCI
Air Products
Pittsburgh Customers using CI/BI
Marconi
Ariba (formerly FreeMarkets)
US Steel
Robert Morris University
Westinghouse
Peak Technical
Butler Health System
Kane Magnetics
EDMC
GNC
CPS
Daily Juice
Crown Castle USA
PPG Industries
Duquesne Light
Bush Industries
Hillman Company
Eat’n Park
Union Switch & Signal
Copperweld
National Draeger
ITXM
Lord Corporation
Highmark Blue Cross
Sunrise Medical (DeVilbiss)
Cutler-Hammer
American Textile
Penn State University
Federated Investors
APTECH
Blair Corporation
Starwood Hotels
Heinz USA
Mine Safety Appliance
Allegheny Power
American Eagle Outfitters
SAE International
Giant Eagle
INRANGE
Management Science Associates
Carbide Graphite
Robicon
UPMC
Anderson Equipment
PNC Bank
FNB Corp
Thank You!