Learn Power BI

Blog
Practice Questions

Learn Power BI

Accelerate your Career and Get Certified

Simplify the data structure

Thursday, April 1st, 2021

Welcome to your Simplify the data structure

Questions are based on this module

If a column has values that are misspelled, this option in the Transform tab can help

Find-Replace

Recode

Replace Values

Spell check

When renaming columns, a best practice is to replace underscores ("_") with

spaces (" ")

capitalizing the first letter of the words, so for example "birth_date" becomes "Birth Date"

dashes ("-")

dots (".")

A column contains the following rows:

If we replace nulls with 0, how will the average of Shipping_Cost change?

average(Shipping_Cost) will increase

average(Shipping_Cost) will remain the same

average(Shipping_Cost) will decrease

Time is Up!

Time's up

Leave a Reply Cancel reply

Your email address will not be published.

Comment

Name

Email

Website

Δ

About the Author: Lukas Halim

I earned a Masters in Analytics from NC State in 2013 and now work as a data analyst in the health insurance industry. Using tools such as SAS, Tableau, and Teradata, I conduct analysis to help my company improve healthcare affordability and customer engagement.

Learn More

4.6 Instructor Rating
53,604 Students

14,612 Reviews
2 courses

© Power Bi Skills. All rights reserved.
Privacy Policy | Design by Liscio Apps, LLC