Microsoft PL-300 Microsoft Power BI Data Analyst Online Training
Microsoft PL-300 Online Training
The questions for PL-300 were last updated at Nov 26,2024.
- Exam Code: PL-300
- Exam Name: Microsoft Power BI Data Analyst
- Certification Provider: Microsoft
- Latest update: Nov 26,2024
You plan to create the chart shown in the following exhibit.
How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period shown?
- A . Create a horizontal line that has a fixed value of 24,000.
- B . Add a measure to the visual that uses the following DAX expression.
Measure – PERCENTUEX.EXC (Sales,Sales[Total Sales],©.40) - C . Add a new percentile line that uses Total Sales as the measure and 40% as the percentile.
- D . Add a measure to the visual that uses the following DAX expression.
Measure = PERCENTILEX.INC (Sales,Sales[Total Sales],6.40)
C
Explanation:
The analytics feature enables you to show percentiles across groups specified along a specific axis.
Example:
You plan to create the chart shown in the following exhibit.
How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period shown?
- A . Create a horizontal line that has a fixed value of 24,000.
- B . Add a measure to the visual that uses the following DAX expression.
Measure – PERCENTUEX.EXC (Sales,Sales[Total Sales],©.40) - C . Add a new percentile line that uses Total Sales as the measure and 40% as the percentile.
- D . Add a measure to the visual that uses the following DAX expression.
Measure = PERCENTILEX.INC (Sales,Sales[Total Sales],6.40)
C
Explanation:
The analytics feature enables you to show percentiles across groups specified along a specific axis.
Example:
You plan to create the chart shown in the following exhibit.
How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period shown?
- A . Create a horizontal line that has a fixed value of 24,000.
- B . Add a measure to the visual that uses the following DAX expression.
Measure – PERCENTUEX.EXC (Sales,Sales[Total Sales],©.40) - C . Add a new percentile line that uses Total Sales as the measure and 40% as the percentile.
- D . Add a measure to the visual that uses the following DAX expression.
Measure = PERCENTILEX.INC (Sales,Sales[Total Sales],6.40)
C
Explanation:
The analytics feature enables you to show percentiles across groups specified along a specific axis.
Example:
You plan to create the chart shown in the following exhibit.
How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period shown?
- A . Create a horizontal line that has a fixed value of 24,000.
- B . Add a measure to the visual that uses the following DAX expression.
Measure – PERCENTUEX.EXC (Sales,Sales[Total Sales],©.40) - C . Add a new percentile line that uses Total Sales as the measure and 40% as the percentile.
- D . Add a measure to the visual that uses the following DAX expression.
Measure = PERCENTILEX.INC (Sales,Sales[Total Sales],6.40)
C
Explanation:
The analytics feature enables you to show percentiles across groups specified along a specific axis.
Example:
You plan to create the chart shown in the following exhibit.
How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period shown?
- A . Create a horizontal line that has a fixed value of 24,000.
- B . Add a measure to the visual that uses the following DAX expression.
Measure – PERCENTUEX.EXC (Sales,Sales[Total Sales],©.40) - C . Add a new percentile line that uses Total Sales as the measure and 40% as the percentile.
- D . Add a measure to the visual that uses the following DAX expression.
Measure = PERCENTILEX.INC (Sales,Sales[Total Sales],6.40)
C
Explanation:
The analytics feature enables you to show percentiles across groups specified along a specific axis.
Example:
You have a table that contains sales data and approximately 1,000 rows.
You need to identify outliers in the table.
Which type of visualization should you use?
- A . area chart
- B . donut chart
- C . scatter plot
- D . pie chart
C
Explanation:
Outliers are those data points that lie outside the overall pattern of distribution & the easiest way to detect outliers is though graphs. Box plots, Scatter plots can help detect them easily.
Reference: https://towardsdatascience.com/this-article-is-about-identifying-outliers-through-funnel-plots-using-the-microsoft-power-bi-d7ad16ac9ccc
You have a collection of reports for the HR department of your company.
You need to create a visualization for the HR department that shows a historic employee counts and predicts trends during the next six months.
Which type of visualization should you use?
- A . scatter chart
- B . ribbon chart
- C . line chart
- D . key influences
C
Explanation:
The best data for forecasting is time series data or uniformly increasing whole numbers. The line chart has to have only one line.
Try forecasting: Try the new forecasting capabilities of Power View today on your own data or with the sample report available as part of the Power BI report samples. To view your own data, upload a workbook with a Power View time series line chart to Power BI for Office 365.
Reference: https://powerbi.microsoft.com/en-us/blog/introducing-new-forecasting-capabilities-in-power-view-for-office-365
You have the visual shown in the exhibit. (Click the Exhibit tab.)
You need to show the relationship between Total Cost and Total Sales over time.
What should you do?
- A . Add a play axis.
- B . Add a slicer for the year.
- C . From the Analytics pane, add an Average line.
- D . Create a DAX measure that calculates year-over-year growth.
A
Explanation:
You can set up a date field in play axis, and then scatter chart will animate how measure values are compared to each other in each point of a time.
Reference: https://radacad.com/storytelling-with-power-bi-scatter-chart
HOTSPOT
You are creating a column chart visualization.
You configure groups as shown in the Groups exhibit. {Click the Groups tab.)
The visualization appears as shown in the Chart exhibit. (Click the Chart tab.)
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
You build a report to help the sales team understand its performance and the drivers of sales. The team needs to have a single visualization to identify which factors affect success.
Which type of visualization should you use?
- A . Key influences
- B . Funnel chart
- C . Q&A
- D . Line and clustered column chart
A
Explanation:
The key influencers visual helps you understand the factors that drive a metric you’re interested in. It analyzes your data, ranks the factors that matter, and displays them as key influencers.
The key influencers visual is a great choice if you want to:
✑ See which factors affect the metric being analyzed.
✑ Contrast the relative importance of these factors.
For example, do short-term contracts have more impact on churn than long-term contracts?
Reference: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-influencers
Latest PL-300 Dumps Valid Version with 131 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
