Power BI Quizzes

Practice Quizzes
Thanks!
Thanks!

Power BI Quizzes

Accelerate your Career and Get Certified

Prepare the Data

Friday, June 25th, 2021

Welcome to your Prepare the Data for Analysis

True or False: when a table is created from a flat file in Power BI Desktop, the Power Query Editor assumes that the first row of data is the column headers

False

True

Which will make a data table longer (more rows)

Unpivot

Pivot

Two ways to change the data type in Power BI:

Select the data type icon next to the column header and then select the correct data type

Click the arrow next to the column header, select edit metadata, and select the correct data type

Select the column and use the metadata option in the Transform tab and select the correct data type

Select the column and use the data type dropdown in the Transform tab and select the correct data type

Which is more likely to have data type errors

databases

flat files

If a column has values that are misspelled, this option in the Transform tab can help

Find-Replace

Replace Values

Recode

Spell check

When you append queries, you will be

adding rows from one table (or query) into another.

adding columns from one table (or query) into another.

When you merge queries, you will be

adding rows from one table (or query) into another.

adding columns from one table (or query) into another.

Which is similar to a SQL JOIN?

append

merge

This transformation applies aggregation

Remove top rows

Pivot

Unpivot

If you think you might use a column at some point in the future, you should be sure to keep it in the data model so that it is there when you need it.

True

False

When doing a merge, which option will guarantee that all rows are included in the result?

Left Outer

Union

Inner

Full Outer

Shows % of data that is valid, in error, and empty

Column Distribution

Column Quality

Column Statistics

A column contains the following rows:

If we replace nulls with 0, how will the average of Shipping_Cost change?

average(Shipping_Cost) will remain the same

average(Shipping_Cost) will increase

average(Shipping_Cost) will decrease

To edit M code directly

Select the Transform ribbon of Power Query and then select Advanced Editor.

Select the View ribbon of Power Query and then select Advanced Editor.

Select the View ribbon of Power Query and then select M Editor.

Select the Transform ribbon of Power Query and then M Editor.

Power Query creates which type of code?

T-SQL code

DAX

M code

SQL code

Gives an in-depth look at a column's first 1000 values

Value distribution

Column distribution

Column Quality

Column profile

When renaming columns, a best practice is to replace underscores ("_") with

dots (".")

spaces (" ")

capitalizing the first letter of the words, so for example "birth_date" becomes "Birth Date"

dashes ("-")

Time is Up!

Time's up

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Comment

Name *

Email *

Website

Δ

About the Author: Lukas Halim

I earned a Masters in Analytics from NC State in 2013 and now work as a data analyst in the health insurance industry. Using tools such as SAS, Tableau, and Teradata, I conduct analysis to help my company improve healthcare affordability and customer engagement.

Learn More

4.6 Instructor Rating
53,604 Students

14,612 Reviews
2 courses

© Learning Tableau. All rights reserved.
Privacy Policy | Design by Liscio Apps, LLC