o prezentare
DESCRIPTION
O prezentareTRANSCRIPT
Sue HaySr Product Manager, Information Management28-January-2009
SAP® BusinessObjects™Data Quality Management, versionfor SAP Solutions, XI 3.1version 12.1.0
Behind Every Business and IT Initiative …Reality
Challenge #1:
Where is thedata?
Challenge #1:
Where is thedata?
Challenge #2:
Why are thereerrors in the data?
Challenge #2:
Why are thereerrors in the data?
Challenge #3:
How current is thisinformation?
Challenge #3:
How current is thisinformation?
Challenge #4:
Where did thisinformation come from?
Challenge #4:
Where did thisinformation come from?
Disparate Data
DisparateBusinesses
DisparateApplications
?
© SAP 2009 / Page 2
TDWI Data Quality Survey
Sources of Data Quality Problems
12%
25%
26%
34%
46%
48%
53%
76%
Other
Data entry by customers
System errors
External data
Mixed expectations by users
Data migration or conversion projects
Changes to root/source systems
Data entry by employees
Based on 632 respondents who could select multiple answers.The Data Warehousing Institute, March 2007.
© SAP 2009 / Page 3
Data Quality And The Information Supply Chain
Where Data is Currently Cleaned
16%
37%
48%
60%
63%
Do nothing
Prevent defects atthe source
Identify errors inreports
Fix downstream
Fix at the source
Information Supply Chain
MktgCmpgn
WebLog-Ins ODS Call
CenterCRM/CDI
ReportsBIEPM
© SAP 2009 / Page 4
The Cost of Poor Quality Data
Symptoms Impact
Sales /Marketing
•Low customer satisfaction•Many address change requests•No trust / agreement in reporting
•Customer churn•Excessive mailing expense•Opportunity cost of lost sales
Finance•Budgets take forever to get “right”•Big budget/actual discrepancies•No trust / agreement in reporting
•Budget overruns•Out-of-control expenses•Fines and possible jail time
SupplyChain
•“Out of Stock” situations•Poor-quality products•No trust / agreement in reporting
•Reduced top-line revenue•Excessive shipping expense
IT•Large IT projects fail•No usage of applications•No trust / agreement in reporting
•IT investments wasted•IT productivity remains low
© SAP 2009 / Page 5
How Does Data Quality Fit within the Enterprise?
© SAP 2009 / Page 6
SAP Business Objects is a Market Leader InData Quality
Challengers Leaders
Niche players Visionaries
Completeness of vision
Abili
ty to
exe
cute Market Leader
Magic Quadrant for Data Quality ToolsSource: Gartner, June 2008
© SAP 2009 / Page 7
Copyright © 2006 Business Objects S.A. All rights reserved.
Business Objects’ Cleansing andEnhancement Capabilities for Party Data:
Multi-line Input record Output record
Data parsed into individualcomponents
Maggie.kline@future_electronics.comMargaret Smith-Kline phdFUTURE Electronics5/23/03101 6th aveManhattan ny10012001124367
Salutation: Ms.First name: MargaretLast name: Smith-KlinePostname: Ph. D.Match standards: Maggie, Peg, PeggyGender: Strong FemaleCompany name: Future ElectronicsAddress 1: 101 Avenue of the AmericasCity: New YorkState: NYZIP+4: 10013-1933Email: maggie.kline@future_electronics.comSSN: 001-12-4367Date: May 23, 2003
Casing andstandardization
Corrections
Enhancements
© SAP 2009 / Page 8
© SAP 2008 / Page 9
Ms Margaret Smith-Kline Ph.D.Future Electronics* 101 Avenue of the AmericasNew York NY 10013-1933maggie.kline@future_electronics.comMay 23, 2003; E3 Stamping Machine
Name: Ms. Margaret Smith-Kline Ph.D.Company name: Future Electronics Co. LLCSSN: 001-12-4367Address: 101 Avenue of the AmericasCity, State, ZIP: New York, NY 10013-1933Latitude: 40.722970Longitude: -74.005035Phone: (222) 922-9922Email: maggie.kline@future_electronics.com
Purchase history:5/23/03; E3 Stamper, $1,300,000
10/21/04; A1 Injector, $520,0006/30/05; C2 Fabricator, $23,000,000
Input record variations
Complete master record
* Maggie SmithFuture Electronics Co. LLC101 6th Ave.Manhattan, NY 10012maggie.kline@future_electronics.com001-12-436730-6-2005; Fabrication Facility class C
Ms. Peg KlineFuture Elect. Co.101 6th Ave.* New York NY 10013001-12-4367(222) 922-992210/21/04; Victory Injection Molder
Clean, Consistent Data sets the stage toIdentify Potential Duplicate Records
Why do Customers purchase Data QualityManagement for SAP Solutions?
DQ Mgmt for SAP provides a prepackaged native integration of dataquality best practices within the SAP environment
Enforces data discipline directly within SAP CRM or ERP systems– No extracts for external processing required
Virtually undetectable presence that provides:– Global address correction and standardization– Comprehensive duplicate detection– Convenient record searching
Faster time to ROIDelivers proven results
Automatic cleansing and matching increases efficiency and ensures there isconsistency across the enterprise. A single accurate 360o view of each customer,vendor, or business partner supports all business processes.
© SAP 2009 / Page 10
Data Quality Management provides ImmediateResults
Data Cleansing enhances productivityParsing corrects misfielded data – enables better matching – ensuresstandardizationEntry is Cased – no need to retype / correctAddress reference data is regularly updated – for 234+ countries
User is Prompted with Address AlternativesInteractive drill-downs prompt the user, when conflicting possibilities exist at entry
Duplicate Checks and Fuzzy Matching ensures integrityPrevent duplicates during data entryFuzzy matching allows for variances in data entry
© SAP 2009 / Page 11
Data Enhancement and Duplicate DetectionExtends Value
Elements are completed for the UserMinimal address data is entered – the rest is populated
Eliminates lost deliveries or returned mailSaves transportation and postage costsDelivery Point Validation (option) enables sure delivery
Opportunity for Data EnrichmentGeoCodes (option) returned with latitude/longitude values, etc.
Identify relationships between records, result codes are appliedsupporting analysis tasksSignificantly reduces manual research time to identify potential duplicatesMetrics are available for analysis
© SAP 2009 / Page 12
Where does Data Quality Management livewithin SAP?....
SAP User Interfaces retain native look and feelAll cleansing and matching is invoked ‘behind the scenes’
SAP CRM 2007– New Web Clients: Real-Time Data Entry
– Interaction Center Web Client– CRM Web Client
– SAP GUI: Back-Office Batch Processing
SAP ECC 6– SAP GUI: Real-Time and Batch Processing
SAP CRM 5, ECC 5, R/3 4.7– SAP GUI: Real-Time and Batch Processing
Data Services XI 3 is the Central Platform for Data QualityData Quality Management Premium XI 3.x
© SAP 2009 / Page 13
SA
P C
lient Interfaces
How does Data Quality Management workwith SAP?
Business
Address
Services
Gatew
ay
Application Server
/FLDQ/
SAPDB
SAP CRM or ECC
RFCServer(s)
RFC2
RFC3
RFC1
DataServices
XI 3.1Data QualityManagement
CentralRules
Repository
PostalValidationRef Data
Our Data Cleansing (PV) and Matching (DES) works within SAP’s User Interfaces via BAS
BO
BJ B
AdIs
for PV
+ DE
S
Let’s see some software!
Page 16
*MNC = multinational corporation
What Type of Data is Most Problematic?
Data types that are most susceptible to data quality problems:
Customer data 74%Product data 43%Financial data 36%Sales contact data 27%Data from ERP systems 25%Employee data 16%International data in a MNC* 12%Other : 10%
Unlock the Hidden Meaning within your Data!
CustomersHow to up sell the most profitable customersHow to retain the best customers
VendorsReducing excess inventory expensesLeverage economies of scale for purchasingdiscounts
Business IssuesReducing time it takes accounting to closebooksIncreasing the accuracy of tax jurisdictionassignment
SLIDE 17
Data Quality Management, version for SAPSolutions…
Provides an out-of-the-box data quality solution for enterprise softwareimplementations of SAP CRM and SAP ERP.
Brings data quality capabilities to SAP CRM and ERP on your terms.Native look & feel.
Accelerated deployments quickly add value to SAP enterprise applicationinvestments.
Data is accurate from the point of entry, preventing downstream issues andefforts to resolve.High confidence in source data translates into high confidence in reportcontents and analytics.
© SAP 2009 / Page 18
© SAP 2009 / Page 19
Thank you!
For Additional Information…
Data Quality Management Solutions:http://www.sap.com/usa/solutions/sapbusinessobjects/large/intelligenceplatform/im/data-quality-management/dqm/index.epx
SAP Community Network: https://www.sdn.sap.com/irj/boc/im
© SAP 2009 / Page 21
Copyright 2009 SAP AGAll Rights Reserved
No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP AG. The information contained hereinmay be changed without prior notice.
Some software products marketed by SAP AG and its distributors contain proprietary software components of other software vendors.
Microsoft, Windows, Excel, Outlook, and PowerPoint are registered trademarks of Microsoft Corporation.
IBM, DB2, DB2 Universal Database, System i, System i5, System p, System p5, System x, System z, System z10, System z9, z10, z9, iSeries, pSeries, xSeries, zSeries,eServer, z/VM, z/OS, i5/OS, S/390, OS/390, OS/400, AS/400, S/390 Parallel Enterprise Server, PowerVM, Power Architecture, POWER6+, POWER6, POWER5+,POWER5, POWER, OpenPower, PowerPC, BatchPipes, BladeCenter, System Storage, GPFS, HACMP, RETAIN, DB2 Connect, RACF, Redbooks, OS/2, Parallel Sysplex,MVS/ESA, AIX, Intelligent Miner, WebSphere, Netfinity, Tivoli and Informix are trademarks or registered trademarks of IBM Corporation.
Linux is the registered trademark of Linus Torvalds in the U.S. and other countries.
Adobe, the Adobe logo, Acrobat, PostScript, and Reader are either trademarks or registered trademarks of Adobe Systems Incorporated in the United States and/or othercountries.
Oracle is a registered trademark of Oracle Corporation.
UNIX, X/Open, OSF/1, and Motif are registered trademarks of the Open Group.
Citrix, ICA, Program Neighborhood, MetaFrame, WinFrame, VideoFrame, and MultiWin are trademarks or registered trademarks of Citrix Systems, Inc.
HTML, XML, XHTML and W3C are trademarks or registered trademarks of W3C®, World Wide Web Consortium, Massachusetts Institute of Technology.
Java is a registered trademark of Sun Microsystems, Inc.
JavaScript is a registered trademark of Sun Microsystems, Inc., used under license for technology invented and implemented by Netscape.
SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAP Business ByDesign, and other SAP products and services mentioned herein as well as their respective logosare trademarks or registered trademarks of SAP AG in Germany and other countries.
Business Objects and the Business Objects logo, BusinessObjects, Crystal Reports, Crystal Decisions, Web Intelligence, Xcelsius, and other Business Objects products andservices mentioned herein as well as their respective logos are trademarks or registered trademarks of Business Objects S.A. in the United States and in other countries.Business Objects is an SAP company.
All other product and service names mentioned are the trademarks of their respective companies. Data contained in this document serves informational purposes only.National product specifications may vary.
These materials are subject to change without notice. These materials are provided by SAP AG and its affiliated companies ("SAP Group") for informational purposes only,without representation or warranty of any kind, and SAP Group shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP Groupproducts and services are those that are set forth in the express warranty statements accompanying such products and services, if any. Nothing herein should be construedas constituting an additional warrant.