Knowledge Management Program Overview

1
Knowledge Management Program Overview
2
Agenda

• About Corporate Express
• Knowledge Management Program Mission
• Architectural Overview
• Technical Overview
• Current / Future Projects
• Questions

3
About Corporate Express

• 4.5 Billion in revenue
• Operating in 11 countries
• 1 of 10 companies ever to grow from 0 to 3
  Billion in 10 years.
• 28,000 Employees worldwide
• 600 Employees at Corporate Headquarters (350 in
  the IS department)
• We are the largest player in a 400 Billion
  industry with about 1.5 of the market. This
  fragmentation means there is lots of room for
  growth.

4
Knowledge Management Program Mission
Enable achievement of business goals by
accumulating information, creating knowledge, and
taking the right actions.
Business Goals
Information
Action
Knowledge

• Set and Achieve Goals
• Corporate objectives and/or metrics
• Process metrics
• Department metrics
• Individual metrics (KPIs)
• Customer and Supplier needs

• Accumulate Information
• Capture - any format, from any source
• Store - current and history
• Integrate within CEI business context
• Consistent meaning and usage
• Integration of lines of business
• Catalog and describe

• Take Action
• Identify opportunities and potential
• Model impacts and alternatives
• Design changes Set targets
• Implement improvements within the business
• Monitor progress toward goals

• Create Knowledge
• Package, present and deliver information
• Access and analyze information
• Provide timely, relevant, focused results
• Synthesize information (trends, key factors ...)
• Establish linkages and associations

5
Why is Data Warehouse Important?

• Data model is business-oriented
• Data is summarized and aggregated
• Integrates data from different sources
• Facilitates Decision Support and ad hoc analysis
• Ensures consistent definition of elements
• Reduces impact on production OLTP

6
Whats the difference??
Operational System (OLTP)
Data Warehouse

• Organized for sharing
• Snap shot
• Historical data
• Read only (nightly additions of data)
• Structured for drill-up/down, slice/dice
• Adhoc, Analytical Queries
• Cross-functional

• Transactional process
• Real-time (now)
• Current data only
• Update Intensive
• Structured for processing
• Standard, Repeatable Inquiries
• Departmental

7
Data Warehouse Sourcing Process
TSOHD_ SO_ HEADER
Oracle Trigger
Occurs real-time in OLTP database
InVision Database
Changed Data Table
Base Table Load Program
Data Warehouse Database
Base Table
Sales Order
Occurs nightly in the Data Warehouse Database
Collection Table Load Program
Rgstrd Sales Event Aggregate
Collection table
8
Data Warehouse Sourcing Process
9
Data Warehouse Sourcing Process
10
Architectural Overview
Sources of Unstructured Data
Transaction Systems
ISIS
Office Products Systems
CEDS Systems
Other Systems
Documents
Training Modules
Reports
Multi-media
Other Forms of Unstructured Data
Characterization Association
Integration Transformation
Corporate Information Library
Warehouse of Structured Data
Warehouse of Unstructured Data
Catalog of Information Objects
Security
Profiles of Person Objects
InSight
Cognos PowerPlay
Reporting Architecture
Standard Operating Guide
Other Information Access Applications
Other CE Internet Applications

Information Consumer
11
Technical Overview
Sources of Unstructured Data
Transaction Systems
Tuxedo
Documentum
Visual Basic
CBT Modules
Reports
Many Others
Oracle
Custom C, Pro C, PL,SQL
Custom PL/SQL, Pro C, SQR, Java
Corporate Information Library
Custom OO Development - Currently In Early
Design Stage
Oracle
Oracle
Security

• Behind the Scenes
• Oracle 7.3
• Oracle Web Application Server 3.0
• Tuxedo 10.01
• Sun Solaris 2.5
• HP UNIX 10.10
• Lots of Leading Edge Development

Custom OO Development - Currently In Early
Design Stage
InSight
Cognos Impromptu PowerPlay
Custom C, Pro C, and PL/SQL
Custom HTML, JavaScript, PL/SQL, Java
Custom HTML, JavaScript, PL/SQL, Java

Standard Web Browser
12
Current / Future Projects
13
Presentation Demos

• Steve Meyer
• Will present a demo on Insight and the
  capabilities that the product provides and will
  provide end users.
• Amy Stuemky
• Will present a demo on Cognos PowerPlay.
• The demo will show the analytical capabilities of
  the tool and how a user can benefit from it.

14
QuestionsComments?