You are creating a sales report in Power Bl for the NorthWest region sales territory of your company. Data will come from a view in a Microsoft SQL Server database. A sample of the data is shown in the following table:

The report will facilitate the following analysis:

The count of orders and the sum of total sales by Order Date

The count of customers who placed an order

The average quantity per order

You need to reduce data refresh times and report query times. Which two actions should you perform? Each correct answer presents part of the solution. NOTE:

Each correct selection is worth one point.

Question

You are creating a sales report in Power Bl for the NorthWest region sales territory of your company. Data will come from a view in a Microsoft SQL Server database. A sample of the data is shown in the following table:

The report will facilitate the following analysis:

The count of orders and the sum of total sales by Order Date
The count of customers who placed an order
The average quantity per order

You need to reduce data refresh times and report query times. Which two actions should you perform? Each correct answer presents part of the solution. NOTE:

Each correct selection is worth one point.

Accepted Answer

A. Filter the data to only the NorthWest region sales territory. Filtering the data at the source to only include the "NorthWest region sales territory" reduces the volume of data imported into the Power BI model, directly decreasing refresh times and improving query performance by limiting the dataset size. This aligns with best practices for data reduction. C. Remove the TaxAmt and Freight columns. Removing the 'TaxAmt' and 'Freight' columns, which are not explicitly required for the specified analysis (count of orders, sum of sales, count of customers, average quantity), reduces the column count and overall dataset size. This minimizes data transfer and storage, leading to faster refreshes and improved report query performance.

Answer

B. Remove the CustomerKey and ProductKey columns. Removing 'CustomerKey' and 'ProductKey' columns might be counterproductive or incorrect, as 'CustomerKey' is often used to count distinct customers, which is a required analysis ("The count of customers who placed an order").

Answer

D. Set the data type for SatesOrderNumber to Decimal Number Changing the data type of 'SalesOrderNumber' to Decimal Number is unlikely to improve performance significantly and might even be incorrect if 'SalesOrderNumber' is a text or integer identifier, not a numeric value requiring decimal precision.

You are creating a sales report in Power Bl for the NorthWest region sales territory of your company. Data will come from a view in a Microsoft SQL Server database. A sample of the data is shown in…

Question

Exhibit

Options

How the community answered

Why each option

Topics

Community Discussion