I enjoy a slice of pizza as much as the next person (perhaps a bit more). The key to a good pizza is the raw materials- use the right stuff, and you’ll be happy every time. What’s great about pizza is that it has all sorts of great stuff on it, and presents them all in a single, easy to hold and eat meal.

Data integration can be like a really well put together pizza- lots of good cross-referencing cheese-data to keep everything in its place, great crust that supports it all, and a universal appeal that might even get people to try something they wouldn’t normally consume (data wise).

But without data quality, data integration can make pizza that nobody really wants to eat, and rather than enhancing the value of your data, your data integration efforts can make your bad data even less consumable than it was on its own.

While combining data from multiple systems can generate huge insights, it is important to understand that moving it and combining it with data from other systems will not always increase its value.

With good quality data you can have fantastic results, but bad quality data requires so much effort and transformation that often your payback on doing the integration will be non-existent.

Data integration enthusiasm

So what happens when an enterprise hears its stomach rumble, and starts thinking data pizza?

Enthusiastic analysts spring into action, building various mockups of all the fantastic dashboards that they will be able to produce, once the data integration is done. Terms like “near-real time, balanced, cross-functional score cards” start to get bounced around, and pretty soon, budget proposals and appropriation requests are flying from color printers everywhere.

Whats unfortunate in many cases is that cooler heads don’t stop to ask the question- “So… all this data we are going to put together, is it any good?”

When you are making your pizza, you have to know if the cheese has been left out a bit too long or the green pepper is soggy.

What can be worse, is that if heroic measures are taken to try to get the data to fit together, the integration jobs themselves might actually degrade the data quality further- or eliminate levels of detail that are not compatible, actually hiding important trends and structures. A risk of integrated dashboards is that they pander to the lowest common denominator.

So if you are planning to do some data integration, to build a data pizza, think twice about putting that moldy pepperoni from the CRM system on it- sometimes less is more.

In fact, it might be that data integration is not your first concern- improving the quality of the data in all those data silos will actually improve day to day operations immediately- and make any future data integration project cheaper, and more successful.

Any great chef will tell you- no matter how complex the recipe, and how impressive your kitchen and equipment, the raw ingredients matter.