Warning: Creating default object from empty value in /home/johnnz/public_html/wp-content/themes/simplicity/functions/admin-hooks.php on line 160
Tag Archives: Data Quality

Data Quality, MDM and the Art of Sex

In a recent discussion with some colleagues on Data Quality and Master Data Management we all expressed our bafflement as to why there was so much confusion out there surrounding theses relatively straightforward subjects and why, in the twenty first century, so many practitioners were using such archaic and flawed approaches. One those present said […]

2 Comments Continue Reading →

Don’t Look in Existing Data for Master Data Entities

Why not? Because it is about as effective as looking in the dumpster outside a restaurant for the ingredients for a gourmet meal. In my last articles on the major errors made in Master Data Management (MDM), I explained how most MDM projects start in the wrong place and then head off in the wrong […]

2 Comments Continue Reading →

If I Wanted to Get to Dublin I Wouldn’t Start from Here: Part 1

It seems that most Master Data Management (MDM) projects are starting in the wrong place and heading in the wrong direction! They fail to build and use that essential and most powerful of MDM tools, the Logical Data Model (LDM).

This approach is about as productive and effective as building a ship without a keel!

This is the first of three posts that explain what the problems are and how top avoid them.

Leave a comment Continue Reading →

Customer & Supplier are Roles – But What Type?

Customer & Supplier are NOT Master Data Entities in Master Data Management (MDM). They are in fact Roles that can be played by the entity Third Party. But are there roles derivable or declarative, i.e. must they be declared and defined? Using the concept of declarative Roles allows unlimited number of Roles to be defined for any third party over time.

2 Comments Continue Reading →

Data Quality: Objective or Subjective?

Data quality cannot be looked at and defined objectively unless you know the context in which it is to be applied, i.e. the Business Functions the data is meant to support. All other definitions are subjective and, as such, prevent Data Quality being achieved.

Leave a comment Continue Reading →

Logical Data Model for Customer & Supplier

The logical data model below shows the data structure needed to support Customer, Supplier and Employee.  Pardoxically, none of these appear as an enitity on model! How can that be? There is a very good reason for this, which is that Supplier, Customer and Employee are all deriveable data entities and, as such, ought NEVER […]

2 Comments Continue Reading →

Customer is Not a Master Data Enitity.

Having Customer and Supplier as Master Data Entities is about as sensible as having Creditor and Debtor. Why? Because all of these terms refer to derivable relationships and implementing them as Master Data Entities is both a modelling and business error. If this is true, why are they so often modelled as such? It all […]

1 Comment Continue Reading →

Will Best Practice Keep Your Data Quality Boat Afloat?

Some of attendees at a recent workshop that I ran told me that data quality was assured in their enterprise because they always followed industry best practice.  On the surface this seems to be a compelling argument.  If you are following best practice all must be right with your data quality.  Or is it? If […]

Leave a comment Continue Reading →

There Are No Such Things as Data Rules!

This may come as a surprise to many involved in Data Quality but, wait for it, there are no such things as data rules! By looking at data you can never deduce or define a rule that dictates that one entity should be related to another or that a value of an attribute of an entity has to be, in a certain format and have limits to its value. So what does dictate data content, structure, format and constraints?
Click on “Read More” and find out why….

12 Comments Continue Reading →

There's No Such Thing as a Customer!

“Customer” is one of the Data Enitities that lies at the heart of most MDM practices in enterprises around the world and it is not in fact a Data Entity at all! This situation has arisen because far too much “data quality” work is done without the use of a properly structured Logical Data Model. This work then serves to perpetuate rather than remove fragmented data structures.

17 Comments Continue Reading →