Garbage in, garbage out

The business value of any data driven project depends on the quality of the data.  How good is your quality?  Mariner's data profiling validates assumptions on how easily the source data can be placed in your data warehouse or data mart.  The goal of data profiling is to stop and search everything that "doesn’t belong" in the business intelligence or reporting database.  Data profiling measures the frequency of occurances of issues including:

• Frequent examples of control and other non-printable characters
• Code fields with no corresponding description
• Disparate systems that merge into the same dimension
• The same master data appearing multiple times in the same table
• Frequent orphan and widow situations between related tables
• Erratic and unexpected ‘gaps’ in snapshot type audit trails
• Frequent back-dating of transactions
• Frequent ‘stuck’ or abandoned transactions

Each data profiling engagement delivers a custom report and Mariner expert analysis.