PBI Essentials Final Exam

When would you save and modify a sample report rather than create a new report from scratch?

When the sample report contains most of the visuals you want

When would you use Power BI service rather than Power BI Desktop?

When you are creating dashboards

What data file type can you access only with Power BI Desktop and not Power BI service?

XML

In which situation would you have a higher-value visualization in terms of performing data analysis with a treemap rather than with a pie chart?

You want to look at higher level of detail in a category

Which video types are the only ones you can add to a dashboard as a media tile?

Youtube or vimeo

When you pin a visualization from a report to a dashboard, what does the visualization become?

a tile

You are doing a research project on population changes, and the U.S. Census website has the data you want. Which data type should you download so you have the easiest format to read?

the table

If you build a dashboard using Quick Insights, in which format will the insights appear on your dashboard?

visualizations

As you are working in a workspace on your iPad, you receive a notification. What is the notification about?

A collaborator is sending you a notification about your work together

Your visualization is in the form of a column chart showing annual sales by salesperson. How can you add an additional visualization to the chart to show your company's sales goal for the year?

Add a constant line from the analytics tab

When you imbed a Power BI report in SharePoint Online, what are you actually doing?

Adding a web part by pasting the report link

If you would like to examine some of the free sample datasets, reports, and dashboards in Power BI, where will you find them?

By clicking Get Data

You want to allow users inside your organization to share your dashboard, and to edit your dashboard by adding tiles. How will you do this?

By creating a dashboard in a group.

In order to improve your dataset to get the most use from the Power BI Q&A feature, how should you name the tables in your data?

Choose user-friendly names for your tables

How can you create portable reports?

Create the report in power bi desktop, and then work with it in power bi service

If you upload data to a file stored locally, when does the data refresh?

Data in a file sored locally is not refreshed

You have a filtered dataset for Customer Sales with some null value rows. You want to remove these rows completely. How will you do this?

Deselect (null) in the pull-down menu for customer sales in the power query editor

You have a slicer and a chart on the same page for your sales data by state. If you use the menu to sort by territory in alphabetical order, what effect will that have on the slicer and the chart?

Everything on the page will be sorted alphabetically by territory

Suppose your report is going to be used in a PowerPoint presentation at the national sales meeting. With that in mind, what should be the most important consideration when you are creating your report?

How you are going to group elements on a page

How does using Power BI impact an organization's IT resources?

IT professionals can spend their time providing data to analysts rather than creating reports

How will a gauge visualization provide impressive one-glance information on your company's sales for the year?

It can show how close your sales are to your sales goal

Juan Delgado is an employee in your sales department and Li Park is an outside consultant. If you share a dashboard with both of them, will there be any difference in their Power BI experience?

Li Park will have the interactivity of the dashboard, but she will not have any of the elements on the left.

What feature does Power BI for Mobile have to make sharing Power BI dashboards easier than sharing other types of information with a mobile device?

Power bi mobile can share dashboards via sharing apps directly from the screen

What does the Unpivot feature in a dataset allow you to do?

Retrieve the underlying rows of data from a pivot table

What must you do if you want users to see a tile using a QR code you shared with them?

Share your dashboard with users whom you want to see the title

Which of these is a reason to relate tables in Power BI?

So you can examine relationships between different datasets

Why would you create an app workspace?

So you can have collaboration in creating and sharing data, reports, and dashboards

Why would you add a slicer in a table visualization?

So your users can filter the particular data they are interested in

You are conducting a large meeting in which you want to make a presentation of a report on a screen. How can you do this with the Windows app?

Switch to full screen in the application so you will automatically go into presentation mode, which displays all your visualizations

The dataset you are working in is a PivotTable. What will happen if you select the first column, Sales Region, then you click Unpivot Other Columns?

The other columns will change from a pivotable to rows of data

When you edit interactions, you choose to not have the data filtered. Once you stop editing the interactions, what happens when a user selects an item?

The tables and charts redisplay, but nothing changes

You found a thermometer in the Marketplace that you think will add more value to your visualizations than the gauge you are using. Which values will you have when you add the thermometer?

The values that are included in the thermometer you add from the marketplace

After you created an app workspace, you offered the app to your entire sales department for feedback. Which version of the app will those users see when they access the app?

The version you published, until you or a collaborator choose to update again

If you create an app workspace, how do the collaborators you selected create their own reports and dashboards?

They are created the same way you created them in my workspace

Katrina is an experienced Power BI service user. When would Katrina choose to work in Power BI Desktop instead?

To perform data modeling

You have three tables relating to sales information in various states and various products. Why would you create relationships in Power BI?

To work in one table and not the three separate tables

What will happen if you run Power BI with a display resolution lower than 1440 x 900?

Tools will continue to display but you will not able to see them