Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 3 question 1 discussion

Actual exam question from Microsoft's PL-300

Question #: 1
Topic #: 3

DRAG DROP -
You have a Microsoft Excel spreadsheet that contains the data shown in the following table.

You plan to build a data model for a Power BI report.
You need to prepare the data so that it is available to the model in the format shown in the following table.

Which three actions should you perform in sequence in Power Query Editor? 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:

Show Suggested Answer

Suggested Answer:

Step 1: Select the [Department] and [Stage] columns and unpivot the other columns.
We unpivot the School1, School2, School3, and the School4 columns.
You might want to unpivot data, sometimes called flattening the data, to put it in a matrix format so that all similar values are in one column.
Example:

When you unpivot, you unpack the attribute-value pairs that represent an intersection point of the new columns and re-orient them into flattened columns:
* Values (in blue on the left) are unpivoted into a new column (in blue on the right).
* Attributes (in green on the left) are unpivoted into a new column (in green on the right) and duplicates are correspondingly mapped to the new Values column.
Step 2: Rename the [Attribute] column as [School] and the [Value] column as [Score[,
Step 3: Group by [Department] and [School] and..
Reference:
https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098

by olajor at Sept. 12, 2022, 1:32 p.m.

Comments

Submit Cancel

olajor

Highly Voted 2 years, 9 months ago

answer is correct

upvoted 89 times

...

Churato

Highly Voted 2 years, 7 months ago

1) Select the [Department] and [Stage] aand Unpivot the other columns. 2) Rename the [Attribute] column as [School] and the [Value] column as [Score]. 3) Group by [Department] and [School] and create a new column named [Avg Score] that uses the average function on the [Score] column Tested here, and it's correct!

upvoted 48 times

...

539d541

Most Recent 9 months, 3 weeks ago

solution is correct

upvoted 2 times

...

rcaliandro

10 months ago

In my opinion: 1 - Select the [Department] and [Stage] columns and unpivot the other columns 2 - Rename the [Attribute] column as [School] and the [Value] column as [Score] 3 - Group by [Department] and [School] and create a new column named [Avg Score] that uses the AVERAGE function on the [Score] column

upvoted 1 times

...

agelee

11 months ago

Who would create Avg Score in PowerQuery instead of measure in PowerBI. So stupid.

upvoted 1 times

...

ElieG

1 year, 1 month ago

yes the answer steps work well, but they do not give the same result and even the result given for averages are fault as you can see for example the average of Mathematics score of school1 should be equal to (75+95)/2 which is 85 and not 77.5

upvoted 1 times

...

Usm_9

1 year, 3 months ago

WAS ON THE EXAM 02 03 2024

upvoted 7 times

...

Dani_eL

1 year, 3 months ago

answer is correct

upvoted 1 times

...

08b2ddd

1 year, 5 months ago

CORRECT

upvoted 2 times

...

MS240396

1 year, 5 months ago

Answer is correct..!

upvoted 2 times

...

ElieG

1 year, 6 months ago

When tested it doesn't give the same outcome as asked for, instead it give the mathematics with the correspondent schools then the geography. Can anyone tell anything about this?

upvoted 1 times

...

itenginerd

1 year, 8 months ago

This was on my exam today

upvoted 8 times

...

Igetmyrole

1 year, 9 months ago

Action 1: Select the [department] and [stage] columns and unpivot the other columns. Action 2: select and unpivot the [department] and [stage] columns. Action 3: Group by [department] and [school] and create a new column named [Avg Score] that uses the average function on the [score] column. Action 1: Will transform the data into a long format, making it easier to work with. Action 2: to provide meaningful column name. Action 3: will calculate the average score for each combination of department and school.

upvoted 1 times

...