You are a new data analyst at a store, and you noticed that some column names were not properly formatted; how would you rename the columns properly using Power BI? SELECT ALL THAT APPLY.

A. Left click on the column ribbon and rename it

B. Right click on the column header and select rename

C. Double click on the the column header and rename it

D. Select the column panel and rename it

​

You are a new data analyst at a store, and you noticed that some column names were not properly formatted; how would you rename the columns properly using Power BI? SELECT ALL THAT APPLY.

A. Left click on the column ribbon and rename it

Incorrect: The ribbon does not have a column tab in Power BI

B. Right click on the column header and select rename

Correct: When you right click on the column header, you can select rename accordingly

C. Double click on the the column header and rename it� Correct: When you double click on the column header, you can rename the column accordingly

D. Select the column panel and rename it

Incorrect: The column doesn’t have a panel

Alice is an intern at a startup. Her role requires her to make sense of customers’ data. She wants to quickly see the total percentage of valid, error, and empty data in each column of the data. What steps does she need to take? SELECT THE STEPS IN ORDER

1. Load the data directly
2. Load the data to the Power Query Editor
3. Select the desired table from the query pane
4. Click on the Transform tab from the ribbon
5. Select column quality
6. Click on the View tab from the ribbon
7. Select column distribution

A. 2 >>> 4 >>> 5

B. 2 >>> 3 >>> 4 >>> 5

C. 2 >>> 3 >>> 6 >>> 7

D. 2 >>> 3 >>> 6 >>> 5

​

Alice is an intern at a startup. Her role requires her to make sense of customers’ data. She wants to quickly see the total percentage of valid, error, and empty data in each column of the data. What steps does she need to take? SELECT THE STEPS IN ORDER

• Load the data directly
• Load the data to the Power Query Editor
• Select the desired table from the query pane
• Click on the Transform tab from the ribbon
• Select column quality
• Click on the View tab from the ribbon
• Select column distribution

A. 2 >>> 4 >>> 5

Incorrect: You need to first choose the table or data set

B. 2 >>> 3 >>> 4 >>> 5

Incorrect: Column quality is not under the Transform tab

C. 2 >>> 3 >>> 6 >>> 7

Incorrect: To get the percentage of valid, error, and empty, select column quality

D. 2 >>> 3 >>> 6 >>> 5

Correct: Following these steps will give Alice the desired result

​