Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
Give this quiz to my class
Q 1/10
Score 0
M is the primary language used for data transformations in Power Query Editor, but what does the "M" stand for?
30
Microsoft Language
Formula M
Power Query Script
Data Manipulation
Q 2/10
Score 0
When working with duplicate rows in Power BI, which of these methods would NOT be suitable for removing them?
30
Manually deleting rows one by one
Using the "Remove Duplicates" feature with selected columns
Merging the table with itself using an anti-join
Applying conditional column filtering to identify and exclude duplicates
10 questions
Q.
M is the primary language used for data transformations in Power Query Editor, but what does the "M" stand for?
1
30 sec
Q.
When working with duplicate rows in Power BI, which of these methods would NOT be suitable for removing them?
2
30 sec
Q.
You're working with a date column in Power BI. Which of the following transformations would be most appropriate to create a new column representing the year only?
3
30 sec
Q.
When combining multiple queries in Power BI, what is the key difference between using "Append" and "Merge"?
4
30 sec
Q.
Power BI offers a variety of functions for text manipulation. Which of these is NOT a common use case for text transformations?
5
30 sec
Q.
Custom columns can be extremely powerful in Power BI. What syntax would be used within the Power Query Editor to create a new calculated column named "Profit Margin" that subtracts the "Cost" column from the "Sales" column and divides by "Sales"? Profit Margin = Sales - Cost / Sales
6
30 sec
Q.
Error handling is crucial for data quality in Power BI. How can you identify rows with missing values in a specific column?
7
30 sec
Q.
When working with large datasets in Power BI, performance optimization becomes important. Which of the following transformations is generally considered less efficient?
8
30 sec
Q.
Power BI offers advanced features like pivoting data. Which scenario would NOT benefit from pivoting a table?
9
30 sec
Q.
The "Advanced Editor" in Power Query provides direct access to the M code underlying your data transformations. What is a significant advantage of using M code editing?