I will be posting points regarding database quality over the next few months. The first step I will be discussing is setting up a framework to report your current level of quality - a content audit of each step our data takes between entering and when the end user consumes it.
REPORTING ON THE BASE DATA
REVIEWING OUR TABLES
Before we get to building the actual reports, we need to understand what our data is and how it flows. Each table should be examined and noted as to how data populates the table - bulk inserts, inserts with updates, daily updates. How does it get updated, how often it gets updated. Are there any rules that alter the data? Is the data consumed by an application?
WHICH REPORTS TO CONCENTRATE ON?
Prioritize the tables based on application consumption, volatility and business importance.