Accelerate your Career and Get Certified
Friday, June 25th, 2021
Welcome to your Prepare the Data for Analysis
True or False: when a table is created from a flat file in Power BI Desktop, the Power Query Editor assumes that the first row of data is the column headers
Two ways to change the data type in Power BI:
Which is more likely to have data type errors
If a column has values that are misspelled, this option in the Transform tab can help
When you append queries, you will be
Which is similar to a SQL JOIN?
This transformation applies aggregation
If you think you might use a column at some point in the future, you should be sure to keep it in the data model so that it is there when you need it.
When doing a merge, which option will guarantee that all rows are included in the result?
Shows % of data that is valid, in error, and empty
A column contains the following rows:If we replace nulls with 0, how will the average of Shipping_Cost change?
To edit M code directly
Power Query creates which type of code?
When renaming columns, a best practice is to replace underscores ("_") with
Time is Up!
Your email address will not be published. Required fields are marked *