- All Exams Instant Download
Which type of calculation and which formula should you use?
HOTSPOT You need to calculate the last day of the month in the balance sheet data to ensure that you can relate the balance sheet data to the Date table. Which type of calculation and which formula should you use? To answer, select the appropriate options in the answer area....
Which two actions should you perform?
You have a report that contains three pages. One of the pages contains a KPI visualization. You need to filter all the visualizations in the report except for the KPI visualization. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is...
Which type of visualization should you use?
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 . scatter chartB . ribbon chartC...
What should you do?
You need to configure access for the sales department users. The solution must me meet the security requirements. What should you do?A . Add the sales department as a member of the reports workspaceB . Add the Azure Active Directory group of the sales department as an Admin of the...
Which report setting should you configure?
You publish a report to a workspace named Customer Services. The report identifies customers that have potential data quality issues that must be investigated by the customer services department of your company. You need to ensure that customer service managers can create task lists in Microsoft Excel based on the...
You have a report page that contains the visuals shown in the following exhibit
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. View AnswerAnswer: Explanation: Box 1: cross-filter...
What should you do in Microsoft Power Bl Desktop?
You have a Microsoft SharePoint Online site that contains 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 load only the manufacturing reports to a table for analysis. What should you...
What will the value be when the step is applied?
You create the following step by using Power Query Editor. = Table.ReplaceValue(SalesLT_Address,"1318","1319",Replacer.ReplaceText,{"AddressLine1"}) A row has a value of 21318 Lasalle Street in the AddressLine1 column. What will the value be when the step is applied?A . 1318B . 1319C . 21318 Lasalle StreetD . 21319 Lasalle StreetView AnswerAnswer: D Explanation:...
What should you create to meet the reporting requirements of the sales department?
What should you create to meet the reporting requirements of the sales department?A . a measure that uses a formula of SUM (Sales [sales_id])B . a calculated column that use a formula of COUNTA (sales [sales_id])C . a measure that uses a formula of COUNTROWS (Sales)D . a calculated column...
How should you configure the visual?
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...
