Table analyses

The sequence of profiling data in one or multiple tables may involve the following steps:

1. Defining one or more tables on which to carry out data profiling processes that will define the content, structure, and quality of the data included in the table.
2. Creating SQL business rules based on WHERE clauses and add them as indicators to table analyses.
3. Creating column functional dependencies analyses to detect anomalies in the column dependencies of the defined table through defining columns as either "determinant" or "dependent".
4. Generating reports from these analyses and share the results among team members. These reports allow to compare current and historical statistics to determine the improvement or degradation of data. For more information on managing reports, see Reports.