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?
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?
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-influencers
You have a Microsoft SharePoint Online site that contains several document libraries.
One of the document libraries contains manufactunng reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure.
You need to use Power Bl Desktop to load only the manufacturing reports to a table for analysis.
What should you do?
You have a Power BI report that uses a dataset based on an Azure Analysis Services live connection.
You need to ensure that users can use Q&A from the Power BI service for the dataset.
What should you do?
You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each compliant occurred. The data in Logged is in the fol-lowing format: 2018-12-31 at 08:59. You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy. What should you do?
Logged
2018-12-31 at 08:59
2019-01-01 at 09:15
Logged
Date
2018-12-31 at 08:59
2018-12-31
2019-01-01 at 09:15
2019-01-01
This makes it possible to use a built-in date hierarchy for analysis.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars.
You need to create a reference line to show which employees are above the median salary.
Solution: You create a constant line and set the value to .5.
Does this meet the goal?
Instead create a percentile line by using the Salary measure and set the percentile to 50%.
Note: The 50th percentile is also known as the median or middle value where 50 percent of observations fall below.
https://dash-intel.com/powerbi/statistical_functions_percentile.php
