DRAG DROP
You are modeling data in a table named SalesDetail by using Microsoft Power BI.
You need to provide end users with access to the summary statistics about the SalesDetail data. The users require insights on the completeness of the data and the value distributions.
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:
A.
B.
C.
D.
Correct Answer:
Explanation/Reference:
Step 1: Create a blank query as a data source Start with a New Source in Power Query Editor, and then Blank Query.
Create a parameter that use a query for suggested values.
Step 2: Specify the following query, then close and apply. -Table.Profile(“SalesDetail”) In the new blank query, in the formula bar (if you don’t see the formula bar, check the formula bar option in the View tab of the Power Query Editor), type below expression: =Table.Profile() Note that this code is not complete yet, we need to provide a table as the input of this function.
Note: The Table.Profile() function takes a value of type table and returns a table that displays, for each column in the original table, the minimum, maximum, average, standard deviation, count of values, count of null values and count of distinct values.
Step 3: Create a visual for the query table.
The profiling data that you get from Table.Profile function is like below; After loading the data into Power BI, you’ll have the table with all columns, and it can be used in any visuals.
Reference:
https://radacad.com/create-a-profiling-report-in-power-bi-give-the-end-user-information-about-the-data
