Data Cleansing and Simple Business Rules

Blog Administrator | Address Quality, Analyzing Data, Data Cleansing, Data Quality | , , ,

By David Loshin

Having worked as a data quality tool software developer, rules developer, and consultant, I am relatively familiar with some of the idiosyncrasies associated with building an effective business rules set for data standardization and particularly, data cleansing. At first blush, the process seems relatively straightforward: I have a data value in a character string that I believe to be incorrect and I want to use the automated transformative capability of a business rule to correct that incorrect string into a correct one.
Read More

Integrating Analytical Results with Operational Activities

Blog Administrator | Data Enhancement, Data Quality | , , , ,

By David Loshin

We have looked at using enhancement for operational purposes, as well as analytical
purposes, but there are ways that we can merge the two into a hybrid: using
enhanced data for analytics, whose results are incorporated into operational
activities using the same types of enhancements.

Actually I was a bit sneaky in my last few blog entries, because I already
started to plant some ideas in advance of this post.… Read More

How to Enrich Your Data by Extending the Power of SSIS

Blog Administrator | Uncategorized | , , , , ,

Bad data is a challenge for all organizations. Without data that is reliable, accurate and updated, organizations can’t deliver trusted customer, product and other vital data throughout the enterprise – resulting in waste and operational inefficiencies, less effective sales and marketing, poor customer service and potentially bad business decisions.


That’s why many companies choose to incorporate data quality directly into their data integration architecture.Read More