1. Power BI Flashcards
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.
You need to use Power BI to build a report for a sales manager.
The report must meet the following requirements:
A single-entry point to view data.
A way to drill down into data from a single table, named Sales, in your company’s SQL Server database.
One page that shows sales by date and another page that shows sales by region. Each page should allow users to view the raw data from the Sales table as well as view a bar graph representing the information.
Which two actions should you perform?
Create a Power BI report tied to the Sales table.
; Create one report with two pages for sales by date and sales by region.
A company manufactures car parts. Some parts are defective.
You create a Power BI report to visually represent defect information.
You need to add a single visualization to the report to show the percentage of defects per part.
Which two visualizations should you use?
Donut chart
; Column combo chart
A company uses GitHub repositories for source code control.
The company plans to create visualizations in Power BI to analyze repository usage including commits and pull requests.
You need to create reports for repository usage.
What should you do?
Install a template app in the Power BI service.
You create a Power BI report.
You need to share the report with internal users.
Which two actions should you perform?
Embed the report in a secure portal.
; Use the Power BI mobile app.
You build a Power BI report by using Power BI Desktop. The data is based on a complex set of data that includes multiple data tables that have many-to-one relationships with each other.
You need to visually represent the tables and their relationships so that you can understand the data you are working with before you build the report.
What should you do?
Click on the Modeling view and examine the diagram of available tables and their relationships with each other.
You create a Power BI report to display information about product sales using Power BI Desktop. You have two Excel spreadsheets named Data1.xlsx and Data2.xlsx.
Data1.xlsx has a table called Table 1. Table 1 has two columns of information:
Product name
Units sold
Data2.xlsx has a table called Table 2. Table 2 has two columns of information:
Toy name
Number sold
You need to combine the data into a single dataset that can be used in the report by using Power Query Editor. The data set must contain the headers Product name and Units sold.
Which two actions should you take?
Rename the columns in Table 2 to Product name and Units sold.
; Append the data from Table 1 to the data in Table 2.
A company stores data in different systems: SQL Server, csv file, Excel workbook.
You need to show the data by using Power BI.
Which of the three data sources can Power BI connect to?
SQL Server
; CSV file
; Excel workbook
You need to install and configure prebuilt Power BI dashboards and reports.
Which two actions should you perform?
Find a Power BI template app in the Power BI Apps marketplace and install it.
; Connect the app to the data.
What is the correct order of operations that a Power BI user will take to use the service effectively?
- Get data 2. Create report 3. Create dashboard 4. Create app 5. Share
What is the appropriate Power BI Service feature for the following task.
Task
Display data from an Excel workbook with multiple worksheets
Report
What is the appropriate Power BI Service feature for the following task.
Task
Display top departmental goal metrics and alert users when certain thresholds are crossed
Dashboard
Name three components of Power BI
Power BI Desktop, Power BI Service, Power BI Mobile
Where can comments be added in Power BI?
Power BI visuals, reports, dashboards; on the Power BI Service or on the mobile app
Which of the following is NOT a valid Power BI Aggregate function? Count, Median, Rank
Rank
Name 5 Power BI Aggregate functions
Count, Count (distinct), Sum, Average, Median
Name four capabilities that are available on Power BI Mobile
View a Power BI Report
View a Power BI Dashboard
Comment on a Power BI visualisation
Review other users’ comments on a Power BI visualisation
You are analysing data from multiple different data sources in Power BI. You want to combine data in order to create a unified visualisation. What Power BI component would you use to accomplish your task?
Query Editor
You create and publish a report in Power BI. The report connects to several databases in your organisation. You share the report with some colleagues in your organisation. What permissions will be needed regarding the security of the data?
You will need read permissions to the data; Your colleagues will not need any permissions to the data
A manufacturing company uses Internet of Things (IOT) devices to monitor the temperature in different parts of their warehouse.
You need to view near real time information from the IoT devices in Power BI service dashboards.
Which tool should you use?
Streaming dataset
You need to display sales orders greater than a specific threshold in a Power BI report.
What should you use?
Filter
You are a sales representative. You create a Power BI report to visualize data from a Microsoft Excel workbook.
Users need to be able to view and share the report
Which 2 actions should you perform?
Pin the report to a dashboard; Share the dashboard
Select the appropriate Power BI component for the task: “Create a report”
Power BI Desktop & Power BI Service
Select the appropriate Power BI component for the task at hand: “Configure sharing”
Power BI Service
Select the appropriate Power BI component for the task at hand: “Create calculated columns”
Power BI Desktop
