Power BI Quiz 1

Which one is incorrect?

• Pie charts show the relationship of parts to a whole.

• Donut charts show the relationship of parts to a whole.

• Line charts are the standard for looking at specific value across different categories.

• Waterfall charts show a running total as values are added or subtracted.

Which one is correct about slicer?

• Slicer is one of charts that based on the line chart.

• Slicer displays progress toward a measurable goal.

• Slicer applies a sorting order to the visuals

• Slicer provide cues to ways you can filter the results in the visuals on a report page.

Initially on POWER BI, dataset cannot be created from…

• Website table

• Online results of marketing campaign

• Excel table

• Online advertising banners on website

What is this symbol called?

• Chart view

• Report view

• Data view

• Dashboard view

Combining multiple columns into a single column in clean data enhances...

• Data integrity

• Data transformations

• Data filtering options

• Data visualization and readability

Removing duplicates from a dataset simplifies data navigation and also enables the use of columns in:

• Aggregations and calculations

• Slicers and filters

• Data visualization

• Data transformation

When using the Left Outer join option in Power Query, the resulting merged table will have:

• All rows from the first table and only the matching rows from the second table

• All rows from both tables

• Only the matched rows between the two tables

• Only the unmatched rows from the first table

What is a characteristic of a flat file?

• It contains hierarchies

• It has multiple data tables

• Every row of data is in the same structure

• It can only be stored on a local computer

Which of the following is NOT a common type of flat file?

• CSV file

• Delimited text file

• Fixed width file

• XML file

What is the purpose of a tile in Power BI?

• To provide context and insights from raw numbers or text

• To filter and combine data from different sources

• To create visually complex visualizations

• To hold an individual visual on a dashboard