Wednesday, March 3, 2010

Five Pillars of MDM

The first pillar, content, is not only the backbone of MDM, but also the foundation of any
data model. Master data content is usually enterprise-oriented and highly specific to
your business, relying on terminology that is often unique to your company.
What separates MDM from other technologies is that, in mastering the subject area,
it goes beyond the mere content of your data and presents relationships between
different data elements, including hierarchies and groupings. For instance, a “household”
frequently refers to a group of people living in the same location. Such a grouping
requires its own set of rules and definitions, as established in a data model. While a retailer
may merely group all the related people living at the same physical address, a bank, for
example, may only consider wage earners living at a given address. Again, it depends on
your business. Establishing the parent/child hierarchy within a given household may be
crucial for some businesses, such as insurance companies, but not others.

Similarly, MDM is able to support access rules to deal with the details of data flowing
into and out of the MDM hub. The delivery (or provisioning) of the data content and
relationship details to other systems means enforcing the rigor associated with security
and access policy at an individual data-element level to ensure that all rules and details
associated with data access is maintained. While most believe that data access or
linkage is limited to in-house or corporate systems, MDM can support any data source,
so integrating with third-party or external data is no more complex than an internal
billing system. As more and more data is available and linked, tight access control is
essential to ensure that data doesn’t fall into the wrong hands.

Because corporate information is always changing, mastering data also involves
supporting a robust change control component within MDM. Business data changes
in real-time, and an MDM environment must recognize which changes are acceptable.
A mature MDM hub understands when a data element change can be supported
in an automated fashion, or when it requires intervention from an external process
(e.g. another system, a data steward, etc.). Unlike traditional IT-based change control
methods that focus on application changes or business process changes, MDM focuses
on data value changes.

MDM also involves the actual processing of data, from basic matching and identification
to data correction and CRUD (create, read, update, delete) processing. Processing rules
contain the details for determining whether two records are the same. For example,
are customers Robert Smith and Bob Smyth the same? If so, should one of the values
be updated? If Bob calls and updates his address, should that change be propagated
throughout the other databases in the system, including the master record? Does it
matter if the address change comes from a third-party data vendor instead? Which
update should the system trust? And if it turns out that the data was incorrectly entered,
the data model should support unwinding the match to set the record straight.
This discussion of the five pillars is helpful in understanding the differences between
MDM and other strategic technology solutions, and will help to put the data model in
better perspective.

in reference to: Data-Modeling-and-MDM.pdf (application/pdf Object)

Wednesday, February 3, 2010

Analytic Auteurs

This is an interesting excerpt from SmartDataCollective article by Steve Bennett calledAnalytic Auteurs. To read the complete article please visit SmartDataCollective

"Now I never thought of myself as an auteur, but my favourite analogy for 'doing analytics' was making a movie. The analogy runs something like this:

As the director (think of me as a cross between Tim Burton and Spike Jonze) I assemble a team for 1 - 2 years and together we create the analytic solution the organisation needs. The solution is generally made up of two components. The first is a suite of information products (data marts, cubes, reports, dashboards, etc.). The second is the skills for the organisation to 'self serve' and create new information products without us.

We then we disperse to different places. Only to meet again when the next 'movie' opportunity arises.

My trusted experts are:

* Business Analyst - Script Writer
* Data Integrator - Special Effects
* Solution Designer - Cinematographer
* Information Designer - Set Designer/Head of Props
* Quality Control - Post-Production
* Change Agent - PR and Marketing

Why do the same people agree to work with me more than once? Well, you'll have to ask them to really know. But I can tell you what I tell them when I'm trying to get them them for one more gig. In no particular order I promise them:

* A real intellectual challenge
* A core team they can trust
* That they will learn from both the challenge and their fellow team members
* Very good remuneration - at least as good as they will get elsewhere
* Fun!

Don't get me wrong. The core team does get new blood each time and sometimes people just muscle their way into the team by being damn good at what they do. Never underestimate serendipity and the pleasure at meeting another person of whom you think 'wow - they're good!'"

How Multidomain MDM Can Support Business Users

How Multidomain MDM Can Support Business Users

Tuesday, December 22, 2009

Multi-Domain MDM: Kid in a candy store ?


Market is maturing from Customer Data Integration(CDI) to more holistic view of Master Data Management. Multi-domain MDM seems to be the buzz of the moment, even though when companies do not seem to have mastered the art of single domain MDM.
It is one of those conformist truisms which people will never dare contradict to your face. Go to any Business Intelligence, Master Data Management or Data Governance conference, website, blog or individual and they will all sing from the same hymn sheet here. Multi-domain is the MDM panacea.     - Duncan Slater, Accenture Information Management Services
 I could not agree more with Duncan's article on Enterprise MDM and Apple Pie. Organizations need to think through the people, process and technology aspects of MDM. It goes back to the piece I wrote about Data Governance. It is an industry which is being driven by vendors rather than the companies which need the solution. Vendors are selling big dreams for big revenue, and clients are like kid in a candy store.

The client needs to step back and evaluate their needs before they go shopping for buy-one-solve-all problems system.

Saturday, December 19, 2009

Thursday, December 17, 2009

Gartner MDM Summit - Siperian Perspective

The hot topic at the summit was multi domain MDM.

Interesting notes from the conference:
• Gartner expects the market for MDM to grow from $1.1 billion (in license revenue) in 2008 to $3 billion in 2013.
• North America is still the largest market for MDM (over 50%) followed by Europe (35%).
• IBM, SAP and Oracle control 40% of the MDM market, while specialists like Siperian control 30%.
• Analysts are saying that there’s a “land grab” on for multidomain MDM, but most vendors have yet to span master data province.

The future looks exciting.

In reference to:
- Master Data Management (MDM) Solutions - Customer Data Integration (CDI) Hub by Siperian

Friday, December 11, 2009

Data Governance – The Rock on Which MDM is Built

Andy argues that data warehousing and ERP were failed attempts to get "one version of the truth". In MDM emphasis is on business ownership of data i.e. Data governance. Well written. Having dedicated resources to take ownership from business and clear definitions of "customer" and "product" are crucial to success.

"Building a proper business case is a key element of an MDM initiative. It is only by analysing the costs of the current state of duplicate data and estimating what that is costing the business in lost orders, incorrect deliveries or invoices, misplaced inventory, inability to cross-sell or lower customer satisfaction and retention, that executives will stand up and take notice.

By building a business case around such hard data, it should be possible to get senior management attention. In some cases where this has happened, it has also been possible to gain the necessary senior level support for true data governance initiatives. Such activities, business-led rather than IT-led, involve identifying the key data and processes of a company and agreeing who should be ultimately responsible for defining business terms. Such groups also take ownership for resolving disagreements when they arise, e.g., over whose definition of “gross margin” should actually be used. Significant resources need to be assigned to such activities, not just as a one-off project basis but on a permanent basis.

The best run companies are putting in place such data governance initiatives and giving budget and power to the data governance groups that are needed to resolve definitions and resolve data quality.

An MDM project may still struggle even after data governance has been established, but if a strong data governance initiative can be built and sustained, then MDM projects have a least a chance of success."

Once data governance is resolved then also the success of an MDM team is dependent on a highly competent technical team. Companies like Infotrellis should be invited at this point to ensure successful implementation.

Companies should read this before coming up with their MDM strategy.

in reference to: BeyeNETWORK: Data Governance – The Rock on Which MDM is Built (view on Google Sidewiki)

About :

Andy Hayler - founder and CEO of The Information Difference, a boutique analyst and market research firm, advising corporations, venture capital firms and software companies. He is a regular keynote speaker at international conferences on master data management, data governance and data quality. He is also a respected restaurant critic and author (www.andyhayler.com). Andy has an award-winning blog www.andyonsoftware.com. He can be contacted at Andy.hayler@informationdifference.com.

Infotrellis - InfoTrellis provides strategic consulting to help clients define and achieve their Customer Data Integration (CDI) and Master Data Management (MDM) vision. It was founded by the team which architected and developed WebSphere Customer Center (WCC), formerly known as DWL Customer, the market leading CDI/MDM solution by IBM/DWL and in the process created the CDI/MDM space. Services provided by InfoTrellis team cover all aspects of a CDI/MDM solution lifecycle ranging from evaluating client's CDI/MDM needs, capturing detail business requirements, vendor selection, design & implementation, testing, deployment and training. info@infotrellis.com