Systems and methods for assessing data quality

1. A quality assessment (QA) computing device for assessing data quality of one or more data records identified by predefined metadata, the QA computing device comprising one or more processors, an assessment engine, and a data warehouse, the QA computing device configured to:

retrieve the one or more data records from the data warehouse, wherein each of the one or more data records includes one or more data fields;

create one or more views of a staging table, wherein the one or more views include the one or more data records;

generate, by the assessment engine, predefined data quality assessment criteria from the predefined metadata;

assess, by the assessment engine, the data quality of the one or more data fields by applying the predefined data quality assessment criteria; and

assign, by the assessment engine, a data quality value to at least one of the one or more data fields based on the assessed data quality.

2. The QA computing device of claim 1 further configured to

generate the staging table including the one or more data records.

3. The QA computing device of claim 1 further configured to assess the data quality of the one or more data fields by performing at least one of (i) applying in parallel at least two assessment criteria to a single data record stored within the staging table, and (ii) independently assessing in parallel at least two data records stored within the staging table, thereby reducing an overall processing time of the QA computing device.

4. The QA computing device of claim 1 , wherein the one or more views of the staging table are created using a join clause with reference model data.

5. The QA computing device of claim 1 further configured to retrieve a source table including the one or more data records.

6. The QA computing device of claim 1 , wherein the predefined metadata identifies points to be awarded based on a scoring of the one or more data records.

7. The QA computing device of claim 1 further configured to aggregate data quality values assigned to a first data field of each of the one or more data fields to determine a total data quality assessment score for the first data field.

8. A computer-implemented method for assessing data quality of one or more data records identified by predefined metadata, the method implemented by a quality assessment (QA) computing device including one or more processors, an assessment engine, and a data warehouse, the method comprising:

retrieving the one or more data records from the data warehouse, wherein each of the one or more data records includes one or more data fields;

creating one or more views of a staging table, wherein the one or more views include the one or more data records;

generating, by the assessment engine, predefined data quality assessment criteria from the predefined metadata;

assessing, by the assessment engine, the data quality of the one or more data fields by applying the predefined data quality assessment criteria; and

assigning, by the assessment engine, a data quality value to at least one of the one or more data fields based on the assessed data quality.

9. The method of claim 8 further comprising

generating the staging table including the one or more data records.

10. The method of claim 8 further comprising assessing the data quality of the one or more data fields by performing at least one of (i) applying in parallel at least two assessment criteria to a single data record stored within the staging table, and (ii) independently assessing in parallel at least two data records stored within the staging table, thereby reducing an overall processing time of the QA computing device.

11. The method of claim 8 , wherein the one or more views of the staging table are created using a join clause with reference model data.

12. The method of claim 8 , wherein retrieving the one or more data records comprises a source table including the one or more data records.

13. The method of claim 8 , wherein the predefined metadata identifies points to be awarded based on a scoring of the one or more data records.

14. The method of claim 8 further comprising aggregating data quality values assigned to a first data field of each of the one or more data fields to determine a total data quality assessment score for the first data field.

15. A non-transitory computer readable storage media having computer-executable instructions embodied thereon, when executed by at least one processor, the computer-executable instructions cause the at least one processor to:

retrieve one or more data records from a data warehouse, wherein the one or more data records are identified by predefined metadata, and wherein each of the one or more data records includes one or more data fields;

create one or more views of a staging table, wherein the one or more views include the one or more data records;

generate, by an assessment engine, predefined data quality assessment criteria from the predefined metadata;

assess, by the assessment engine, data quality of the one or more data fields by applying the predefined data quality assessment criteria; and

assign, by the assessment engine, a data quality value to at least one of the one or more data fields based on the assessed data quality.

16. The computer-readable storage media in accordance with claim 15 , wherein the computer-executable instructions further cause the at least one processor to

generate the staging table including the one or more data records.

17. The computer-readable storage media in accordance with claim 15 , wherein the computer-executable instructions further cause the at least one processor to assess the data quality of the one or more data fields by performing at least one of (i) applying in parallel at least two assessment criteria to a single data record stored within the staging table, and (ii) independently assessing in parallel at least two data records stored within the staging table.

18. The computer-readable storage media in accordance with claim 15 , wherein the one or more views of the staging table are created using a join clause with reference model data.

19. The computer-readable storage media in accordance with claim 15 , wherein the computer-executable instructions further cause the at least one processor to retrieve a source table including the one or more data records.

20. The computer-readable storage media in accordance with claim 15 , wherein the predefined metadata identifies points to be awarded based on a scoring of the one or more data records.