Data Exploration & Cleansing

Which of the following data types would you select in Power Query for the column which contains to the minute the moment an employee clocks into and out of a building, "Clock In"

• Duration

• Whole Number

• Date

• Date / Time

You notice one of your columns appears to contain spaces in the front and back of some of the text in the fields, which function would be best to remove these spaces ?

• Split by delimiter "Space"

• Remove Duplicates

• Trim

• Find "Space" Replace with ""

You have a column which you think contains all whole numbers, what should you do to manage the data type for that column ?

• Change the type to Whole Number

• Change the type to fixed decimal number

• View the profile of the column to identify all fields and select the correct data type.

• Change the data type to whole number then filter out any errors you find

How can you ensure that a table that contains an individual column in Power Query only contains unique values in that column?

• Use the 'Remove Errors' feature

• Use the 'Remove Duplicates' feature on that particular column

• Change the column data type to 'Text' then filter out the duplicates

• "Group by" the columns and filter those that contain other than 1

What is the difference between referencing and duplicating a query ?

• There is no difference they are both the same

• Duplicate will duplicate the code of the query while Reference will only refer the result of the query.

• Reference will duplicate the code of the query while duplicate will only refer the result of the query

• The duplicate function can be used more than once, reference can only be used once.

If you have 2 tables with the same column names and you want them to be one complete table which function is the correct one

• Append Queries

• Merge Queries

• Fill Down

• Pivot

When merging tables together, in order to match values from one table to another as close as possible, you can use and modify the settings of ______Logic ?

• Furry

• Fuzzy

• Funny

• Funky

You have imported a data table with 12 different columns, looking at your logical model you realise you only need to keep the first 3 columns, which of the following methods could you use (Select All That Apply)

• Select columns you want to keep (right click, remove other columns)

• Select columns you want to keep (right click, remove columns)

• Select columns you want to remove (right click, remove columns)

• From the menu select remove top rows (select 3 as the number to remove )