Get startedGet started for free

Data profile conclusions

You have been working with the Customer dataset and are ready to move on to using the new Financial Account dataset. As this is a new dataset, you run a data profile to better understand the fields before using it.

Financial Account Date Profile:

  • 10,990 total records
  • AccountID is populated for all records and is identified as the Primary Key for the table.
  • AccountID min value is '100000000001' and max value is '100928473899'.
  • AccountStatus is 75% null, 10% Open, 5% Closed, 10% other various values.
  • AccountStatusDate is populated 95% of the time when an AccountStatus is populated.
  • AccountStatusDate is formatted as MM/DD/YYYY 90% of the time and DD/MM/YYYY 10% of the time.

This exercise is part of the course

Introduction to Data Quality

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise