Master Data Management (MDM) - Chalk and Talk

In this video I talk about MDM or Master Data Management both for operational systems as well as analytical solutions. MDM is used to produce "Golden Records", "Single Source of Truth", or just plain old reliable data in a systematic way. For operational systems I touch upon the topic of Enterprise Service Bus (ESB) for keeping different systems up to date. For analytics I discuss how records can be merged and matched to produce a single reliable record.

0:00 - Introduction
0:55 - MDM and ESB for operational systems
8:00 - Analytics data mastering
18:17 - Wrap-up

[meriemretiel]

I'm planning to take salesforce data architect exam, and I wanted to understand in a simple a way what's master data management is all about, what problems it deals with . You're video really helped me thank you

[reaper]

This MDM split between Ops & Analytics just explained the confusion I’ve been experiencing 😂 thanks!

[Lilninj]

Thanks Dave, very well and simply explained!

[illiakaltovich]

Thank you for the high-quality video, it was really interesting and insightful

[thigmotrope]

you describe a map that's created on the operational side. I think you answered this in another comment, but it just seems obvious to sync that map to the analytics tier, so analytics doesn't have to get into all this fuzzy matching for deterministic cases.

by the way, great video though. this really helped me a lot. content like this is somewhat hard to find because there's so much vendor created content.

not sure if you have an identity resolution deep dive that you have considered doing. this video sort of is that in a way but I think it's trying to talk about the MDM space for Identity

[nitindhingra]

Excellent Dave, Many of my queries got resolved. Keep it up.

[pnojokv]

Thanks Dave, I love your videos, they are very helpful. Keep it up!

[optimastic]

Please cover the rest data management applications like data lineage and refrence data management and metadata, thanks in advance

[balawalali]

Hi, Very informative, I love this video

[balawalali]

@dave
I am trying to build a analytical DB. Data will be collected from multiple sources and each is connected to each other with some master Id.
I have just learned master data management, but i wonder how i will design my analytic system according to MDM

[Hellya]

that's a very good talk, just question about 7:06 when you mentioned about update only happens at single point when there is need to replace one of the services, I think that make sense if the event payloads stay the the same but probably not the case most of the time where you still have to update the logics in other service in order to publish/consume the new event payloads, or did I misunderstood what you were trying to describe?

[wnfwbvq]

Excellent Dave, Thanks i love you videos, could you help me how can i use an open source MDM platform for my company?

[daverook]

It feels odd to see so much data duplicated (in the operations side). I wonder what the advantage is of having duplicated/synced data vs references to a single source of truth - it also has a familiar feeling with Domain driven design (if I've understood it right). Thank you

[paulvanputten]

Hi Dave, thanks for the great video. I am trying to conceptually understand MDM. I have one question though. In the video you mention that there is one system that is the single source of truth. In the case of your example, this is the CRM system. Is it possible to design the ESB in such a way that if a record is created in the system that is not the 'main' system that via the ESB a record is created in the main system? So, a person creates an account in the web system and this person is not yet in the CRM system. Is it possible that a record is automatically created in the CRM system? The CRM will also add the email and phone number from the web system to this record. I hope the question is clear :)

[lxn]

Maybe my question is stupid but wouldn't you plug your analytics to your ESB?

[RonMatthews-qh]

Gonzalez Karen Hall Margaret Thompson Larry