Quiz

  1. 1
    Intermediate

    You set up a query to unpivot the data shown in the image below as follows: Pull the data into Power Query --> Right click the Customer column --> Unpivot Other Columns. What will happen when you refresh the query if the original table is updated to have columns for Product 5, Product 6 and Product 7?

  2. 2
    Intermediate

    Is this data a good candidate to be unpivoted?

  3. 3
    Intermediate

    You are building a query that will unpivot a data set, and your intention is to use this table to drive several PivotTables. What should you ensure is removed from the data when you build the query?