The Seven Deadly Sins Of Enterprise Data Quality

Atchison Frazer looks at the issues that can lead to problems with data quality

Enterprise data quality problems can be categorised into three main areas:

All these complex processes are an important part of data processing and therefore cannot be cut off in an effort to avoid problems. The only way to maintain the integrity of data is to make certain that all these processes work as intended and avoiding the seven major causes of data quality problems.

Most of the time, databases begin with the conversion of data from a pre-existing source. Data conversion never goes as seamlessly as intended. Some parts of the original datasets fail to convert to the new database, while other datasets just mutate during the process. The source itself could also not be all that perfect to begin with. To avoid problems, more time must be spent on profiling the data, as compared to time spent on code transformation algorithms.

When combining old systems with new ones or phasing out systems, data consolidation is crucial.  Problems may arise, especially when unplanned – resulting in hastened system consolidations.

Batch feeds are large data exchanges that happen between systems on a regular basis. Each batch feed carries large volumes of data and if bottlenecks occur, this can cause problems for consequent feeds. This can be avoided by using a tool to detect process errors and stop them from causing performance problems.

Real-time interfaces are used to exchange data between systems.;

 

Share it:
Share it:

[Social9_Share class=”s9-widget-wrapper”]

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

You Might Be Interested In

Machine Learning And Privacy: A Problem?

19 Sep, 2016

Since the dawn of big data, privacy concerns have overshadowed every advancement and every new algorithm. This is the same …

Read more

Data Science vs. BI vs Statistics: What’s the Difference?

25 Dec, 2016

The use of statistics in business can be traced back hundreds of years.   As early as 744 AD, statistics were …

Read more

Under pressure: 4 main stressors for big data leaders

22 Jan, 2017

CEOs and corporate boards want to see big data deliver results in company revenues, operations, and financial performance. The C-suite’s …

Read more

Do You Want to Share Your Story?

Bring your insights on Data, Visualization, Innovation or Business Agility to our community. Let them learn from your experience.

Get the 3 STEPS

To Drive Analytics Adoption
And manage change

3-steps-to-drive-analytics-adoption

Get Access to Event Discounts

Switch your 7wData account from Subscriber to Event Discount Member by clicking the button below and get access to event discounts. Learn & Grow together with us in a more profitable way!

Get Access to Event Discounts

Create a 7wData account and get access to event discounts. Learn & Grow together with us in a more profitable way!

Don't miss Out!

Stay in touch and receive in depth articles, guides, news & commentary of all things data.