MulaiMulai sekarang secara gratis

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.

Latihan ini adalah bagian dari kursus

Introduction to Data Quality

Lihat Kursus

Latihan interaktif praktis

Ubah teori menjadi tindakan dengan salah satu latihan interaktif kami.

Mulai berolahraga