Mastering Power Query Data Cleaning

What is the primary purpose of data cleaning in Power Query?

• To automate data entry processes in Power Query.

• To reduce the file size of datasets in Power Query.

• The primary purpose of data cleaning in Power Query is to ensure data accuracy and reliability.

• To enhance data visualization in Power Query.

Which technique is used to remove duplicate rows in Power Query?

• Sort Ascending

• Remove Duplicates

• Group By

• Filter Rows

How can you identify and handle missing values in a dataset using Power Query?

• Missing values can be identified by sorting the dataset in ascending order.

• You can only handle missing values by ignoring them in your analysis.

• You can identify missing values in Power Query by checking for nulls or blanks in columns, and handle them by removing rows or replacing them with specific values.

• Identifying missing values requires using Excel formulas instead of Power Query.

What is the function used to change data types in Power Query?

• Table.ChangeDataType

• Column.TypeTransform

• Table.Transform. data type

• DataType.Convert

How do you filter data to show only specific rows in Power Query?

• Delete all rows except the first one.

• Use the sort function to arrange the data alphabetically.

• Use the filter icon in the column header to select specific values or conditions.

• Export the data to Excel and filter there.

What is the difference between merging and appending queries in Power Query?

• Merging stacks tables by adding rows; appending combines based on a common column.

• Merging adds new columns; appending removes duplicates.

• Merging creates a new table; appending modifies the existing table.

• Merging combines tables based on a common column; appending stacks tables by adding rows.

Which option allows you to replace null values in a column in Power Query?

• Replace Values

• Group By

• Sort Ascending

• Remove Duplicates

What is the significance of the 'Remove Duplicates' feature in data cleaning?

• It adds new entries to the dataset for completeness.

• It formats data into a more readable structure.

• It ensures data accuracy by eliminating redundant entries.

• It increases data redundancy for better analysis.

How can you convert a text column to a date type in Power Query?

• Select the text column, go to 'Transform' > 'Data Type' > 'Date'.

• Select the text column, go to 'Transform' > 'Format' > 'Date'.

• Right-click the column and choose 'Convert to Number'.

• Select the text column, go to 'Home' > 'Data Type' > 'Text'.

What steps would you take to filter out rows based on a specific condition in Power Query?

• Sort the data in ascending order.

• Group the rows by a different column.

• Use the filter icon in the column header to apply a specific condition.

• Delete the entire column with the condition.