Start a Dialogue about MDM

Just mentioning master data management (MDM) will cause businesspeople’s eyes to glaze over and most IT folks to run for the hills. Why does MDM create puzzlement and apprehension? The principal reason is that they need an IT buzzword dictionary to interpret the rather lengthy and complicated definitions. Despite the inherent reluctance, a successful MDM program needs businesspeople to understand it, sponsor it and commit to being part of the solution, along with IT to design, build and deploy it. And before any of that happens, you need to have a two-way dialogue about it.

Explain What it is, Simply

Your conversations with the business will be framed based on your vertical industry:

• For financial services or retail companies, discuss how you need to obtain comprehensive and consistent customer information. The lack of customer data integration is inhibiting cross-sell, up-sell and responsive customer service.
• For companies that make products such as consumer goods, industrial products or medical devices, discuss comprehensive and consistent data about products, parts and suppliers. Problems with this data has likely inhibited effective internal controls and the understanding of product profitability.
• For health care providers and insurers, discuss a single view of patients, doctors and diagnostic codes to get business and medical personnel wholeheartedly involved. Finally, when you speak with your IT staff, discuss the problems that your systems are having with tracking reference data such as customers and products, and you will get them engaged in trying to solve the problem.

Explain What it is Not

MDM is not a product. You will use technologies and products to enable a solution, but no single product is a silver bullet. People and processes are needed on an ongoing basis to define, interpret and manage reference data. Businesspeople have to reach a consensus on how to make the data and its associated filters and metrics consistent and comprehensive for the enterprise. No software in the world is going to resolve a disagreement between businesspeople on who is a customer or patient (if you think that’s a no-brainer, you haven’t worked on reference data), let alone more sophisticated metrics like lifetime profitability.

Technology will be very useful for data integration and data cleansing, but the critical success factors will be business/IT involvement, an enterprise-wide data governance program and an ongoing commitment to maintain the reference data.

Determine Where Your Problem is

One of the key inhibitors to a business’s single version of the truth is the lack of consistency and integration across reference data such as customers, products, suppliers and organizational hierarchies. Sales territories and account structures are the classic example. By the way, the reference data is referred to as dimensions in the business intelligence world and master data (or lists) in the operational systems such as enterprise resource planning (ERP) applications.

In order to determine where to begin addressing the problem, you need to determine where your problem is or where the business pain is most evident. There are three potential areas to address: operational, analytical or enterprise (both). You should focus on managing reference data in your operational systems, such as your ERP application, if data synchronization across systems is inhibiting the business from running the business. Many companies spend a lot of time integrating product lists, for example, between various enterprise applications to keep them consistent. This would be a flag that you should look at a solution that concentrates on systemically improving application integration of reference data.

If, on the other hand, your business is spending a lot of time trying to conform dimensions between your data warehouse and reporting/analytics, then concentrating on managing the reference data here is where you should start.

If your company is having issues in managing reference data in both your operational and analytic systems, then you need an enterprise solution. A word of caution: in this situation, you need to limit your scope if you want to have a fighting chance of success, so start with the area causing the most significant business pain.

Next Steps

Just as with any rehab program, you cannot fix a problem until you accept that you have a problem. And that includes accepting your responsibility for the problem. In future columns, I will discuss how to approach and work toward solutions.

Rick Sherman has more than 20 years of business intelligence and data warehousing experience, having worked on more than 50 implementations as a director/practice leader at PricewaterhouseCoopers and while managing his own firm. He is the founder of Athena IT Solutions, a Boston-based consulting firm that provides data warehouse and business intelligence consulting, training and vendor services. Sherman is a published author of over 50 articles, an industry speaker, a DM Review World Class Solution Awards judge, a data management expert at searchdatamanagement.com and has been quoted in CFO and Business Week. Sherman can be found blogging on performance management, data warehouse and business intelligence topics at The Data Doghouse.You can reach him at rsherman@athena-solutions.com or (617) 835-0546.

In addition to teaching at industry conferences, Sherman offers on-site data warehouse/business intelligence training, which can be customized and teaches public courses in the Boston area. He also teaches data warehousing at Northeastern University 's graduate school of engineering.

For more information on related topics, visit the following channels:

• Master Data Management (MDM)
• Data Management