Overview -
Contoso, Ltd. is a manufacturing company that produces sports equipment. Contoso holds quarterly board meetings for which financial analysts manually prepare
Microsoft Excel reports, including balance sheets and profit and loss statements for each of the company's four business units.
Existing Environment -
Data and Sources -
Data for the reports comes from the sources shown in the following table.
 
The balance sheet data is unrelated to the profit and loss results other than they both relate to dates.
Balance Sheet Data -
The balance sheet data is imported and includes the final monthly balances of each account in the format shown in the following table.
 
The balance sheet data always includes a row for each account for each month.
Product Catalog Data -
The product catalog shows how products roll up to product categories, which roll up to the business units. The product list is provided in the format shown in the following table.
 
Revenue data is provided at the date and product level. Expense data is provided at the date and department level.
Business Issues -
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.
Requirements -
Planned Changes -
Contoso plans to automate and standardize the quarterly reporting process by using Power BI. The company wants to reduce how long it takes to populate the reports to less than two days. The company wants to create common logic for the business units, products, and departments. The logic will be used across all reports, including but not limited to the quarterly reporting for the board.
Technical Requirements -
Contoso wants the reports and datasets refreshed with minimum manual effort.
The company wants to provide the board with a single package of reports that will contain custom navigation and links to supplementary information.
Maintenance, including manually updating data and access, must be minimized as much as possible.
Security Requirements -
The reports must be made available to the board from powerbi.com. An Azure Active Directory (Azure AD) group will be used to share information with the board.
Contoso identifies the following security requirements for analyst access:
Analysts must be able to access all balance sheet and product catalog data.
Analysts must be able to access only the profit and loss data of their respective business unit.
Analysts must be able to create new reports from the dataset that contains the profit and loss data, but the reports built by the analysts must NOT be included in the quarterly reports for the board.
Analysts must NOT be able to share the quarterly reports with anyone.
Analysts must NOT be able to make new reports by using the balance sheet data.
Report Requirements -
You plan to relate the balance sheet table to a date table in Power BI 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.
The date table will contain the columns shown in the following table.
 
The definitions and attributes for the products, departments, and business units must be consistent across all the reports.
The board must be able to get the following information from the quarterly reports:
Revenue trends over time
The ending balances of each account
Changes in long-term liabilities from the previous quarter
The percent of total revenue contributed by each product category
A comparison of quarterly revenue versus the same quarter from the previous year
 
The reports must be updated with the latest data by 5 AM each day.
HOTSPOT -
How should you distribute the reports to the board? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
 
















 

Suggested Answer: 
    

Box 1: Using a workspace membership
Note 1: The company wants to provide the board with a single package of reports that will contain custom navigation and links to supplementary information.
Sharing is the easiest way to give people access to your reports and dashboards in the Power BI service. You can share with people inside or outside your organization.ֲ¨
Where you can share:
You can share reports and dashboards from My Workspace.
You can share from workspaces other than My Workspace, if you have the Admin or Member role in the workspace. If you have the Contributor or Viewer role, you can share if you have Reshare permissions.
You can share from the Power BI mobile apps.
You can't share directly from Power BI Desktop.
Box 2: A mail-enabled security group in Azure Active Directory
Mail-Enabled Security Group -
This group also contains a list of email addresses of members and can also be used to control access to OneDrive and SharePoint.
The Mail-Enabled Security Group can be created in the Office 365 Admin Portal
Note: The reports must be made available to the board from powerbi.com. An Azure Active Directory (Azure AD) group will be used to share information with the board.
Incorrect:
* Distribution Group
This group can also be called and Distribution List. The Distribution Group is a group which contains a list of email addresses of members, all of whom will be sent an email when an email is sent to the distribution groups email address.
The Distribution Group can be created in the Azure Active Directory
Reference:
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-share-dashboards
 https://www.fourmoo.com/2020/04/01/power-bi-which-groups-can-be-used-to-set-permissions-in-power-bi/

This question is in PL-300 Exam
For getting Microsoft Power BI Data Analyst Associate Certificate