Quizalize logo
placeholder image to represent content

Ultimate Power Bi Data Transformation/Cleansing Guide

Quiz by Support - BusinessPromoted .com

Feel free to use or edit a copy

includes Teacher and Student dashboards

Measure skills
from any curriculum

Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.

With a free account, teachers can
  • edit the questions
  • save a copy for later
  • start a class game
  • automatically assign follow-up activities based on students’ scores
  • assign as homework
  • share a link with colleagues
  • print as a bubble sheet

Our brand new solo games combine with your quiz, on the same screen

Correct quiz answers unlock more play!

New Quizalize solo game modes
10 questions
Show answers
  • Q1
    1. In Power Query, what method should you use to combine data from two tables while ensuring that rows from the first table without matching entries in the second are retained?
    Left outer join
    Right outer join
    Inner join
    Full outer join
    40s
  • Q2
    2. When splitting columns based on delimiters, which option allows you to separate a column containing "first.last" into "first" and "last" in Power BI?
    Merge queries
    Split by delimiter
    Replace values
    Remove duplicates
    40s
  • Q3
    3. While cleaning data, how do you ensure that only distinct rows remain after transformations in Power Query?
    Split columns
    Remove errors
    Remove duplicates
    Group by
    40s
  • Q4
    4. How do you handle missing values in a dataset if you need to replace them with a default value in Power Query?
    Remove nulls
    Fill up
    Replace values
    Fill down
    40s
  • Q5
    5. What transformation would you use to format a column with mixed case text to ensure consistency by converting everything to lowercase?
    Format -> Text as lowercase
    Data type conversion
    Transform -> Lowercase
    Column profiling
    40s
  • Q6
    6. If you have a date column with inconsistent formats, how can you standardize it to the "yyyy-mm-dd" format using Power Query?
    Change data type to Date
    Split by delimiter
    Use Text to Columns
    Remove duplicates
    40s
  • Q7
    7. In Power Query, how do you combine two columns into a single column without losing any data?
    Replace values
    Merge columns
    Append columns
    Concatenate values
    40s
  • Q8
    8. If you need to remove all non-numeric characters from a column containing mixed data types, which transformation should you apply in Power Query?
    Transform -> Extract -> Numbers
    Group by
    Remove errors
    Split by delimiter
    40s
  • Q9
    9. To create a new calculated column that adds 10% to a numeric column, which function in Power Query should you use?
    Group by and sum
    Custom column formula: [Column] * 1.1
    Append queries and filter
    Merge queries and calculate
    40s
  • Q10
    10. When merging tables, how can you avoid duplicating rows and ensure that only one unique match per row is included from both tables?
    Apply fuzzy matching
    Use a unique identifier key in both tables
    Filter out nulls before merging
    Split columns before merging
    40s

Teachers give this quiz to your class