1. Power BI Flashcards
PL-900 questions on Power BI
You edit a Power BI report.
You need to add a calculated column.
Which two actions should you perform?
Open the report using Power BI Desktop.
; Select the Data tab and then select New column.
You need to identify the capabilities of the Power BI service compared to Power BI Desktop.
Which two features are only available in the Power BI service?
Dashboards
; Workspaces
A company plans to hold a meeting with investors to discuss customers.
The company needs to present last year’s revenue and customer acquisitions in this meeting.
You need to create a Power BI report.
Would a map visualisation be appropriate?
Yes
A company plans to hold a meeting with investors to discuss customers.
The company needs to present last year’s revenue and customer acquisitions in this meeting.
You need to create a Power BI report.
Would a line chart be an appropriate visualisation to use?
Yes
A company plans to hold a meeting with investors to discuss customers.
The company needs to present last year’s revenue and customer acquisitions in this meeting.
You need to create a Power BI report.
Which two visualizations should you use?
Map
; Line chart
A company uses Power BI.
You need to aggregate a text field by adding it to a visual in a Power BI report.
Which aggregation should you use?
Count
You create Power BI reports by using Power BI Desktop.
You need to create a relationship between the two tables in Power BI Desktop.
Which view would you use? (Give both possible answers).
Model view and Table view
You need to create a Power BI dashboard for Power BI mobile apps.
What should you do in order to see how the dashboard would look on a mobile?
Click on ‘mobile view’.
A company uses Power BI.
You need to collaborate with others to build visualizations.
What should you use?
Workspace
You plan to build a Power BI report for a sales team.
You need to display the sales revenue for the top fifteen product categories.
Which chart type should you use?
Bar
A company uses Power BI. You create a Power BI report and publish it to the Power BI service.
You need to create a dashboard containing tiles for individual visualizations.
What are two possible ways to achieve this goal?
Pin a visualization.
; Use the Q&A question box.
Which two components are available in Power BI Destop but not in Power BI Service?
Shaping and modeling data
; Calculated columns
You plan to create a Power BI report to display a company’s sales data.
The sales team has prebuilt reports in Power BI that contain sales data.
You need to recommend a solution that allows users to reuse the same dataset to build their own reports and dashboards.
What should you recommend?
Share the dataset containing sales data.
You have a table in a Power BI dataset. You add a clustered column chart visual to the report page.
You need to show the count of rows in the table as columns for each category in the table.
Which field well should you add to the row count measure?
Y-axis
You need to create a Power BI visualization that displays month-by-month revenue comparisons for the current and previous years.
Which chart type should you use?
Bar
A tire manufacturer stores manufacturing data in SQL Server and sales data in Microsoft Dataverse tables.
An operations manager needs to view a single page of information each day that shows the following:
The number of defects in the manufacturing process.
The sales by geographic region from the prior day.
You need to configure Power BI.
Which action should you perform?
Create a Power BI Dashboard by using the Power BI service.