Enterprise Data Management

(1)

Enterprise Data Management

Master Data Governance and Management

Ensuring Intelligence in Business Intelligence

Andreas Hofer

SAP Enterprise Architect

NetWeaver Solution Consulting SAP Canada

(2)

Agenda

1. Master Data Governance and Management 10:15 – 11:45

1.1. Overview

1.2. Demo

1.3. References

2. Lunch/Networking 11:45 – 1:00

3. Ensuring Intelligence in Business Intelligence 1:00 – 2:15

3.1. Overview

3.2. Demo

(3)

Data Explosion

(4)

Open & Agnostic

Open apps & BI, "agnostic" to underlying technology Complete , Integrated Stack Most complete, integrated stack Hyperion, Interlace, diverse apps Essbase, nQuire, BIEE Cognos CPM Cognos Proclarity Performance Point Excel Function/industry specific vendors SAS, Microstrategy, InfoBuilders, Informatica EPM & GRC Data Warehouse Business Intelligence Enterprise Applications Oracle DW Oracle, PSFT, Siebel DB2 DW SQL Server DW Dynamics BW, BIA SAP Applications Teradata, Netezza, MySQL, Sybase NetSuite Independent Vendors Business Objects + SAP Business Objects + SAP

(5)

We are the Market Leader:

What #1 Brings

Forrester Wave™: Enterprise Extract, Transform, And Load (ETL) Tools, Q2 2007

ETL Tools

In

formation Qualit

y

Forrester Wave™: Business Intelligence For Analytic Reporting, Q1 2006 2 Feb 2006

BI Platfo

rms

(6)

SAP NetWeaver Portal SAP NetWeaver Portal

SAP NetWeaver

Business Warehouse

SAP NetWeaver

Business Warehouse

SAP NetWeaver MDM SAP NetWeaver MDM ERP Financials Operations Human Resources Corporate Services ERP Financials Operations Human Resources Corporate Services CRM CRM SCMSCM SRM SRM PLMPLM Any Portal, Any Destination Any Portal, Any Destination

SAP BusinessObjects Enterprise SAP BusinessObjects Enterprise Crystal Reports Crystal Reports Web Intelligence Voyager Web Intelligence

Voyager XcelsiusXcelsius

SAP NetWeaver BW Accelerator

SAP BusinessObjects Data Services SAP BusinessObjects Data Services Data Quality Data Quality Data Integrator Data Integrator BEx BEx Visual Composer Visual Composer D a ta Founda tion Inf o rmation Access

The New Intelligence Platform

Information Management

SAP Business Suite 3rd_{-Party Databases and Applications}

(7)

SAP NetWeaver MDM

Delivers an integrated way of managing master data

Compose cross application

processes in SOA with consistent master data

Infinitely configurable schema options

Support consolidation, harmonization, central mgmt

Pre-packaged IT and business scenarios

500+ customers

(8)

Benefits:

Complex product and relationship management

Print/web publishing including layout and production

GEAR Parts

1038-GID

Example: Product information is

consolidated and enriched and published internally or externally

Rich Product Content Management

One view of product information anytime anywhere

(9)

Fleet Inc

123 4th _Street. Chicago, IL 60611

Identify and categorize suppliers

Utilize external validation such as D & B’s Duns Number

Leverage one view of suppliers to gain supplier visibility and negotiate better procurement contracts

Supplier/Vendor Data Integration

One view of Vendor information anytime anywhere

(10)

Jane Smith

4418 N. Str. Chicago, IL 60611

Extensive matching framework

Provides web services to customer data access

SAP & Non-SAP integration

Customer Data Integration

One view of customer information anytime anywhere

(11)

Understand your most profitable

products, best customers and

cheapest/reliable vendors

Gain insights by integrating

transactional data from

heterogeneous systems with

master data for analysis

Improved Business Intelligence

Deliver unique insights with an integrated platform

(12)

Data Pool

Global Data Synchronization

Leverage master data consistency across the supply chain

Reduce supply chain costs

with comprehensive

solution for consumer

product companies

Certified to publish

enriched product data to

1Sync data pools

(13)

MDM

SRM

SRM/MDM Catalogue

Manage supplier catalogues seamlessly in the procurement

process

Supplier Catalogues

Load of supplier catalogues into

SRM/MDM catalogue

Quick data access by

in-memory enabled parametric

search

Integration into procurement

process within SRM and ERP

Procurement

Manage

(14)

R/3 R/3 R/3 R/3

MDM

Central creation and replication

Data Access, Quality and Maintenance

Use state-of-the-art master data management capabilities

Load data from R/3 master data

server (ongoing/periodically)

Quick data access with

in-memory enabled parametric

search

Leverage MDM capabilities to

raise master data quality

De-duplication

Validation

(15)

MDM

Load data from new systems

Match new data to internal,

already consolidated data

Quick access to consolidated

information

Provide key mapping information

to subsequent

migration tools

Acquisition

acq1000 Æ i4711

acq1001 Æ i0815

Merger & Acquisitions (System Consolidation)

Integrate the heterogeneous world while raising data quality

Create

(16)

Central Business Partner Creation

(17)

SAP MDM Data Manager

(18)

Validation from our customer and partners

“

Ericson has used MDM to accurately track their

_{global spend reducing the number of vendors by 35%}

“

Rubbermaid has used MDM to create a centralized

_{store of comprehensive product information}

“

Whirlpool used MDM to significantly reduce the time

_{required to integrate their merger of Maytag}

(19)

SAP NetWeaver MDM – Selected Customers

(20)

BusinessObjects Data Services

One Runtime Architecture One Development User Interface One Metadata Repository

One Administration Environment

Data Services

Improve Improve Deliver Deliver Transform Transform Access Access Runtime Architecture Metadata Repository Development User Interface

Administration and Connectors

Runtime Architecture Metadata Repository Development User Interface Data Integrator XI R2 Data Quality XI R2

(21)

(22)

Data Quality Address Cleanse

(23)

SAP NetWeaver

Business Warehouse

SAP NetWeaver

Business Warehouse

SAP NetWeaver MDM SAP NetWeaver MDM ERP Financials Operations Human Resources Corporate Services ERP Financials Operations Human Resources Corporate Services CRM CRM SCMSCM SRM SRM PLMPLM Any Portal, Any Destination Any Portal, Any Destination

HALF WAY POINT RECAP

(5 Minute break)

(24)

Data Insight

(25)

Data Quality and Data Services

(26)

Data Quality validation

(27)

Metadata Management

(28)

Metadata Management continued

(29)

It’s about Our Customers’ Business Data

The Challenge Of Data Migration

Traditional Steps SAP LEGACY SYSTEM(S)

?

Provision of data

“

Let’s cross the fingers’ and hope it loads…

It is crucial to identify the right partner with the right expertise for your data migration project.

But attention:

Data migration is far from easy.

Lack of experience

Migration project plan is unrealistic

Data quality issues / lack of confidence in the data

You need to extend the consultants time of the SAP project

Why?

More than 80% of data migration projects run over time and/or over budget. Cost overruns average 30%. Time overruns average 41%.

Bloor, 2007

80% of organizations… will underestimate the costs related to the data acquisition tasks by an average of 50 percent”

Gartner

Analysts

(30)

SAP DATA MIGRATION SERVICES

Agility and Control

1 ANALYSIS 2 EXTRACT 5 LOAD 6 4 VALIDATE

Governance and Visualisation

SAP® DATA MIGRATION SERVICES Methodology Templates Tools Expertise

SAP Data Migration gives You what You need: A Solution You can Trust. Standardized and Proven Approach for End-to-End Data Migration

SAP Data Migration Services consist of a framework, templates, methodology, tools and expertise to analyse, extract, cleanse, validate, upload and reconcile legacy data into a SAP environment.

SAP Data Migration Services provide a mature

information management infrastructure and enables data governance best practices that live on after the project.

RECONCILE

Data Migration Framework

3

(31)

Technology that works hand-in-hand

A Complete End-to-End Solution for data migration

SAP DATA MIGRATION 1 ANALYSIS 2 EXTRACT CLEAN 5 LOAD 6 RECONCILE VALIDATE 4 BusinessObjects Composer (Supports the design of the data migration job; also known as ETL mapping)

BusinessObjects Data Insight (Supports the profiling of your source data to identify data quality issues)

BusinessObjects Data Services (Supports the accessing, cleansing, transforming, and delivering of your data)

Governance, Reporting & Dasboarding: BusinessObjects Xcelsius and BusinessObjects Enterprise (Supports

SAP Migration and Services and Technology

Now You have the Technology You can Trust to support you in ongoing data governance and data quality.

Did you know?

The Data Warehousing Institute (TDWI) estimates that poor quality customer data costs U.S. businesses a staggering $611 billion a year in postage,

printing, and staff overhead. Frighteningly, the real cost of poor quality data is much higher.

Market leading data quality capabilities

Prebuilt SAP certified connectors for SAP ERP

Best in class ease of use to accelerate your project delivery

(32)

#1 Ease of Use

Ease-of-Use

IBM Information Server Group 1 Software / Data Flow Oracle Data Integrator (Synopsis) Information PowerCenter DT/Studio - Embarcadero Pervasive Business Integrator Transformation Manager

BusinessObjects – Data Integrator

SAS Data Integration Studio Cognos Data Manager Information Builders – Data Migrator Microsoft Integration Services Oracle Warehouse Builder IBM DB2 Datawarehouse Edition Talend Open Studio IKAN – ETL4ALL Pentaho Data Integration (Kettle)

Summer 2005 Difference with Spring 2008

(33)

Market Leading Products

SAP Business Objects is a Leader in DQ and DI markets

LEADER

(34)

Agenda

1. Master Data Governance and Management 10:15 – 11:45

1.1. Overview

1.2. Demo

1.3. References

2. Lunch/Networking 11:45 – 1:00

3. Ensuring Intelligence in Business Intelligence 1:00 – 2:15

3.1. Overview

3.2. Demo

(35)

Lunch and

Networking

(36)

Agenda

1. Master Data Governance and Management 10:15 – 11:45

1.1. Overview

1.2. Demo

1.3. References

2. Lunch/Networking 11:45 – 1:00

3. Ensuring Intelligence in Business Intelligence 1:00 – 2:15

3.1. Overview

3.2. Demo

(37)

(38)

SAP NetWeaver

Business Warehouse

SAP NetWeaver

Business Warehouse

SAP NetWeaver MDM SAP NetWeaver MDM _FinancialsERP Operations Human Resources Corporate Services ERP Financials Operations Human Resources Corporate Services CRM CRM SCMSCM SRM SRM PLMPLM Any Portal, Any Destination Any Portal, Any Destination

The New Intelligence Platform

Business Intelligence

3rd_{-Party Databases and Applications}

(39)

Fast & Flexible with SAP NetWeaver BW

Accelerator

Improvement 2006 1990

2

16 Addressable Memory

250 x

5

MB/$

0.02

MB/$ Memory

143

x

7.15

MIPS/$

0.05

MIPS/$ CPU

130

MBPS

5

MBPS Disk Transfer

25 x

100 x

10

Gbs

100

Mbs Network Speed

2

64

₂

48

_x

10x faster queries

10x less expensive to

acquire

20x less expensive to

operate

(40)

Product Directions for BI Solutions

Richest Offering for All Business Users

BEx Analyzer

BEx Analyzer _VoyagerVoyager

Web App Designer

(41)

Product Directions for BI Solutions

SAP BusinessObjects BI Solutions

Predictive Predictive Web Intelligence Web Intelligence Crystal Reports Crystal Reports Xcelsius Xcelsius Web App Designer

Web App Designer

Report Designer

Pioneer (OLAP Analysis) Pioneer (OLAP Analysis)

(42)

BW Accelerator

(43)

Polestar

(44)

SAP NetWeaver

Business Warehouse

SAP NetWeaver

Business Warehouse

SAP NetWeaver MDM SAP NetWeaver MDM _FinancialsERP Operations Human Resources Corporate Services ERP Financials Operations Human Resources Corporate Services CRM CRM SCMSCM SRM SRM PLMPLM Any Portal, Any Destination Any Portal, Any Destination

HALF WAY POINT RECAP

(5 Minute break)

3rd_{-Party Databases and Applications}

(45)

Enterprise Reporting ÆCrystal Reports 2008

A powerful, dynamic, actionable reporting

solution

Stunning report visualizations

What-if scenario modeling

Integrated operational reporting

Plus everything you expect, and more,

from the de facto standard for reporting

trusted by millions of users and billions of

consumers around the world

(46)

Ad-hoc Analysis Æ Web Intelligence XI 3.0

Offline rich client

Multilingual universes

Change data highlighting

Offline data provider

+ many ease of use and

functional enhancements

(47)

Dashboards Æ Xcelsius Enterprise XI 3.0

User experience improvements

Embedded Excel

Design flexibility

New components

Real time dashboards

(48)

Office tools and BI Æ Live Office

Get self-service data access from Office

Word

PowerPoint

Excel

End time-wasting debates over data

accuracy

Instant refreshing and refiltering

All formatting and calculations are retained

Securely share documents

BusinessObjects Enterprise

Corporate portals

Market-leading Office integration

(49)

BusinessObjects Text Analysis

Extract and understand concepts, people, organizations, places, and more — in 30

different languages and from 200+ document types

Automatically categorize and classify documents

(50)

(51)

How Mobile BI Can Add Value

Increased Business Intelligence adoption to more BI users

Shortened sales cycles

Faster, more accurate account services

Increased customer satisfaction

Typical Requirements Met

Reuse of existing BI content for mobile employees

Provide location-based mobile BI solutions

Increase business user self-sufficiency—no IT involvement or

training required

Secure data delivery using the BI platform security model

SAP Connectivity

Via Business Objects Enterprise Universes that can leverage

SAP NW BI data via the OLAP BAPI

BusinessObjects Mobile

(52)

OLAP Analysis:

BusinessObjects Voyager

Voyager is a web-based OLAP client with an advanced & highly intuitive user interface based on WEB 2.0 (Ajax) technology

How Voyager Can Add Value

Multiple connections to multiple OLAP Servers(SAP NetWeaver EDW, MSAS, Essbase, Oracle, IBM DB2, …)

Multiple pages in a workspace

Advanced charting engine

Standard OLAP navigation

Business calculations: % diff, % cont, variance, …

Time based calculations: Prior Period, YTD, QTD, MA…

Filter, sort, ranking – top / bottom, by value by %

Typical Requirements Met

Business/Technical/Financial analysts’ requirements for OLAP data exploration and review

Open data Access

Access and analyze multiple OLAP sources in one workspace

Multiple views of the same OLAP cube in one workspace

Tight integration with MS PowerPoint & Word

What’s New

(53)

Xcelsius BI Widgets

Xcelsius BI Widgets simplify access to BI and

increase productivity by having key information

available at users’ fingertips

Expand and accelerate BI usage—leverage

existing data sources, reports, queries, alerts and

dashboards with a simple drag and drop

interface—no training or IT required

Provide the confidence that users will always have

access to the most up-to-date information available

Deploy BI dashboards and visualizations

(54)

Astra Zeneca

Accelerated drug development

Provide competitive advantage,

launching products quickly and

securing early brand leadership

and higher revenue

Business Objects, an SAP

company, has enabled

AstraZeneca to improve

project management, cost

control, and resource

utilization and is helping to

achieve competitive

research and development

timescales.

Provide complete visibility of R&D

information across the world

Help the company improve project

scheduling, budgeting, and

(55)

Nokia

Gained market share from competitor

Reacted quickly to supply issue

unlike its competitor, who

suffered a drastic fall in

revenue growth

In March 2000, lightning

caused a fire at a Philips

semiconductor plant which was

a sole-source supplier of chips

used in both Nokia’s and

Ericsson’s handsets

Nokia proactively monitored

supply chain risks and key

indicators across supplier

plants

(56)

Validation From Our Customers And Partners

“With XI 3.0, we can take data and information that currently exists in silos and integrate it in one central repository. Providing access to more information sources enables our users to drive their own comprehensive reporting, answer their own questions, and ultimately make better decisions.”

“With XI 3.0, we can not only intelligently access information from various third party systems, but also leverage the data internally to provide more immediate, contextual insight that increases the quality and timeliness of our decision-making processes.”

“Our ultimate goal is to make Business Objects transparent throughout the

organization, with BI embedded within all applications and business processes and accessible by all employees, even those who have not traditionally used BI.”

“With the new features in XI 3.0, we can address more of the access preferences that our users want. With extended access to information, managers and executives anywhere can gain insight into key operational metrics at any time.”

(57)

Thank you!

Andreas Hofer

Enterprise Architect

SAP Canada Inc.

4120 Yonge Street, Suite 600 Toronto, Ontario Canada M2P 2B8

(58)

(59)

(60)

Enterprise Data Management