INSYNTIVEAcademy
IDEN
Sign inSign up freeSign up

Module 02 · Transform data (Power Query)

Checkpoint: Power Query

A quick 3-question Power Query quiz: Applied Steps, Append vs Merge and data types, before you move on to data modeling.

Checkpoint3 minLesson 9 of 21 Free

  1. Where is every cleaning action recorded?
    • Filters pane
    • Applied Steps
    • Bookmarks
    • Data pane
  2. You have Jan and Feb tables with identical columns. To stack them you use…
    • Merge
    • Append
    • Relationship
    • Measure
  3. Revenue stored as text won’t sum because…
    • It’s too long
    • The data type is wrong
    • It needs a slicer
    • Power BI is offline