Module 3: Cleaning, Transforming, and Loading Data

The primary data preparation tool in Power BI is called what?

• Report editor

• Power Query editor

• Data editor

Answer explanation

Should include a statement that it is the process of shaping data by converting your flat data into a table that contains an aggregation value for each unique value in a column.

The process of shaping data by converting your flat data into a table that contains an aggregation value for each unique value in a column is called what?

• Group by columns

• Pivot (pivoting a column)

• Manage aggregations

Answer explanation

Should include deleting unnecessary rows and columns will reduce the dataset size and load only necessary data into your data model.

What can be achieved by removing unnecessary rows and columns?

• It is not necessary to delete unnecessary rows and columns and it is good practice to keep all metadata intact.

• Deleting unnecessary rows and columns can damage the structure of the data model.

• Deleting unnecessary rows and columns will reduce the dataset size and it is good practice to load only necessary data into your data model

Answer explanation

(Should include a statement that data profiling is studying the nuances of the data: determining anomalies, examining and developing the underlying data structures, and querying data statistics such as row counts, value distributions, minimum and maximum values, averages, and so on. This concept is important because it allows you to shape and organize the data so that interacting with the data and identifying the distribution of the data is uncomplicated, therefore helping to make your task of working with the data on the front end to develop report elements near effortless.

Data profiling is defined as what?

• Aggregating columns containing numeric data

• Studying the nuances of the data

• Data modeling

Answer explanation

Should include a statement that states if you have two queries that contain different data with the same structure, and you want to combine them into one query.

If you have two queries that contain different data with the same structure, and you want to combine them into one query, which operation should you perform?

• Merge

• Append

• Combine column

Answer explanation

(Should include a statement that includes rename a query, replace values, replace null values, and remove duplicates.)