Quiz: Introduction to Business Intelligence

This quiz will test your understanding about Introduction to Business Intelligence. Please answer the following 4 questions.

Quiz Summary

0 of 4 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 4 Questions answered correctly

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

Current
Review
Answered
Correct
Incorrect

Question 1 of 4

1. 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 2 of 4

2. 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
Question 3 of 4

3. Question
You can only pin visuals from reports you created in PowerBI Desktop (select all that apply)
- No, You can pin visuals from different sources, reports from BI Desktop and other visuals in BI Service, such as graphs from an Excel file you uploaded in Service
- You can only pin visuals from reports you created in PowerBI, unless you have the Premium version, in which case you can pin visuals from all difference sources, such as graphs from an Excel file you uploaded in Service Premium subscription
- No, you can use other visuals, such as PivotTables and Graphs from Excel files you uploaded on Service. You don't even have to create visuals in Desktop
- You don't pin visuals to create a dashboard, you just create the visual in the dashboard itself
Correct

Incorrect
Question 4 of 4

4. Question
How to create a dashboard in PowerBI Desktop? (select all that apply)
- You can't create a dashboard in desktop, only reports
- You just create visuals in Desktop and you publish the visuals in BI Service
- In PowerBI Desktop, you pin visuals to a dashboard and then you publish on BI Service
- You can only create dashboards in PowerBI Service
Correct

Incorrect

The Data Analyst Toolkit

Quiz Summary

Information

Results

Results

Categories

1. Question

2. Question

3. Question

4. Question