Power BI

A collection of ready-made visuals, pre-arranged in dashboards and reports is called what in Power BI? - The canvas - Scheduled Refresh - An app

An App

What happens if you update content that's part of an app you already published?

Anyone who has connected to your app will receive a message and they can decide whether to accept the changes or keep the older version

What is AppSource

AppSource is the place for apps, add-ins, and extensions for your Microsoft software. AppSource connects millions of users of products such as Microsoft 365, Azure, Dynamics 365, Cortana, and Power BI, to solutions that help them get work done more efficiently and insightfully than before.

If your months were sorted alphabetically, how could you sort them by month order? - Click the Edit Queries button - Add a slicer to your visual - Change the visualization type - Apply the MonthNo category sort option

Apply the MonthNo category sort option

PowerBI is built on

Azure

Why would a table show the same value, like "Sales", for every country? - Because the Revenue data is corrupted - Because the column is assigned with the wrong data type - Because there is no relationship between the Sales and Country fields. - Because the column is sorted incorrectly Check your answers

Because there is no relationship between the Sales and Country fields.

What is the common flow of activity in Power BI? - Create a report in Power BI mobile, share it to the Power BI Desktop, view and interact in the Power BI service. -Create a report in the Power BI service, share it to Power BI mobile, interact with it in Power BI Desktop. -Bring data into Power BI Desktop and create a report, share it to the Power BI service, view and interact with reports and dashboards in the service and Power BI mobile. -Bring data into Power BI mobile, create a report, then share it to Power BI Desktop.

Bring data into Power BI Desktop and create a report, share it to the Power BI service, view and interact with reports and dashboards in the service and Power BI mobile.

Calculated Tables

Calculated tables store data in the model instead of in an external source or being calculated on the fly.

What is one method for creating a visual? - Drag a field from the Fields list onto the Visualizations pane -Drag a field from the Fields list onto the Model view canvas -Drag a field from the Fields list onto the Report view canvas -Drag a field from the Fields list onto the Data view canvas

Drag a field from the Fields list onto the report view canvas

In Power BI, what does the "Publish" button do?

Packaging your report and data on Power BI Desktop and sending them to the Power BI service.

How could you gather, arrange, and share interesting Power BI visuals from several different sources?

Pin them to a Power BI dashboard

Which tool would you use to extract the day of the week from a set of dates? - Navigator View -Power Query Editor -New Measure -New Parameter

Power Query Editor

If you were very satisfied with the appearance of a page and wanted the next page to look the same, what would be the best method? - Export the report to PDF and then import the PDF with a different name -Right-click the report page tab and select "Duplicate Page" - Publish the report to a different location - Use the "New Quick Measure" feature

Right-click the report page tab and select "Duplicate Page"

What is the best way to import tabular data from a website into Power BI? -Download data from the website and then import to Power BI -Transfer data from the website to OneDrive and then import to Power BI -Select Get Data and point to the URL -Use the Query Editor to find and edit the web-based data Check your answers

Select Get Data and point to the URL

How do you get Power BI Desktop to find relationships in data after it has been imported? -Open the Power Query Editor - Select Manage Relationships and then Autodetect - Select the New Parameter button to map the relationship - Use the Performance Manager

Select Manage Relationships and then Autodetect

You want your report readers to be able to view your bar chart visual for any year that they choose. What tool could you use?

Slicer

What is the purpose of a "workspace" in Power BI?

To define a set of colleagues who have access to specific dashboards, reports, and data.

How can you get Power BI to spot outliers and trends in your data?

Use Quick insights

How do you create intermediate calculations and data that you want stored as part of the model rather than as part of a query? - Use a calculated table - Select the Enter Data button - Select the New Measure button - Select the New Parameter button

Use a calculated table

If you think of some interesting questions to ask in your report, how could you share them to help your Q&A users?

Use the "Featured Q&A questions" feature

Which of the following are building blocks of Power BI? - Tiles, dashboards, databases, mobile devices - Visualizations, datasets, reports, dashboards, tiles -Visual Studio, C#, and JSON files.

Visualizations, datasets, reports, dashboards, tiles

How do you get Power BI to separate date data into year, quarter, month, and day? - Open the Query Editor - Select the New Parameter button - Select the New Measure button - You don't need to do anything, it is automatic.

You don't need to do anything, it is automatic.

Which scenario would be a good case for using bubble maps? - You want to see months with the highest sales by country. - You want to see the types of products sold in each country. - You want to see sales by age group. - You want to see total revenue by country.

You want to see total revenue by country.

What is Workspace?

are used to collaborate and share content with colleagues. You can add colleagues to your workspaces and collaborate on dashboards, reports, and datasets. With one exception, all workspace members need Power BI Pro licenses.

Transpose Data

flips organization of data from columns to rows

Data Modeling is also called

power pivot

What is My Workspace?

the personal workspace for any Power BI customer to work with your own content. Only you have access to your My workspace. You can share dashboards and reports from your My Workspace. If you want to collaborate on dashboards and reports, or create an app, then you want to work in a workspace.