Power Query Fundamentals

Power Query

Reorder

Reorder the following

• Get data

• Transform

• Load

1

2

3

• 1
• 2
• 3

Multiple Choice

Which of the following is NOT a feature of Power Query?

• Filtering data

• Merging tables

• Creating pivot tables

• Removing duplicates

Match

Match the following

• Combine two or more tables based on a common column

• Separate a column into multiple columns based on a delimiter

• Eliminate repeated entries from a dataset

• Delete selected rows from a dataset based on criteria

• Filter out unwanted data based on specific conditions

Merge Queries

Split Column

Remove Duplicates

Remove Rows

Filter Rows

• Merge Queries

• Split Column

• Remove Duplicates

• Remove Rows

• Filter Rows

Multiple Choice

The Transform feature in Power Query will create (add) a new column to your dataset and will not replace the original data.

• TRUE

• FALSE