Lesson 3- PowerBI

What is a recommended process for working with Power BI Desktop and Power BI Pro?

"Create your work in Power BI Desktop, and then upload the file to Power BI Pro.

You are interested in joining data tables to show inflation rate by country within specified geographic regions. In order to join the tables, what must you have?

"There must be a unique ID for each country in the Region key.

How would you create a date table in Power BI for mortgage loan calculations, rather than loan periods that will use dates as the pivot coordinates?

"Use the formula GENERATESERIES(DATE(start year, start month, start day), DATE(end year, end month, end date)).

A free subscription to Power BI Pro lasts for how many days?

60

What must be included when publishing an app? (choose one or more) A. Dataset B. Dashboard(s) C. Report(s) D. Owner's profile photo

A

What is the primary difference between creating a new workspace in Power BI vs a classic workspace?

A new workspace does not automatically generate an Office 365 group.

Which choices are valid ways to create a dashboard? A. Go to Dashboards and select Create B. Create a dashboard from existing content C. Select New Dashboard from a SharePoint list D. Create a dashboard using visualizations from a report

A, B, D

You use Add a Tile to add content that doesn't come from Power BI. Using Add a Tile you can add text boxes, streaming content, and what else? (choose more than one) A. Images from the web B. Images from your computer C. Video from YouTube D. Web content for which you have a URL

A, C, D

Apps for the Power Platform are available from where?

AppSource

Why would you pin a live report page to a dashboard? (choose more than one) A. to force users to access the dashboard through the report B. to allow users to cross-filter the visualizations as they would in the report C. so the visualizations will automatically update when the report updates D. so that filters added to the report are propagated to the dashboard

B, C, D

What do you need to consider if you use the BLANK function in Power BI?

BLANK will also pick up values of zero.

The data you imported has dates in the format, DailySales_1.1.2020. If you want the dates in your column to display as date only, what should you do?

Create a custom _ delimiter in Sort Column by Delimiter, which will leave only what is after the underscore.

How can a dashboard creator make a dashboard easier to view on a mobile phone?

Create a phone view for the dashboard.

You have a pivot table of three measures, with Measure 3 being the sum of Measures 1 and 2. Which statement is accurate about the way DAX measure logic will deal with them?

DAX will calculate Measure 3 independently of the other two measures.

When you are creating conditional formulas, what is the only component in the formula that can have multiple conditions?

Else if

What happens if you are not logged in to Facebook and try to connect to public information there?

Facebook requires you to log in first.

What is an additional step a user must take in order to bring in data directly from a file that was not created in Excel, a CSV file, or Power BI desktop?

Get the data into Excel, a CSV or Power BI desktop model.

How can a user find out who has access to a report or dashboard?

Go to their workspace, click the Share button and choose Access.

Which statement is true regarding the Power BI Desktop sign-in step?

Microsoft offers a trial period to use Power BI Pro features.

Which option or options are available as a choice in the app workspace?

OneDrive Business

How can a user keep a visual generated as a result of a Power BI Q&A session?

Pin it to their dashboard.

Use _____ to display your Power BI report in presentation mode with live filtering.

Power BI app for Windows 10

https://docs.microsoft.com/en-us/powerquery-m/

Power Query M Formula Language

Why is importing a PDF's data into Power BI considered a "hack" method?

Power Query does not directly support uploading PDFs, so you can instead open it as a Word document and save it as an HTML file.

What can you NOT do from the Power BI mobile app?

Remove a tile from a dashboard.

When you are transposing data tables, what do you need to do with promoted headers?

Remove them, perform the Transpose function, and then promote the headers again.

What is an easy way to have Power BI keep a user up to date on the status of critical values in their dashboards?

Set alerts.

Which is true regarding publishing to the web?

Some items, like Arc GIS visualizations, cannot be published

When connecting to a data source in Power BI, _____ is found under the Databases category and _____ is found under Online Services.

Sybase; GitHub

How is previewing a CSV file before loading it different than previewing an Excel file?

The CSV preview allows controlling the data type detection.

When connecting Power BI Desktop to a web data source pointing to a webpage with multiple tables, what can you preview?

You can preview all tables individually.

In order to share within their organization, a user needs at least _____.

a Power BI Pro license

What is generated when you click "Publish"?

a link that can be sent in email, and an HTML link that can be pasted into a blog or website

What is Power BI?

a self-service business intelligence solution

When can a user create a mobile view?

after they've pinned a tile to the dashboard

How can a user view their uploaded data immediately in Power BI?

by clicking "View Dataset"

How can a user create a refreshable data source?

by storing their file in the cloud

Reports in Power BI _____.

can include funnel charts, tree maps, geospatial maps and a variety of different visualizations

You've loaded a sample dataset that includes reports and dashboards. If you later delete the sample dataset, Power BI will also _____.

delete the reports and dashboards

If a user wishes to subscribe another user to a dashboard or report, what do they need?

editing permissions to that dashboard/report

Conditional Formula Order

if, Else if, Else. Can have mult Else ifs

When will a user see their default dashboard?

immediately upon opening Power BI

If you want the fastest way of importing data into Power BI, which type of data will you use?

live data

Which two tables, in order, will a DAX CALCULATE formula draw from to connect a loan period table to a dates table?

the data tables, and the pivot coordinates of the dates table

Why would you use the DATEDIFF measure function with mortgage loan pivot table data?

to calculate the difference between two dates, both of which must be measures, by an interval such as months

You are creating formulas to calculate the remaining balance on a mortgage loan. Why would you use a parameter-harvesting function?

to convert a naked loan period column into a measure you can reference

Although efficiency means taking as few steps as possible, why should you first test an SQL query in an application such as Visual Studio.

to make sure the SQL code works

What are the four roles available in Power BI workspaces?

viewers, contributors, members, admins

How can you best describe the DAX Calculate function?

It is a supercharged sum-if function that can calculate counts, products, and other functions.

What is the result of using a GENERATESERIES function when you create a table?

It reduces the potential for human error.

How can a user remove a "favorite" item from their favorites list?

Unmark it on Favorites list.

Why would you use explicit DAX measures rather than implicit measures in Power BI?

When you create pivot tables, implicit measures are often inaccurate.