Quiz: Preparing Data For Analysis in Power BI

This quiz will test your understanding about Preparing Data For Analysis in Power BI. Please answer the following 5 questions.

Quiz Summary

0 of 5 Questions completed

Questions:

You have already completed the quiz before. Hence you can not start it again.

Quiz is loading…

You must sign in or sign up to start the quiz.

You must first complete the following:

Results

Quiz complete. Results are being recorded.

Results

0 of 5 Questions answered correctly

You have reached 0 of 0 point(s), (0)

Current
Review
Answered
Correct
Incorrect

Question 1 of 5

1. Question
What is PowerQuery?
- an add-in you download and install to transform data in PowerQuery
- a built-in tool within Power BI to perform all kinds of transformations to your data
- a built-in tool within Excel only to perform all kinds of transformations to your data
- a built-in tool within Power BI to analyze and create reports
Correct

Incorrect
Question 2 of 5

2. Question
Data profiling in PowerBI allows to… (select all that apply)
- add a calculated column with the M language
- look at underlying data structure of you dataset
- identify outliers and anomalies in your dat
Correct

Incorrect
Question 3 of 5

3. Question
What are some examples of transformations possible in PowerQuery? (select all that apply)
- Remove duplicates, split or merge columns
- Convert data types, calculate birthdate from age.
- Move headers into first rows (and vice versa), transpose tables, (un)pivot columns
- Change visuals (e.g. from table matrix to trend line), convert data types
Correct

Incorrect
Question 4 of 5

4. Question
Select the most appropriate use case when you would need to use the M language to create a calculated column?
- when you have to create a column based on a simple formula
- when you need to create a column based on another dataset
- when you have to create a column that necessitates complicated nested if or case statements
- when the column you need to create is based on 1 other column
Correct

Incorrect
Question 5 of 5

5. Question
What does the Merge Queries PowerBI feature allow you to do? (select all that apply)
- Merge Queries' allows to join datasets together based on a common column and choose the type of join to create (inner, left, right, full)
- Merge Queries' allows to join datasets together based on a common column but you can only join by commoon values (inner join). Other types of join are possible with other PowerBI functions but not 'Merge Queries'
- Merge Queries' allows to append datasets together
- Merge Queries' is a no code interface similar to the 4 inner/left/right/full joins in SQL
Correct

Incorrect

The Data Analyst Toolkit

Quiz Summary

Information

Results

Results

Categories

1. Question

2. Question

3. Question

4. Question

5. Question