Exam PL-300 topic 3 question 1 discussion

answer is correct

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!

solution is correct

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

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

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

WAS ON THE EXAM 02 03 2024

answer is correct

CORRECT

Answer is correct..!

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?

This was on my exam today

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.

answer is correct

Correct answer.

I don't understand why you have to create an average column. When you group you can set the number field to average.

1-4-3 order is correct.