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
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
