Power Bi class day 5

You have a Microsoft Excel file in a Microsoft OneDrive folder. The file must be imported to a Power BI dataset.

You need to ensure that the dataset can be refreshed in powerbi.com.

Which connector can you use to connect to the file?

• Excel workbook

• Sharepoint folder

• Text/CSV

• Internal folder

For the sales department at your company, you publish a Power BI report that imports data from a Microsoft Excel file located in a Microsoft SharePoint folder. The data model contains several measures. You need to create a Power BI report from the existing data. The solution must minimize development effort.

Which type of data source should you use?

• Excel workbook

• Power BI dataset

• Power BI dataflow

• Sharepoint folder

From Power Query Editor, you attempt to execute a query and receive the error message below.

Datasource.Error: Could not find file.

What could be the possible causes of the error?

• You do not have permissions to the file.

• An incorrect privacy level was used for the data source.

• The file is locked

• The referenced file was moved to a new location.

You build a report to help the sales team understand its performance and the drivers of sales. The team needs to have a single visualization to identify which factors affect success.

Which type of visualization should you use?

• Funnel chart

• Question & Answer

• Line and clustered column chart

• Key influencers

You have a table that contains sales data and approximately 1,000 rows. You need to identify outliers in the table.

Which type of visualization should you use?

• Donut chart

• Pie chart

• Scattered plot

• Area plot

You need to create a visualization that compares revenue and cost over time. Which type of visualization

should you use?

• Stacked area chart

• Donut chart

• Waterfall chart

• Line chart

You have a collection of reports for the HR department of your company. You need to create a visualization for the HR department that shows a historic employee counts and predicts trends during the next six months.

Which type of visualization should you use?

• Line chart

• Ribbon chart

• Key influencers

• Scatter chart

You have a report that contains three pages. One of the pages contains a KPI visualization. You need to filter all the visualizations in the report except for the KPI visualization.

Which one of these actions should you perform?

• Configure a report-level filter

• Edit the interactions of the KPI visualization

• Configure a page-level filter

• Add the same slicer to each page and configure Sync slicers

You open a query in Power Query Editor. You need to identify the percentage of empty values in each column as quickly as possible.

Which Data Preview option should you select?

• Show whitespace

• Column profile

• Column distribution

• Column quality

You built a report to analyze customer transactions from a database that contains two tables.

Table 1: customer table with customer ID, name, state, and email columns.

Table 2: transaction table with transaction ID, customer ID, date, and amount.

Which relationship should you use to link the tables?

• Many-to-many between Customer and Transaction

• One-to-many from Transaction to Customer

• One-to-many from Customer to Transaction

• One-to-one between Customer and Transaction