Power Query Training

Which of the following does not belong to the common steps that are often followed when using Power Query? (Select all that applies)

• Connect

• Combine

• Share

• Transform

• Like

What language is used in Power Query to record to record and carry out its steps?

• Python

• SQL

• M Language

• Tagalog

Is a data connection technology that enables you to discover, connect, combine, and refine data sources to meet your analysis needs.

• Power Pivot

• Power Query

• Power View

• Power MS

A dedicated window that facilitates and displays your data connections and transformations you apply.

• Query Editor

• MS Editor

• Excel Editor

• Editorial

Means modifying it in some way to meet your needs – for example, you could remove a column, change a data type, or merge tables – each of which is a data transformation.

• Share Data

• Connect Data

• Get data

• Transforming data

What step is to create a data model from multiple data sources, and get a unique view into the data ?

• Transform

• Combine

• Share

• Connect

What steps is to make connections to data sitting in the cloud, in a service, or locally?

• Connect

• Share

• Combine

• Transform

The process of applying transformations to one or more sets of data is often called?

• Showing

• Creating

• Harnessing

• Shaping

The transformations you apply to your data connections collectively constitute your?

• Steps

• Query

• Process

• Data

How to share the connections you've created in your power query file?

• Export/Import Process

• Jabber

• Email

• SendThisFile