Power Query Editor is the platform we use to transform data like changing column data types and removing columns and rows

The Power Query Editor does not save changes made to the data tables. It saves the applied steps separately so that the steps will need to be applied every time the table is loaded.

I would like to create a clustered column chart. I will go to this panel to create the chart.

Sometimes when analyzing data we may use our dimensions as a measure to understand values like no. of instances, average pricing or maximum price

The MAP chart is a useful visualization to show locations of cities and countries with bubbles to indicate the size of the data points.

A dimension is a descriptive information to help us slice the data. Examples of dimension includes customer name, customer age, product id, product descriptive etc

In any analytics report, it is not necessary to have measures.

A customer may purchase 1 or many products. So the relationship between the customer table and the products table will be

To enable two tables to be joined. A unique key between the 2 tables is required. For example between the customer table and the sales table. The key would be customer ID.

Which of the following illustrates a Many to One relationship?

In the data view, we are able to view the tables that we have imported. Each table shown is from a specific excel worksheet.