Data Loading & Visualization in Power BI: Getting Started

 

Question:

When you are working with Power BI, what is the object that displays all your visualizations and charts known as?

• Report

Question

:

You have set up a Power BI workflow and would like to save it to your file system so that your data transformations are backed up. Which file format will this report be saved in?

• .pbix

Question

:

You have performed a merge column operation on your data in Power BI. What is the power query function used for this operation?

• Table.CombineColumns

Question

:

You would like to view the total number of rows in your #Changed Types data. Which M-language command can you use for this?

• RowCount = Table.RowCount(#"Changed Types")

Question

:

This is a bar chart visualizing the sales in rupees of different categories of women’s clothing. Based on this chart, which category has the highest total rupee sales?

Set

Question

:

You have a table where you have performed some Power BI transformations, the latest of which is Changed Type. You would like to add a transformation where you take in the table output by Changed Type and rename the Country column to Nation. What will be the Power Query function for this transformation?

• Table.RenameColumns(#"Changed Type", {{"Country", "Nation"}})

Question

:

Please select the statement which is most applicable to Microsoft Power BI.

Answer C.

• A Microsoft service that provides easy and intuitive interactive visualizations and business intelligence

Categories: Power BI