Data Quality Check

During MDM assessments, Data Quality plays an important role and gives an indication on what type of tool that needs to be recommended. One of the steps during data quality analysis is to check the data with respect to the standards being followed by the company. Let us consider an example of checking the vendor master to ensure that all the telephone numbers follow the standard xxx xxx xxxx. It would be an herculean task to do this manually and if the data are in the range of millions using excel is not the preferred method. I would suggest to use MS access. From SAP the master is downloaded either in .csv format or .txt format. This inturn is imported into MS Access as a table. Please see the screen shot below.

Once we have the table, create forms. A sample form is shown in the screenshot below.

Once the form is designed, VB application is developed. Just right click on the button as you see in the form above and build an event. A sample code is shown below.

Private Sub Disp_NonCapital_records_Click()
On Error GoTo Err_Disp_NonCapital_records_Click

    Dim stDocName As String

    ‘ Check for lower case text in the records
    Module1.StartCapCompare

‘ Display all records containing lower case texts
    stDocName = “Qry_capitalvalidation”
    DoCmd.OpenQuery stDocName, acNormal, acReadOnly

Exit_Disp_NonCapital_records_Click:
    Exit Sub

Err_Disp_NonCapital_records_Click:
    MsgBox Err.Description
    Resume Exit_Disp_NonCapital_records_Click

Once the application is developed, the results can be seen by pressing the button against the quality parameter. 

    The non-conformance data can also be shown. My point of view is that, the above methodology could be used in the absence of any MDM tools and this Access tool could you used for any type of quality parameter and also for analyzing more than million records. However I would request the readers to take their best judgment.