thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Data & Analytics · Foundational

Data Profiling

Examining data to summarize its structure, content, completeness, distributions, patterns and anomalies before using it.

Definition

Profiling reports null counts, distinct and unique counts, min and max, value frequencies and pattern conformance. Power Query offers Column quality, Column distribution and Column profile, which by default profile only the top 1,000 rows. Dataplex, Purview and Databricks provide automated profiling.

Exam tip

Power Query profiles the top 1,000 rows by default; switch to 'entire data set' for accurate stats.

Related terms