Microsoft PL-300 Practice Test - Questions Answers, Page 5

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-plotsusing-the-microsoft-power-bi-d7ad16ac9ccc

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-viewfor-office-365

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

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

Combining data means connecting to two or more data sources, shaping them as needed, then consolidating them into a useful query. When you have one or more columns that you’d like to add to another query, you merge the queries.

Note: The RELATEDTABLE function is a shortcut for CALCULATETABLE function with no logical expression. CALCULATETABLE evaluates a table expression in a modified filter context and returns A table of values.

Reference:

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data

SAMEPERIODLASTYEAR returns a table that contains a column of dates shifted one year back in time from the dates in the specified dates column, in the current context.

Reference:

https://docs.microsoft.com/en-us/dax/sameperiodlastyear-function-dax

Each customer can have many transactions.

For each transaction there is exactly one customer.

You can add synonyms to tables and columns.

Note: This step applies specifically to Q&A (and not to Power BI reports in general). Users often have a variety of terms they use to refer to the same thing, such as total sales, net sales, total net sales. You can add these synonyms to tables and columns in the Power BI model.

This step applies specifically to Q&A (and not to Power BI reports in general). Users often have a variety of terms they use to refer to the same thing, such as total sales, net sales, total net sales. You can add these synonyms to tables and columns in the Power BI model.

Reference:

https://docs.microsoft.com/en-us/power-bi/natural-language/q-and-a-best-practices