Analyzing Data with Microsoft Power BI v1.0 (DA-100)

Page:    1 / 7   
Total 100 questions

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?

  • A. Get data from a SharePoint Online folder, enter the site URL, and then select Combine & Load.
  • B. Get data from a SharePoint Online list and enter the site URL. Select Combine & Transform, then filter by the folder path to the manufacturing reports library.
  • C. Get data from a SharePoint Online folder and enter the site URL. Select Combine & Transform, then filter by the folder path to the manufacturing reports library.
  • D. Get data from a SharePoint Online list, enter the site URL, and then select Combine & Load.


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.


Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
Hot Area:



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.


1. Let's see what happens when we select Moderation.

2. Cross-filtering removes data that doesn't apply. Selecting Moderation in the doughnut chart cross-filters the line chart. The line chart now only displays data points for the Moderation segment.
3. Cross-highlighting retains all the original data points but dims the portion that does not apply to your selection. Selecting Moderation in the doughnut chart cross-highlights the column chart. The column chart dims all the data that applies to the Convenience segment and highlights all the data that applies to the
Moderation segment.
Reference:
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-interactions

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.

  • A. Replace the slicers with report-level filters.
  • B. Sync the slicers across the pages.
  • C. Create a bookmark for each slicer value.
  • D. Replace the slicers with page-level filters.
  • E. Replace the slicers with visual-level filters.


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.


The Sync slicers pane appears between the Filters and Visualizations panes.

Reference:
https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-report-add-filter https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers

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. Add a measure to the visual that uses the following DAX expression. Measure1 = PERCENTILEX.INC (Sales,Sales[Total Sales],0.40)
  • B. Add a new percentile line that uses Total Sales as the measure and 40% as the percentile.
  • C. Create a horizontal line that has a fixed value of 24,000.
  • D. Add a measure to the visual that uses the following DAX expression. Measure1 = PERCENTILEX.EXC (Sales,Sales[Total Sales],0.40)


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



Add percentile lines to monitor daily revenue

Incorrect Answers:
A, D: There are two main percentile functions in Power BI:
PERCENTILE.EXC(column, kth percentile)
PERCENTILE.INC(column, kth percentile)
The first parameter is the column which you want the percentile value for.
The second parameter is the kth percentile where k percentage of values will fall below.
Both formulas use a slightly different algorithm. The second algorithm works for any value of k between 0 and 1 (the 0th and 100th percentile). In the EXC version the data excludes both lower and upper bounds, while INC includes them.
Reference:
https://www.dash-intel.com/powerbi/statistical_functions_percentile.php

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. donut chart
  • B. pie chart
  • C. area chart
  • D. scatter plot


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.


The indicator color for Total Sales will be based on % Growth to Last Year.
The solution must use the existing calculations only.
How should you configure the visual? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:



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?

  • A. Yes
  • B. No


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?

  • A. stacked area chart
  • B. donut chart
  • C. line chart
  • D. waterfall chart


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:


Incorrect Answers:
A: Stacked area charts are not appropriate to study the evolution of each individual group: it is very hard to substract the height of other groups at each time point.
Note: A stacked area chart is the extension of a basic area chart. It displays the evolution of the value of several groups on the same graphic. The values of each group are displayed on top of each other, what allows to check on the same figure the evolution of both the total of a numeric variable, and the importance of each group.
Reference:
https://www.data-to-viz.com/graph/line.html

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. key influencers
  • B. ribbon chart
  • C. line chart
  • D. scatter chart


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?

  • A. Yes
  • B. No


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?

  • A. Create a text box for each business question and insert a link.
  • B. Create a button for each business question and set the action type to Bookmark.
  • C. Create a Power Apps visual that contains a drop-down list. The drop-down list will contain the business questions.


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?

  • A. the tab order
  • B. the layer order
  • C. the bookmark order
  • D. the X position


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.


Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
Hot Area:



Answer :

Analyze the Data -

DRAG DROP -
You have the line chart shown in the exhibit. (Click the Exhibit tab.)


You need to modify the chart to meet the following requirements:
✑ Identify months that have order counts above the mean.
✑ Display the mean monthly order count.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place:



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)



Step 2: Select the line chart -
Step 3: From the Analytics pane, add a Median line
Reference:
https://community.powerbi.com/t5/Desktop/Moving-Average/td-p/43041

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.)


Each file contains deltas of any new or modified rows from each load to the data lake. Multiple files can have the same customer ID.
You need to keep only the last modified row for each customer ID.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place:



Answer :

Page:    1 / 7   
Total 100 questions