BenchMark Quizzes by MDFT Pro

Use Data Preview Options To Analyze Data Quality

You are analyzing data quality on a set of data imported with Power Query for MDFT Pro. The dataset contains multiple columns and you want to ensure the data is accurate and reliable.

You need to use the correct Data Preview options to analyze the data. Which Data Preview option should you use for each scenario?

Choose all correct answers from the options below.

Explanations for each answer:

To find the percentage of errors in a column: Column quality is correct. Column quality shows the percentage of valid, error, and empty values in a column.
To find the number of empty rows for all columns: Column distribution is incorrect. Column distribution displays the frequency of distinct and unique values for each column, but it does not show the number of empty rows for all columns. To analyze empty rows, use the Column quality or Column profile options.
To find the number of empty rows for a single column: Column profile is correct. Column profile shows statistics and the distribution of data for a single column, including distinct, unique, and empty rows.
To find the average value for a single column: Column profile is correct. Column profile provides summary statistics for a column, including the average value for numerical columns, as well as count, error, and empty values.

Learn more about data profiling in Power BI:

Power BI Data Profiling

Exam Preparation Quiz

Use Data Preview Options To Analyze Data Quality