The Implementation of a Solid Foundation for Business Intelligence

1
The Implementation of a Solid Foundation for
Business Intelligence

• Session A9940

Presented by Ron Hamilton, JohnsonDiversey,
Inc. Joe Guerra, Andrews Consulting Group
2
JohnsonDiversey, Inc.

• Headquarters in Sturtevant, WI
• Previously an industrial products and service
  division of S.C. Johnson Son
• Changed name from Johnson Wax Professional to
  JohnsonDiversey in 2002 after acquiring
  DiverseyLever from Unilever
• Two business units
• Industrial Cleaning and Service Division
• Polymer Chemical Division

3
JohnsonDiversey, Inc.

• ERP Systems
• J.D. Edwards OneWorld (Implementations going on
  in Latin America, North America, Japan and Asia
  Pac)
• SAP R3 (Implementations going on in Europe,
  Middle East, Africa)
• Centralized IT data centers and IT functional
  groups (USA and London)
• ETL software DataMirror TransformationServer/
  Informatica, PL/SQL
• BI Software Business Objects 6.17
• Team Sizes ETL(3) BI JDE BI(10) SAP
  R3-BI(5)

4
JohnsonDiversey Challenges to Be Met (1)

• Improved reporting of J.D. Edwards business
  information
• The provided ERP reporting tool did not meet
  requirements
• More timely and accurate information
• Existing BI delivery mechanisms did not meet user
  requirements
• Sales/Finance reporting only (Missing Supply
  Chain)
• Batch updated nightly (Users wanted more up to
  date)
• No Japan reports available
• Support for users in Japan, North America, Latin
  America and Asia-Pacific. (Europe/Middle
  East/Africa running SAP R3)
• Regional implementations of J.D. Edwards had
  separate and distinct as well as common
  requirements

5
JohnsonDiversey Challenges to Be Met (2)

• ERP data from disparate divisions needed to be
  consolidated into a single business intelligence
  solution
• Each region of JohnsonDiversey had its own ERP
  system
• Less dependence on IT for production and ad hoc
  reporting needs
• Business Objects Web Intelligence was selected
  based on its robust features and functions
• Multi-lingual support
• Business Objects English and Japanese language
  support
• Long-term strategic direction for consolidated
  analytical reporting (JDE regions and SAP R3
  regions)
• SAP BW

6
JohnsonDiverseys Implementation Steps (1)

• Selected all 9 RapidDecision data marts
• Inventory, Purchasing, Work Order, Manufacturing,
  GL, AP, AR, Fixed Assets, Sales Order
• Created roll-out plan
• Japan (Sales)
• U.S. (Supply Chain)
• Convert existing FA/GL/AP/AR Sales Order to
  RapidDecision
• Project team established
• Project sponsor
• ETL team lead
• Data trustees (business users)
• Business Objects administrator

7
JohnsonDiverseys Implementation Steps (2)

• Data integration tool installation and setup
• DataMirror Transformation Server
• Data mart implementations
• Standard versions of RapidDecision installed in
  development
• Gap analysis performed and customizations
  implemented
• Business Objects universes implemented
• Added JohnsonDiversey business terminology to
  English versions
• Converted to Japanese language versions (Kanji)
  ????

8
JohnsonDiverseys Implementation Steps (3)

• Training
• Data integration
• Business Objects power user training
• Business Objects user training
• Report creation
• Core reports established on a regional basis
• User acceptance testing
• Performed regionally per mart
• Roll out!

9
Business Intelligence Deliverables

• Installed 9 data marts in U.S. environments
• Production to development warehouse
  (ACG/JohnsonDiversey)
• Production to production warehouse
  (ACG/JohnsonDiversey)
• CRP to development warehouse (JohnsonDiversey)
• Deployed Japanese Sales mart, universe and
  reporting for users
• Deployed U.S. Inventory, Purchasing, Work Order,
  Fixed Assets and General Ledger marts, universes
  and reporting for users
• Completing Accounts Payable, Accounts Receivable
  marts in User Acceptance Test currently
• JDE BI user base increased Jan 2004 (200) Dec
  2004 (600)

10
Business Intelligence Analysis Deliverables

• QUICK WINS for Business
• Vendor and procurement product analysis
• Analysis of volumes by product and timeframe
• Vendor volumes across product lines
• Analysis of volumes for procurement negotiations
• Inventory turn analysis
• Identification of Slow and Quick movers

11
Business Intelligence Analysis Deliverables

• QUICK WINS for my BI Team
• Lower cost of ongoing ETL/BI support
• Standardized data marts better for users and BI
  support
• Quick entry into Supply Chain reporting (Huge
  image builder in company)
• Response time improvements due to design
  aggregations

12
JohnsonDiversey Next Steps

• Feed worldwide corporate data warehouse solution
  (SAP BW) using RapidDecision as a JDE data
  feeder base
• Define and deploy dashboards
• Production deployment of remaining marts,
  universes and reporting
• Japan
• U.S.
• Asia-Pacific
• Monitor for potential upgrade to PeopleSoft (Fall
  of 2005)
• Upgrade to Business Objects 6.5 (Fall of 2005)
• Multiple data providers
• Support for OLEDB
• Supervisor over browser

13
RapidDecision
For most people, BI is charts and graphs
14
Whats Wrong with Most BI Solutions?
The connection between ERP and dashboard doesnt
permit
1
Access to real-time data where appropriate
2
Reporting consolidation
3
Production data archiving
4
Speedy implementation!
15
Data Marts Are the Foundation of BI
Data Marts
All business intelligence solutions use data marts
16
Only RapidDecision Uses a Data Warehouse
Source Applications
Data Warehouse
Repository
ERP
Data Marts
Only RapidDecision places a data
warehouse between ERP systems and the data marts
17
Key Advantages of the Data Warehouse
Source Applications
Data Warehouse
Repository
ERP
Data Marts

• The data warehouse gives RapidDecision several
  key advantages
• Warehouse only needs and receives new data from
  the ERP systems, which increases update speed and
  decreases system load
• RapidDecision is available 24/7
• Data from other sources, in addition to the
  enterprise ERP systems, can be maintained in the
  warehouse
• Storage of as many years of information as
  needed, not just what can be refreshed overnight

18
Without a Data Warehouse
Source Applications
ERP
Data Marts
Information must flow directly from ERP systems
to the data marts
19
Without a Data Warehouse
Source Applications
ERP
Data Marts
Data marts are only refreshed on a periodic
basis.
There is no access to right-time information.
20
Without a Data Warehouse
Source Applications
ERP
!
Data Marts
Refreshes take a long time and stress network
resources
21
RapidDecision Supports Your Dashboard
Application
WWW
Suppliers
Employees
Customers
Full integration with any BI user interface that
can be accessed from your PC
22
RapidDecision Can Be Up and Running in Just 5
Days!
Fast and affordable installation in just 5
days per data mart guaranteed
23
RapidDecisions Unique ArchitectureSolves BI
Limitations
24
Andrews Consulting Group

• An IT consulting firm that helps businesses
  achieve their goals through technology
• Founded in 1984
• Approximately 75 employees
• Offices in Connecticut and New York City
• Oracle Tier One Business Partner
• Platinum Business Objects Sales, Service, and
  Training Partner
• Microsoft Gold Certified Partner