Power BI Quizzes

Practice Quizzes
Thanks!
Thanks!

Power BI Quizzes

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

Replace Values

Find-Replace

Spell check

Recode

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

dots (".")

spaces (" ")

dashes ("-")

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

A column contains the following rows:

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

average(Shipping_Cost) will remain the same

average(Shipping_Cost) will increase

average(Shipping_Cost) will decrease

Time is Up!

Time's up

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

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

© Learning Tableau. All rights reserved.
Privacy Policy | Design by Liscio Apps, LLC