I am reading a book on MDM by IBM Press, entitled “Enterprise Master Data Management – An SOA Approach to Managing Core Information”. Long title, longer list of authors. Well written. In the old days, it was the DW’s responsibility to cleanse the data and integrate sources. However, this value add could not be pushed back to the source systems easily. Now, the problem has been even more accentuated, with the advent of new customer facing services, that have been designed as separate applications for practical reasons. The concept of Master Data has been diluted, with a number of applications having their own version of it. The effect is an unconsolidated view of Customers, Products, and Suppliers. The result is lost opportunities – cross selling opportunities, targeted marketing opportunities, new product introduction opportunities.
The task (of implementing MDM) isn’t easy. Not only do you have to consolidate the Master Data across multiple applications, but you have to ensure that the consolidated data is then used by every one of those applications. Services can help you do that.
Such projects are going to be as big or bigger than DW projects in large organizations. I see the same type of incremental approaches being suggested. In other words, don’t try to do everything at the same time. Do it gradually, and show value in every step. The similarity with the EDW experience is obvious.
This will make DW easier. of course, and provide more value. The transactional history of customer behavior or product buying patterns will be even richer. The trick is to use the MDM as the source for your dimensional data.
One of the challenges will be that the DW will already be in place in your organization. So, as your MDM solution is being put in place, you need a strategy of migrating your DW to take advantage of this rich new source of dimensional data. The same incremental approach can be used.
In future, data strategies will talk about MDM, DW and BI in the same breath. They go hand in hand. It’s a perfect love triangle.