WorksheetsConnecting and Shapping Data
Total questions: 15
Worksheet time: 9mins
Which of the following operations is used to add new rows to an existing table?
Merge
Left Join
Outer Join
Append
Which term best describes the process of transforming a table from a horizontal orientation to a vertical orientation by turning distinct column values into rows?
Unpivoting
Hinging
Transposing
Pivoting
Which query editing tool would you use to aggregate or roll up your data at a higher level? (i.e. Daily to Monthly)
Pivot
Group By
Merge
Append
Which type of column would you add to create a series of values to uniquely identify each row in a table?
Index
Count
Conditional
Sequential
Which of the following date tools is only available in the "Transform" tab of the Query Editor?
Latest
Month
Age
Day
Which of the following information is preserved when you import an entire data model from Excel to Power BI Desktop?
Query editing procedures
DAX measures
Table relationships
All of this information is preserved
Which three tabs in the Query Editor contain data shaping and transformation tools?
Transform, Design, Analyze
Load, Transform, Analyze
Home, Transform, Add Column
Transform, Load, Add Column
When you apply a tool from the "Transform" menu of the Power Query editor, which of the following is true?
Original column values are replaced
Original values are preserved, and a new column is created with transformed values
Power BI will give you the option to preserve or replace original values
Original column values are preserved
In Power BI, the tool used to connect to and transform data before loading it into the model is called the
(a)
To combine two tables with the same columns into one, you use the (a) operation in Power Query.
Which feature in Power BI is used to transform and shape data before loading?
A. Power Pivot
B. Power View
C. Power Query
D. Power Map
Which of the following is NOT a way to shape data in Power BI?
A. Remove columns
B. Rename columns
C. Change data types
D. Insert animations
In Power Query, the panel that shows each step of your transformation is called the (a) pane
Which of the following can Power BI connect to directly?
A. Microsoft Excel
B. SQL Server
C. Web Data
D. All of the above
Which pane in Power Query lists each step taken to transform data?
A. Queries Pane
B. Formula Bar
C. Fields Pane
D. Applied Steps
