16. 5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:Helvetica;
mso-bidi-font-weight:bold’>
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:
Helvetica;mso-bidi-font-weight:bold’>Scenario: Data Concerns
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:
Helvetica;mso-bidi-font-weight:bold’>You are concerned with the quality and
completeness of the sales data. You plan to verify the sales data for negative
sales amounts.
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:
Helvetica;mso-bidi-font-weight:bold’>How to convert negative numbers into
positive numb, editor and right click, select
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:
Helvetica;mso-bidi-font-weight:bold’>transform, and choose absolute value. That
would give the positive number outcome you’re looking for.
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:
Helvetica;mso-bidi-font-weight:bold’>Reference: https://www.xspdf.com/resolution/50510644.html
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:
Helvetica;mso-bidi-font-weight:bold’>
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:
Helvetica;mso-bidi-font-weight:bold’>9. Topic 2, Contoso Ltd, Case Study
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:
Helvetica;mso-bidi-font-weight:bold’>
mso-fareast-font-family:Helvetica’>Overview
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:
Helvetica;mso-bidi-font-weight:bold’>This is a case study. Case studies are not
timed separately. You can use as much exam time as you would like to complete
each case.style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:
Helvetica;mso-bidi-font-weight:bold’>
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:
Helvetica;mso-bidi-font-weight:bold’>To answer the questions included in a case
study, you will need to reference information that is provided in the case
study. Case studies might contain exhibits and other resources that provide
more information about the scenario that is described in the case study. Each
question is independent of the other questions in this case study.
lang=EN-US style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;
mso-fareast-font-family:Helvetica;mso-bidi-font-weight:bold’>At the end of this
case study, a review screen will appear. This screen allows you to review your
answers and to make changes before you move to the next section of the exam.
After you begin a new section, you cannot return to this section.
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:
Helvetica;mso-bidi-font-weight:bold’>
mso-fareast-font-family:Helvetica’>To start the case study
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:
Helvetica;mso-bidi-font-weight:bold’>To display the first question in this case
study, click the Next button. Use the buttons in the left pane to explore the
content of the case study before you answer the questions. Clicking these
buttons displays information such as business requirements, existing
environment and problem statements. If the case study has an All Information
tab, note that the information displayed is identical to the information
displayed on the subsequent tabs. When you are ready to answer a question,
click the Question button to return to the question.
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:
Helvetica;mso-bidi-font-weight:bold’>
mso-fareast-font-family:Helvetica’>Existing Environment
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:
Helvetica;mso-bidi-font-weight:bold’>Contoso, Ltd. is a manufacturing company
that produces outdoor equipment Contoso has quarterly board meetings for which
financial analysts manually prepare Microsoft Excel reports, including profit
and loss statements for each of the company’s four business units, a company
balance sheet, and net income projections for the next quarter.
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:
Helvetica;mso-bidi-font-weight:bold’>
mso-fareast-font-family:Helvetica’>Data and Sources
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:
Helvetica;mso-bidi-font-weight:bold’>Data for the reports comes from three
sources. Detailed revenue, cost and expense data comes from an Azure SQL
database. Summary balance sheet data comes from Microsoft Dynamics 365 Business
Central. The balance sheet data is not related to the profit and loss results,
other than they both relate to dates.
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:
Helvetica;mso-bidi-font-weight:bold’>
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:
Helvetica;mso-bidi-font-weight:bold’>Monthly revenue and expense projections
for the next quarter come from a Microsoft SharePoint Online list. Quarterly
projections relate to the profit and loss results by using the following shared
dimensions: date, business unit, department, and product category.
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:
Helvetica;mso-bidi-font-weight:bold’>
mso-fareast-font-family:Helvetica’>Net Income Projection Data
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:
Helvetica;mso-bidi-font-weight:bold’>Net income projection data is stored in a
SharePoint Online list named Projections in the format shown in the following
table.
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-font-kerning:
0pt;mso-ansi-language:X-NONE;mso-bidi-font-weight:bold’>
src=”DA-100%20V12.files/image008.jpg” v:shapes=”_x0000_i1028″>lang=EN-US style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;
mso-fareast-font-family:”Times New Roman”;mso-bidi-font-weight:bold’>
lang=EN-US style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;
mso-fareast-font-family:Helvetica;mso-bidi-font-weight:bold’>Revenue
projections are set at the monthly level and summed to show projections for the
quarter.
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:
Helvetica;mso-bidi-font-weight:bold’>
mso-fareast-font-family:Helvetica’>Balance Sheet Data
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:
Helvetica;mso-bidi-font-weight:bold’>The balance sheet data is imported with
final balances for each account per month in the format shown in the following
table.
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-font-kerning:
0pt;mso-ansi-language:X-NONE;mso-bidi-font-weight:bold’>
src=”DA-100%20V12.files/image010.jpg” v:shapes=”_x0000_i1029″>
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:
Helvetica;mso-bidi-font-weight:bold’>There is always a row for each account for
each month in the balance sheet data.
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:
Helvetica;mso-bidi-font-weight:bold’>
mso-fareast-font-family:Helvetica’>Dynamics 365 Business Central Data
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:
Helvetica;mso-bidi-font-weight:bold’>Business Central contains a product
catalog that shows how products roll up to product categories, which roll up to
business units. Revenue data is provided at the date and product level. Expense
data is provided at the date and department level.
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:
Helvetica;mso-bidi-font-weight:bold’>
mso-fareast-font-family:Helvetica’>Business Issues
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:
Helvetica;mso-bidi-font-weight:bold’>Historically, it has taken two analysts a
week to prepare the reports for the quarterly board meetings. Also, there is
usually at least one issue each quarter where a value in a report is wrong
because of a bad cell reference in an Excel formula. On occasion, there are
conflicting results in the reports because the products and departments that
roll up to each business unit are not defined consistently.
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:
Helvetica;mso-bidi-font-weight:bold’>Planned Changes
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:
Helvetica;mso-bidi-font-weight:bold’>Contoso plans to automate and standardize
the quarterly reporting process by using Microsoft Power Bl. The company wants
to how long it takes to populate reports to less than two days. The company
wants to create common logic for business units, products, and departments to
be used across all reports, including, but not limited, to the quarterly
reporting for the board.
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:
Helvetica;mso-bidi-font-weight:bold’>
mso-fareast-font-family:Helvetica’>Technical Requirements
lang=EN-US style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;
mso-fareast-font-family:Helvetica;mso-bidi-font-weight:bold’>Contoso wants the
reports and datasets refreshed with minimal manual effort
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:
Helvetica;mso-bidi-font-weight:bold’>The company wants to provide a single
package of reports to the board that contains custom navigation and links to
supplementary information.
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:
Helvetica;mso-bidi-font-weight:bold’>Maintenance, including manually updating
data and access, must be minimized as much as possible.
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:
Helvetica;mso-bidi-font-weight:bold’>
mso-fareast-font-family:Helvetica’>Security Requirements
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:
Helvetica;mso-bidi-font-weight:bold’>The reports must be made available to the
board from powerbi.com. A mail-enabled security group will be used to share
information with the board.
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:
Helvetica;mso-bidi-font-weight:bold’>The analysts responsible for each business
unit must see all the data the board sees, except the profit and loss data,
which must be restricted to only their business unit’s data. The analysts must
be able to build new reports from the dataset that contains the profit and loss
data, but any reports that the analysts build must not be included in the
quarterly reports for the board. The analysts must not be able to share the
quarterly reports with anyone.
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:
Helvetica;mso-bidi-font-weight:bold’>
mso-fareast-font-family:Helvetica’>Report Requirements
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:
Helvetica;mso-bidi-font-weight:bold’>You plan to relate the balance sheet to a
standard date table in Power Bl in a many-to-one relationship based on the last
day of the month. At least one of the balance sheet reports in the quarterly
reporting package must show the ending balances for the quarter, as well as for
the previous quarter.
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:
Helvetica;mso-bidi-font-weight:bold’>
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:
Helvetica;mso-bidi-font-weight:bold’>Projections must contain a column named
RevenueProjection that contains the revenue projection amounts.
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:
Helvetica;mso-bidi-font-weight:bold’>A relationship must be created from
Projections to a table named Date that contains the columns shown in the
following table.
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-font-kerning:
0pt;mso-ansi-language:X-NONE;mso-bidi-font-weight:bold’>
src=”DA-100%20V12.files/image012.jpg” v:shapes=”_x0000_i1030″>lang=EN-US style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;
mso-bidi-font-weight:bold;mso-no-proof:yes’>
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:
“Times New Roman”;mso-bidi-font-weight:bold’>
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:
Helvetica;mso-bidi-font-weight:bold’>The relationships between products and
departments to business units must be consistent across all reports.
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:
Helvetica;mso-bidi-font-weight:bold’>The board must be able to get the
following information from the quarterly reports:
lang=EN-US style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;
mso-fareast-font-family:Helvetica;mso-bidi-font-weight:bold’>• Revenue trends
over time
lang=EN-US style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;
mso-fareast-font-family:Helvetica;mso-bidi-font-weight:bold’>• Ending balances
for each account
lang=EN-US style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;
mso-fareast-font-family:Helvetica;mso-bidi-font-weight:bold’>• A comparison of
expenses versus projections by quarter
lang=EN-US style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;
mso-fareast-font-family:Helvetica;mso-bidi-font-weight:bold’>• Changes in
long-term liabilities from the previous quarter
lang=EN-US style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;
mso-fareast-font-family:Helvetica;mso-bidi-font-weight:bold’>• A comparison of
quarterly revenue versus the same quarter during the prior year
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:
Helvetica;mso-bidi-font-weight:bold’>
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:
Helvetica;mso-bidi-font-weight:bold’>HOTSPOT
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:
Helvetica;mso-bidi-font-weight:bold’>You need to grant access to the business
unit analysts.
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:
Helvetica;mso-bidi-font-weight:bold’>What should you configure? To answer,
select the appropriate options in the answer area. NOTE: Each correct selection
is worth one point.
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-bidi-font-weight:
bold;mso-no-proof:yes’>
src=”DA-100%20V12.files/image014.jpg” v:shapes=”_x0000_i1031″>lang=EN-US style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;
mso-fareast-font-family:”Times New Roman”;mso-bidi-font-weight:bold’>
style=’mso-bidi-font-size:10.5pt;font-family:”Arial”,sans-serif;mso-fareast-font-family:
Helvetica’>