PL-300: Microsoft Power BI Data Analyst
You are using existing reports to build a dashboard that will be viewed frequently in portrait mode on mobile phones.
You need to build the dashboard.
Which four actions should you perform in sequence?
When you view dashboards in portrait mode on a phone, you notice the dashboard tiles are laid out one after another, all the same size. In the Power BI service, you can create a customized view of a dashboard, specifically for portrait mode on phones.
Step 1: Open the Dashboard.
Step 2: Change the dashboard view to Phone view
Step 3: Pin items from the reports to the dashboard.
Step 4: Rearrange, resize, or remote items from the Phone view.
Create a phone view of a dashboard
1. In the Power BI service, open a dashboard (Step 1)
2. Select the arrow next to Web view in the upper-right corner > select Phone view. (Step 2)
The phone dashboard edit view opens. Here you can unpin, resize, and rearrange tiles to fit the phone view. The web version of the dashboard doesn't change.
3. Select a tile to drag, resize, or unpin it. You notice the other tiles move out of the way as you drag a tile.
The unpinned tiles go in the Unpinned tiles pane, where they stay unless you add them back.
4. If you change your mind, select Reset tiles to put them back in the size and order they were before.
5. When you're satisfied with the phone dashboard layout, select the arrow next to Phone view in the upper-right corner > select Web view. Power BI saves the phone layout automatically.
Reference:
https://docs.microsoft.com/en-us/power-bi/create-reports/service-create-dashboard-mobile-phone-view
You have the line chart shown in the exhibit.
You need to modify the chart to meet the following requirements:
- Identify months that have order counts above the mean.
- Display the mean monthly order count.
Which three actions should you perform in sequence?
Answer is
1. Select the line chart
2. From the Analytics pane, Add the average line
3. Turn on Data Label for the new line.
Reference:
https://community.powerbi.com/t5/Desktop/Moving-Average/td-p/43041
You have a query named Customer that imports CSV files from a data lake. The query contains 50,000 rows as shown in the exhibit.
Each file contains deltas of any new or modified rows from each load to the data lake. Multiple files can have the same customer ID.
You need to keep only the last modified row for each customer ID.
Which three actions should you perform in sequence?
Answer is;
1. Duplicate the Customer query
2. Group the CustomerGrouped query to find the max modified date
3. Merge the two queries on inner join
You have a Microsoft Power BI workspace.
You need to grant the user capabilities shown in the following table.
The solution must use the principle of least privilege.
Which user role should you assign to each user? To answer, drag the appropriate roles to the correct users. Each role may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
Select and Place:
Box 1: Member
Box 2: Contributor
Reference:
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-new-workspaces
From Power BI service, you publish an app that contains one dashboard and one report. Q&A is enabled on the dashboard.
In Q&A, a user types the query count of clients and fails to receive any results. The user then types the query count of subscribers and receives the expected results.
You need to ensure that the user can use both queries to receive the same results.
Which four actions should you perform in sequence?
Answer is 6-5-3-4
Reference:
https://community.powerbi.com/t5/Desktop/Edit-the-synonyms-from-Power-BI-Services/m-p/700219#M337938
You plan to create a report in Power BI Desktop.
You have the following tables.
You have a measure that uses the following DAX formula.
Total Sales = SUM('Sales'[SalesAmount])
You plan to create a report to display TotalSales by ProductCategory and ProductSubCategory.
You need to create a measure to calculate the percentage of TotalSales for each ProductCategory.
How should you complete the DAX formula?
Answer is
Measure1 = DIVIDE([TotalSales], CALCULATE([TotalSales],
ALL(Sales[ProductCategory], Sales[ProductSubcategory])))
You have a customer table in Power BI Desktop. The customer table contains the columns as shown in the following table.
You need to create a custom column that hides the first three digits of the SSN. The values in the new column must have the xxx-99-9999 format.
How should you complete the Query Editor formula?
Answer is Text.Replace([SSN],Text.Start([SSN],4), "xxx-")
You create a report in Power BI Desktop.
You need to embed the report into a Microsoft SharePoint Online site.
Which three actions should you perform in sequence?
Answer is 5-4-1
Publish your Power BI report to your Power BI account
Get the URL to the report
Add the Power BI (preview) web part to your SharePoint Online page
Paste the URL of the report when prompted
To finish, save and publish your page!
References:
https://powerbi.microsoft.com/en-us/blog/integrate-power-bi-reports-in-sharepoint-online/
You have a Power BI dashboard named DashboardA that contains a tile named TileA. TileA contains a treemap visual from a report named ReportA.
You need to provide the users of DashboardA with additional tiles that relate to the contents of TileA.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place:
Check the answer section
Answer is 1. From DashboardA, select the TilaA options, and then select View Insights
2. From Focus mode, review the generated visuals
3.From Focus mode, pin the relevant visuals to DashboardA
Reference:
https://docs.microsoft.com/en-us/power-bi/create-reports/service-insights
You are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.
During the development process, you need to import a sample of the data from the Order table.
Solution: From Power Query Editor, you import the table and then add a filter step to the query.
Does this meet the goal?
Yes
No
Answer is No
The filter is applied after the data is imported.
Instead add a WHERE clause to the SQL statement.
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial