Skip to main content

Posts

Featured

Scenario Based Questions for PL -300 Exam Microsoft Power BI Data Analyst with Solutions and Explanations

  You need to address the data before creating the data model. What should you do in Power Query Editor?  A. Select Column distribution B. Select the sales_amount column and apply a number filter.  C. Select Column profile, and then select the sales_amount column.  D. Transform the sales_amount column to replace negative values with 0. Answer: C   Solution: “data concerns” refers to data preview.  To check the data preview, go to: Power Query Editor> View > Data Preview. In this section you have:  1. Column distribution: shows unique and distinct values.  2. Column quality: shows the % of: valid, error and empty values.  3. Column profile: includes column distribution (not in %) and column quality. Shows statistics values and distribution of the column as well. As data profile is the most complete for addressing concerns, then C is the answer You are creating a Microsoft Power BI model that has two tables named CityData and Sales.   State (Sales)      Type      Sales  CA        

Latest posts

Top interview questions and answers SQL - Part 2

Top SQL interview questions Part 1

How to select first row in each group using GROUP BY ?

What Is Playwright?

Top 11 tools to get a job in 2023 - Be AI ready and beat it