Key Questions to Ask During Master Data Consolidations

Typical master data consolidation starts with combining the operational master records from all the data silos where they exist. The key aspect being, creation of master data indexes to support single view; knowing and asking right questions during this phase can save lot of time and rework.

By Prash Chandramohan, shared with permission from MDMGeek

Project

Management

[wd_hustle id=’Social’ type=’social_sharing’/]

Typical master data consolidation starts with combining the operational master records from all the data silos where they exist. The key aspect being, creation of master data indexes to support single view; knowing and asking right questions during this phase can save lot of time and rework.

In an earlier post on this blog, I examined the ways in which we can identify the right sources of Master Data. Once these data sources are identified, next step is to select the right data elements from them, which confront to the definition of master data.

Some of the characteristics of this exercise are:

  1. Finalizing the core data elements, which constitute the master data entities.
  2. Classifying and standardizing common attributes, which are managed by individual silo systems and may bear different meanings at the onset but represent same element.
  3. Identifying the reference data sets(both internal and external) and mapping them to comprehensible list of enterprise wide accessible codes.
  4. Isolating the known inaccuracies in the data, especially the ones that are causing costly damage.
  5. Measuring the quality of the data by using data profiling and discovery tools.
  6. Recognizing and defining complex relationships between key master data entities.
  7. Determining the fetch mechanism to gather initial and delta changes from variety of data sources.
  8. Coming up with a strategy to extract data into master data hub using an iterative, repeatable process.
  9. Creating a framework for fixing duplicated data, error processing and exception handling.

 

To be able to do all of these activities, we need to have a good understanding of sources of master data. Section below, lists key questions that need to be asked and answered towards addressing aforesaid aspects.

  1. What are the key entities that the source system manage and require for smooth functioning?
  2. What are the essential elements that constitute each of the entities listed above?
  3. What is the business name of a given data element? What does the element mean and what does it represent?
  4. What is the format and length of each of the data elements? Are rules and logic defined to ensure the values adhere to the definition of the field.
  5. Is data element a mandatory field? Conditionally required? A derived value? Has a default value?
  6. If an element is referenced by a code lookup, what are the possible values?
  7. In case of reference codes, is there a central reference data repository that can manage this data?
  8. Are there any requirements for logical grouping of the data elements?
  9. How are different entities linked with each other? What is the cardinality of the relationship?
  10. How are these master data elements created, read, updated, searched and deleted?
  11. What are the ways in which data can be extracted from the source? (Replication based, Time Stamp based, Table comparison, Log based etc.)
  12. What is the frequency in which data can be synchronized to master data hub? Can system support real time invocation of services?
  13. What is the estimated number of records for initial and delta load? What is the rate of increase year-on-year?

 

While this list is not exhaustive, it sure gives us a starting point on the right questions to ask during this commonly occurring practice during MDM endeavor.

Read the original article and leave comments here.

Prash Chandramohan

Author

Prash Chandramohan works as a Senior Product Marketing Manager at Informatica focusing on product marketing activities for Informatica MDM, Big Data Relationship Management and Customer Cloud 360 for Salesforce. He joined Informatica in 2014, prior to which he worked at IBM as a Senior Architect. For past 10+ years, Prash has worked with several large enterprise customers around the globe and delivered MDM-powered solutions.

In his current role as product marketer, he strives to influence a road map for next generation MDM that can help organizations gain the business benefits they anticipate from this great technology.

Related Posts

Opt-in Synchronization

Opt-in SynchronizationNot all operational systems will choose to, or be able to, consume the changes made to master data in an MDM hub. The reasons for being out-of-synchronization may be technical, regulatory, political or economic but at some point it will be...

Changing a Match Rule

Changing a Match RuleWhen we are talking to companies about our MDM platform we cover a broad range of topics, from measuring ROI, to more technical questions about the way the software operates. A common technical question is "How do we change a match rule?" Our...

Business Process Improvements

Business Process ImprovementsThe analysis of master data and MDM processing logs can reveal interesting opportunities for business process improvements. We show how, as long as you collect the right data and know how to analyze it, you can drive significant business...

Ready to master data mastering?

Subscribe to our mailing list and we’ll send you courses, insights, product updates, and more. Get to know the ins-and-outs of your Gaine MDX platform, features, and solutions.

[wd_hustle id=”SimpleSubscribe” type=”embedded”/]

Gaine Solutions

Gaine helps leading healthcare organizations, life sciences, and biotech companies leverage information as they strive for competitive advantage and operational efficiency. Our Coperor™ platform arms our clients with Information Agility™ which maximizes flexibility, minimizes cost and time-to-value, and eliminates the risks associated with implementing new systems, migrating existing systems, and integrating data from internal and external sources.

FOLLOW US ON LINKEDIN  

30%

Average Reduction in Time

TIME  

40%

Average Cost Reduction

COST  

100%

Rate of Project Success

RISK  

 

Specialization Healthcare and Life Sciences

EXPERIENCE  

News and Recommended Reading

EXPLORE MORE ARTICLES  

 

The Journey to Interoperability Starts with Coperor Core Services.

Coperor redefines system interoperability, combining the best of master data management, operational data store, data governance, and harmonization technology into a single platform.

 

 

  • MDM Stack
  • Enterprise Sync
  • Policy Repository
  • Data Stewarding
  • Real-time Services
  • Notification Engine

 

 

  • Third-party Gateway
  • Extended Support
  • ODS Integration
  • Audit Manager
  • SFDC Toolkit
  • Implementation Services

Gaine Solutions, Inc.

3889 Long St.
San Luis Obispo, CA 93401
(888) 403-1301
sales@gainesolutions.com
Already a Gaine client and need support with a product or solution?

5 + 2 =

Patient Master

Fast implementation, purpose-built industry applications, and scalability from start-up to Fortune 100.

  • Master Data Management
  • Data Governance
  • Enterprise Master Patient Index(EMPI)
  • Third Party Data Integration
  • Industry Model for Patient Data
  • Seamless Integration with CRM

.

EXPLORE THIS SOLUTION  

Data Migration Toolkit

Gaine’s Coperor platform acts as your information broker when moving from old to new systems, merging systems, or integrating with new applications. It sits between your legacy systems and your new platform to ensure that changes made in any system are synchronized according to your business rules — no lost data, no duplication, and no re-keying.

.

EXPLORE THIS SOLUTION  

Patient Master

Build a rich member profile with advanced identity management, demographics, and social determinants.

  • Member Outreach
  • Extended Member Profile
  • Population Health Data Store
  • Enrollment Management

.

EXPLORE THIS SOLUTION  

Provider Master

Gaine’s Provider Data Management suite drastically improves data quality and reduces overhead for Payers and Providers alike.

  • Provider Directory
  • Attestation
  • Roster Transformation for Provider Groups
  • Enterprise Sync
  • Reference Data Gateway
  • Data Quality Services

.EXPLORE THIS SOLUTION  

 

New! Lexis Nexis Risk Solutions Integration

LexisNexis® Risk Solutions is collaborating with Gaine Healthcare to offer health plans a powerful and effortless way of maintaining more accurate and continually updated provider data, addressing the needs of various stakeholders within the payer organization.

LEARN MORE  

Data Migration Toolkit

Gaine’s Coperor platform acts as your information broker when moving from old to new systems, merging systems, or integrating with new applications. It sits between your legacy systems and your new platform to ensure that changes made in any system are synchronized according to your business rules — no lost data, no duplication, and no re-keying.

.

EXPLORE THIS SOLUTION  

Member Master

Build a rich member profile with advanced identity management, demographics, and social determinants.

  • Member Outreach
  • Extended Member Profile
  • Population Health Data Store
  • Enrollment Management

.

EXPLORE THIS SOLUTION  

Provider Master

Gaine’s Provider Data Management suite drastically improves data quality and reduces overhead for Payers and Providers alike.

  • Provider Directory
  • Attestation
  • Roster Transformation for Payers
  • Enterprise Sync
  • Reference Data Gateway
  • Data Quality Services

.EXPLORE THIS SOLUTION  

 

New! Lexis Nexis Risk Solutions Integration

LexisNexis® Risk Solutions is collaborating with Gaine Healthcare to offer health plans a powerful and effortless way of maintaining more accurate and continually updated provider data, addressing the needs of various stakeholders within the payer organization.

LEARN MORE  

Data Migration Toolkit

Gaine’s Coperor platform acts as your information broker when moving from old to new systems, merging systems, or integrating with new applications. It sits between your legacy systems and your new platform to ensure that changes made in any system are synchronized according to your business rules — no lost data, no duplication, and no re-keying.

.

EXPLORE THIS SOLUTION  

Send this to a friend