You have a Microsoft SharePoint Online site that contain several document libraries.
One of the document libraries contains manufacturing reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure.
You need to use Power BI Desktop to load only the manufacturing reports to a table for analysis.
What should you do?
Answer : C
Reference:
https://www.c-sharpcorner.com/article/combine-and-transform-data-of-multiple-files-located-in-a-folder-in-power-bi/
HOTSPOT -
You have a report page that contains the visuals shown in the following exhibit.
Answer :
Explanation:
Box 1: cross-filter -
By default, selecting a data point in one visual on a report page will cross-filter or cross-highlight the other visuals on the page.
Box 2: cross-highlight -
Example:
By default, selecting a data point in one visual on a report page will cross-filter or cross-highlight the other visuals on the page.
You have a report that contains four pages. Each page contains slicers for the same four fields.
Users report that when they select values in a slicer on one page, the selections are not persisted on other pages.
You need to recommend a solution to ensure that users can select a value once to filter the results on all the pages.
What are two possible recommendations to achieve this goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
Answer : AB
Explanation:
A: Add a report-level filter to filter an entire report.
The visuals on the active page, and on all pages in the report, change to reflect the new filter.
B: You can sync a slicer and use it on any or all pages in a report.
1. On the Power BI Desktop View menu, select Sync slicers.
You plan to create the chart shown in the following exhibit.
Answer : B
Explanation:
The analytics feature enables you to show percentiles across groups specified along a specific axis.
Example:
1. Click on the analytics tab
2. Select Percentile
3. You can choose a specific percentile along with other formatting options.
4. Drag a date or non-numeric dimension into the Axis of a column chart
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?
Answer : D
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
HOTSPOT -
You need to create a visual as shown in the following exhibit.
Answer :
Explanation:
Box 1: Background color -
To format the Color column based on its field values, select Conditional formatting for the Color field, and then select Background color or Font color.
In the Background color or Font color dialog box, select Field value from the Format by drop-down field.
Box 2: Field value -
With conditional formatting for tables in Power BI Desktop, you can specify customized cell colors, including color gradients, based on field values.
Reference:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting
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?
Answer : B
Explanation:
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.
Reference:
https://dash-intel.com/powerbi/statistical_functions_percentile.php
You need to create a visualization that compares revenue and cost over time.
Which type of visualization should you use?
Answer : C
Explanation:
A line chart or line graph displays the evolution of one or several numeric variables. Data points are connected by straight line segments. A line chart is often used to visualize a trend in data over intervals of time ג€" a time series ג€" thus the line is often drawn chronologically.
Example:
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?
Answer : 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
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 median line by using the Salary measure.
Does this meet the goal?
Answer : A
Explanation:
The 50th percentile is also known as the median or middle value where 50 percent of observations fall below.
Reference:
https://dash-intel.com/powerbi/statistical_functions_median.php
You are developing a sales report that will have multiple pages. Each page will answer a different business question.
You plan to have a menu page that will show all the business questions.
You need to ensure that users can click each business question and be directed to the page where the question is answered. The solution must ensure that the menu page will work when deployed to any workspace.
What should you include on the menu page?
Answer : C
Explanation:
Power BI enables data insights and better decision-making, while Power Apps enables everyone to build and use apps that connect to business data. Using the
Power Apps visual, you can pass context-aware data to a canvas app, which updates in real time as you make changes to your report. Now, your app users can derive business insights and take actions from right within their Power BI reports and dashboards.
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/powerapps-custom-visual
You are developing a report page. Some users will navigate the report by using a keyboard, and some users will consume the report by using a screen reader.
You need to ensure that the users can consume the content on a report page in a logical order.
What should you configure in Microsoft Power BI Desktop?
Answer : A
Explanation:
If you find yourself unable to navigate to an object or visual while using a keyboard, it may be because the report author has decided to hide that object from the tab order. Report authors commonly hide decorative objects from the tab order. If you find that you cannot tab through a report in a logical manner, you should contact the report author. Report authors can set the tab order for objects and visuals.
Reference:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-accessibility-consuming-tools
HOTSPOT -
You have the Power BI data model shown in the following exhibit.
Answer :
Analyze the Data -
DRAG DROP -
You have the line chart shown in the exhibit. (Click the Exhibit tab.)
Answer :
Explanation:
Step 1: Create a 12-month...
You can use calculated measure to get the expected result.
1. Create a calculated column for the date.
2. Create a measure for 12 months moving average.
3. Drag the Line Chart into your canvas as below. (step 2 below)
DRAG DROP -
You have a query named Customer that imports CSV files from a data lake. The query contains 50,000 rows as shown in the exhibit. (Click the Exhibit tab.)
Answer :