Chapter 2 of 4 - Transforming Data Flashcards
1
Q
What is the Power Query Editor and what can you use it for?
A
A tool that allows you to edit the data prior to loading it. You can use it to format the dataset and decide what gets loaded.
2
Q
What language does the Power Query Editor use?
A
M
3
Q
What is something important that you need to do in Power Query Editor for any changes to be made to the data in the report?
A
Close and Apply
4
Q
What does the Applied Steps panel do?
A
It tracks the changes you have made to the data
5
Q
How do you get to the Power Query Editor from the Data view?
A
Selecting ‘Transform Data’ in the tool bar
6
Q
A
