Schweitzer Fachinformationen
Wenn es um professionelles Wissen geht, ist Schweitzer Fachinformationen wegweisend. Kunden aus Recht und Beratung sowie Unternehmen, öffentliche Verwaltungen und Bibliotheken erhalten komplette Lösungen zum Beschaffen, Verwalten und Nutzen von digitalen und gedruckten Medien.
Foreword xiii
Preface xvii
Acknowledgments xxi
Introduction 1
Part I: Planning Your Customer MDM Initiative 7
Chapter 1: Defining Your MDM Scope and Approach 9
MDM Approaches and Architectures 9
Analytical MDM 11
Operational MDM 14
Enterprise MDM 18
Defining the Business Case 20
Cost Reduction 21
Risk Management 22
Revenue Growth 23
Selecting the Right MDM Approach 23
Data Management Maturity Level 24
Addressing the ROI Question 27
Summary 27
Note 28
Chapter 2: Establishing Effective Ownership 29
The Question of Data Ownership 29
Executive Involvement 31
MDM with Segmented Business Practices 31
A Top-Down and Bottom-Up Approach 32
Creating Collaborative Partnerships 33
Can Your Current IT and Business Model
Effectively Support MDM? 33
The Acceptance Factor 34
Business Access to Data 35
Coordination of MDM Roles and Responsibilities 36
Summary 38
Notes 38
Chapter 3: Priming the MDM Engine 39
Introduction 39
Positioning MDM Tools 40
Data Integration and Synchronization 42
Data Profiling 43
Data Migration 46
Data Consolidation and Segmentation 55
Reference Data 57
Metadata 60
Summary 63
Notes 63
Part II: The Implementation Fundamentals 65
Chapter 4: Data Governance 67
Initiating a Customer Data Governance Model 67
Planning and Design 69
Establishing the Charter 70
Policies, Standards, and Controls 78
Implementation 85
Process Readiness 85
Implement 88
Maintain and Improve 91
Summary 93
Notes 94
Chapter 5: Data Stewardship 95
From Concept to Practice 95
People 96
MDM Process Core Team 97
Operational Process Areas 102
Processes 107
Data Caretaking 108
Summary 109
Chapter 6: Data Quality Management 111
Implementing a Data Quality Model 111
A Process for Data Quality 114
Drivers 115
Data Quality (DQ) Forum 117
Controls/Data Governance 119
Data Analysts 120
Design Team 123
IT Support/Data Stewards 125
Metrics 126
Establishing a Data Quality Baseline 127
Context 127
Data Quality Dimensions 129
Entities and Attributes 129
Putting It All Together 132
Data Alignment and Fitness Assessment 136
Data Correction Initiatives 137
Summary 140
Note 140
Chapter 7: Data Access Management 141
Creating the Business Discipline 141
Beyond the System Administrator 142
Creating the Right Gatekeeper Model 144
Preparing 145
Employee Data 146
Access Management Requirements 146
Add User Group Names 148
Map Privileges to Requirement Categories 149
Profiling the Data 150
Implementing and Managing the Process 152
Testing and Launching the Process 157
Resolve Issues Immediately 157
Auditing and Monitoring 158
Segregation of Duty (SoD) Management 159
Summary 161
Notes 161
Part III: Achieving a Steady State 163
Chapter 8: Data Maintenance and Metrics 165
Data Maintenance 165
Specify, Profile, and Analyze 167
Improve 167
Data Quality Metrics 184
Monitors 185
Scorecards 187
Summary 189
Note 190
Chapter 9: Maturing Your MDM Model 191
How to Recognize and Gauge Maturity? 191
Data Governance Maturity 193
Data Stewardship Maturity 194
Data Quality Maturity 195
Data Access Management Maturity 197
Summary 198
Notes 199
Part IV: Advanced Practices 201
Chapter 10: Creating the Customer 360 View 203
Introduction 203
Hierarchy Management (HM) 206
Operational versus Analytical Hierarchies 207
Single versus Multiple Hierarchies 208
Number of Levels in the Customer Hierarchy 209
Virtual versus Physical Customer Records 211
Legal versus Non-Legal Hierarchies 212
The Elusive, yet Achievable, 360 Customer View 213
Summary 213
Chapter 11: Surviving Organizational Change 215
How Adaptable is Your Customer Master Data? 215
Data Quality Factors 216
Data Completeness 217
Data Consistency 217
Data Integrity 218
The Change Management Challenge 219
Data Governance Can Greatly Assist a Transitioning State 220
Leveraging the Data Stewards and Analysts 220
Adopting Best Practices 222
Summary 222
Chapter 12: Beyond Customer MDM 225
The Leading and Lagging Ends 225
Technology's Influence on MDM 226
Overcoming the IT and Business Constraints 228
Achieving an Effective Enterprise-Wide MDM Model 230
Where Does MDM Lead? 233
Summary 235
Note 236
Recommended Reading 237
About the Authors 239
Index 241
Today's business environment requires companies to find a way to differentiate themselves from their competition and thrive amid increased pressure to succeed. While a company's data is obviously extremely important to drive and gauge success, the data is often poorly organized and underutilized due to quality and consistency issues. This can be particularly true with master data.
Master data provides a foundation and a connecting function for business intelligence (BI) by the way in which it interacts and connects with transactional data from multiple business areas such as sales, service, order management, purchasing, manufacturing, billing, accounts receivable, and accounts payable (AP). Master data consists of information critical to a company's operations and BI, and is usually categorized into master data entity areas (also often referred to as data domains) such as customers, products, suppliers, partners, employees, materials, and so on. While often nontransactional in nature, master data is utilized in most transactional processes and operations, and serves BI by providing data for analytics and reporting. Although defined as master data, this data often exists in duplicate, fragmented, and inconsistent forms in disparate systems across the organization and typically lacks a common data management approach.
Master Data Management (MDM) practices have arisen primarily to address these data quality and fragmentation issues. For years, there has been a huge proliferation of data due to cheap storage and increased digitization. Furthermore, compartmentalized solutions have added to the fragmentation of information considerably, magnifying data duplication and lack of a common entity identification. Organizations came to the realization that the most effective way to address this growing problem is by creating a single source approach for management of master data based on high standards of quality and governance serving the entire business.
Unfortunately, this is easier said than done. At the root of these data quality issues is the well-acknowledged garbage in, garbage out (GIGO) problem from which most legacy environments still suffer. This persistent problem creates the underlying enterprise data management challenge that MDM is focused on addressing. Historically, data management focuses centered in Data Warehouse, Customer Relationship Management (CRM), and Customer Data Integration (CDI) practices have not actually tried to broadly solve the GIGO problem. Instead, those practices have focused primarily on the reconciliation, organization, and improvement of the data after the point of entry or just within specific process areas. Thus, the GIGO factor persists and continues to pollute the transactional data, the master data, and BI.
Although there is certainly good rationale and benefit to a back-end reconciliation and scrubbing approach, there is also a consequence whereby these practices themselves can create yet more process or context-specific fragmentation moving enterprise data further from a system of record and source of truth. CDI practices are geared more toward a source of truth outcome but CDI is still often implemented just with specific data environments. In spite of the limitations or data specific application, these types of data management practices have set the stage for what is now being recognized with MDM as a more holistic set of techniques and approaches that can span business practices and aim at developing enterprise-wide data quality management and governance practices.
It is fair to point out that MDM practices are not likely, nor should they be expected, to fully eliminate the GIGO problem. Instead, through focus on improving the control and consistency of the master data shared by both the operational and business intelligence processes, and through data governance-driven policies and standards aimed at improving the data management practices associated with a data entity area, the degree and impact of the GIGO problems can be greatly minimized. This focus around gaining control and management of the shared data is a key concept also described in various data governance maturity models that illustrate how data management practices have been evolving from undisciplined or independently oriented application practices toward MDM disciplines focused on enterprise-wide data integration and governance models supported by ubiquitous oriented technologies and best practices.
Many excellent books have been published that address the what and why aspects of MDM, and dive into key topic areas that distinguish MDM in the data management space. These publications have established the overall recognition, definition, and the value proposition that is driving companies to consider and position MDM initiatives in their business and IT strategies. There are a number of books we highly recommend. Please refer to the Recommended Reading section of this book for specific recommendations.
When navigating through a topic such as MDM, it is not unexpected to find variation in the specific context and definition. We feel that the following Gartner definition and context best articulates MDM:
Master data management is a technology-enabled business discipline that helps organizations achieve a "single version of the truth" in such important areas as customers, products and accounts.
In MDM, the business and the IT organization work together to ensure the uniformity, accuracy, semantic persistence, stewardship and accountability of the enterprise's official, shared master data. Organizations apply MDM to eliminate endless, time-consuming debates about "whose data is right," which can lead to poor decision making and business performance.1
Although the MDM movement is well underway, how to develop the business discipline and how business and IT work together to enable this is still very much a topic for debate and often a work in progress dynamic as an MDM initiative takes shape. A closer look across the MDM market reveals a lack of much practical instruction for MDM planning and implementation from a business practice perspective. How the business needs to be engaged to create the business discipline has not been well articulated.
The lack of this type of instruction is actually not a new or unique problem in the data management arena. Consider that just as data management has traditionally been centered in more application and IT-oriented practices, the planning and instructional aspects of data management have also been tailored to specific application or vendor product scenarios and usually stem from vendor literature, consultant material and white papers, or simply from self-discovery. Unfortunately, though, growth and execution of MDM as a business practice will continue to be subject to a slow and unpaved road if the business planning and implementation teams continue to be faced with too much self-discovery where the vendor or consultant material comes up short.
When the practitioners of MDM come together at conferences or in community forums, there is quick recognition that many of their MDM needs and initiatives are centered around the execution of fundamentally common practices and techniques with the variation only in the implementation approach and the adaptation of these practices and techniques to the specific environments, infrastructure, and business models within their company. Most practitioners will also indicate that had they garnered a better fundamental understanding of MDM practices along with more "under the hood" insight to guide their approach and techniques, their implementation and adaptation efforts could have been better focused and handled more effectively.
The main challenge with bridging this instructional gap is simply in determining a good starting point. Although MDM discipline can be applied to various data domains, any of which can present significant data management problems in a company, a common starting point where an MDM initiative is usually most critically needed, and will initially be considered, is with the customer data domain commonly referred to as Customer MDM.
Customer MDM is where we have cultivated our MDM experiences, perspectives, and solutions that we present in this book. Our backgrounds span many years of both business and IT experience primarily with Sun Microsystems and later with Oracle, and also reflect the data integration experience we have had in relation to companies Sun had acquired and from the acquisition of Sun itself by Oracle. As with all large multinational companies, there are huge data management challenges that emerge over the years as companies grow, constrict, acquire other companies, face new competitive challenges, transition from old system infrastructure to new platforms, and are subject to increasing requirements regarding security, information privacy, government regulations, and compliance.
Because any of these conditions can be very disruptive, companies that maintain a flexible and fluid dynamic between the business and IT roles will be most able to adapt quickly to address these challenges. The flexibility and adaptability needed here has to be an existing dynamic within specific roles and responsibilities, and doesn't just happen with initiating a new project or a consulting engagement. This dynamic needs to be demonstrated by dedicated managers, data stewards, and data analysts working closely together across business and IT lines under data governance authority to address these data management challenges while also minimizing disruption to the normal operational practices.
It has been our...
Dateiformat: ePUBKopierschutz: Adobe-DRM (Digital Rights Management)
Systemvoraussetzungen:
Das Dateiformat ePUB ist sehr gut für Romane und Sachbücher geeignet – also für „fließenden” Text ohne komplexes Layout. Bei E-Readern oder Smartphones passt sich der Zeilen- und Seitenumbruch automatisch den kleinen Displays an. Mit Adobe-DRM wird hier ein „harter” Kopierschutz verwendet. Wenn die notwendigen Voraussetzungen nicht vorliegen, können Sie das E-Book leider nicht öffnen. Daher müssen Sie bereits vor dem Download Ihre Lese-Hardware vorbereiten.Bitte beachten Sie: Wir empfehlen Ihnen unbedingt nach Installation der Lese-Software diese mit Ihrer persönlichen Adobe-ID zu autorisieren!
Weitere Informationen finden Sie in unserer E-Book Hilfe.
Dateiformat: PDFKopierschutz: Adobe-DRM (Digital Rights Management)
Das Dateiformat PDF zeigt auf jeder Hardware eine Buchseite stets identisch an. Daher ist eine PDF auch für ein komplexes Layout geeignet, wie es bei Lehr- und Fachbüchern verwendet wird (Bilder, Tabellen, Spalten, Fußnoten). Bei kleinen Displays von E-Readern oder Smartphones sind PDF leider eher nervig, weil zu viel Scrollen notwendig ist. Mit Adobe-DRM wird hier ein „harter” Kopierschutz verwendet. Wenn die notwendigen Voraussetzungen nicht vorliegen, können Sie das E-Book leider nicht öffnen. Daher müssen Sie bereits vor dem Download Ihre Lese-Hardware vorbereiten.
Bitte beachten Sie: Wir empfehlen Ihnen unbedingt nach Installation der Lese-Software diese mit Ihrer persönlichen Adobe-ID zu autorisieren!