Exploring common data quality management capabilities of BI tools

In the previous section, we discussed how important BI tools are to finance professionals and organizations. Now, in this section, we will focus on various data quality management capabilities available in most BI tools. Understanding these features in depth will help us choose the right tool when dealing with finance data integrity issues.

Data profiling

Data profiling involves examining, analyzing, and producing insightful summaries of data. We covered the general steps for data profiling in Chapter 3, Measuring the Impact of Data Integrity Issues, in the Data profiling using a data quality framework section.

This typically involves the following steps:

1. Defining the criteria for data quality
2. Gathering and evaluating the data
3. Analyzing data quality
4. Identifying and prioritizing data quality issues
5. Creating a remediation plan
6. Tracking and gauging data quality

Note

We will...