+ Steps to Penorm! Step Instructions 1 Start Excel. Open the downloaded file named Excel_CH13 PS1_Metrics.xlsx. Grader has automatically added your last name to the beginning of the filename. Save the file to the location where you are storing your files. 2 To build an interactive dashboard from multiple tables, each table must first be added to the data model On the Sales Data worksheet tab, add each of the tables to the data model. 3 Edit the data model by completing the following tasks on the SalesData2021 worksheet: Format the Purchase Date field as 3/14/2001 Format the Price field as Currency Create a calculated column to the right of Year with the name Revenue. Use the formula =[Price][Quantity] to calculate the revenue generated from each sale. Format the column as Currency. 5 In Power Pivot, create a calculated field for sum of revenue in the Calculation Area just below the Revenue column. Copy the calculated field and paste it as text into cell J41 of the MetricsRestboard worksheet in the main workbook. From the Power Pivot window, create a KPI that measures the Sum of Revenue value against the absolute value of $500.00. Maintain the default thresholds of 200 and 400 and select the fourth set of icon styles. Create a relationship between SalesData2021 and Volumeme using the EmaxRAID field. 6 In the Power Pivot window, create a Chart and Table (Horizontal) combination on the MetricsRashboard worksheet in cell B2. In the PivotChart, drag the Category field from SalesData2021 to the Axis (Categories) area. Drag the Quantity field from SalesData2021 to the Values area to calculate the sum of quantity sold. Change the chart type to a Pie chart. Apply Style 9 to the PivotChart. Add a Chart Title that reads Volume Sales by Category. Add a Timeline slicer connected to the PivotChart, click the Pursbassenate check box, and position it below the chart. Apply the Light Green, TimelineSble Light 6 to the slicer. Step Instructions 7 Name the PivotTable EmployeeRxGoals, Drag the LastName field from VolumeRxEme to the Rows area. Drag the Sum of Revenue Value field from SalesData2021 to the Values area. Drag the Sum of Revenue KPI Status field to the Values area. Rename the Row Labels heading in J2 to Employees. Rename the Sum of Revenue heading in K2 to 2021 Revenue. Rename the Sum of Revenue Status heading in L2 as $500 Goal Status. If necessary, resize the column to fit the text. Apply the Pivot Table Style, Light Green, Pivot Style Medium 14 to the PivotTable. 8 From the Power Pivot window, create a PivotTable on the Metrics Dashboard worksheet in cell B25. Drag the State field from OrdersyState to the Rows area and the Orders field to the Values area. Convert the Pivot Table to formulas. Change the label in cell B25 to State. 9 Insert a Filled Map chart to the MatriceRashboard, worksheet and complete the following. Change the chart title to Number of Orders by State. Position the map within the cell range B25:H39. 10 Prepare the dashboard for production by hiding the SalesData worksheet. Hide the column and row headings as well as the gridlines on the MetricsRastboard worksheet 11 Minimize the ribbon. Protect the worksheet, allowing only to Use PivotTable & PivotChart and Edit objects. 12 Save and close Excel_Ch13_PS1_Metrics.xlsx. Exit Excel. Submit your files as directed. Total Points Points Possible 0 10 6 8 6 15 Points Possible 22 8 10 9 6 0 100

Question

24-05-2023
Business

contestada

+ Steps to Penorm! Step Instructions 1 Start Excel. Open the downloaded file named Excel_CH13 PS1_Metrics.xlsx. Grader has automatically added your last name to the beginning of the filename. Save the file to the location where you are storing your files. 2 To build an interactive dashboard from multiple tables, each table must first be added to the data model On the Sales Data worksheet tab, add each of the tables to the data model. 3 Edit the data model by completing the following tasks on the SalesData2021 worksheet: Format the Purchase Date field as 3/14/2001 Format the Price field as Currency Create a calculated column to the right of Year with the name Revenue. Use the formula =[Price][Quantity] to calculate the revenue generated from each sale. Format the column as Currency. 5 In Power Pivot, create a calculated field for sum of revenue in the Calculation Area just below the Revenue column. Copy the calculated field and paste it as text into cell J41 of the MetricsRestboard worksheet in the main workbook. From the Power Pivot window, create a KPI that measures the Sum of Revenue value against the absolute value of $500.00. Maintain the default thresholds of 200 and 400 and select the fourth set of icon styles. Create a relationship between SalesData2021 and Volumeme using the EmaxRAID field. 6 In the Power Pivot window, create a Chart and Table (Horizontal) combination on the MetricsRashboard worksheet in cell B2. In the PivotChart, drag the Category field from SalesData2021 to the Axis (Categories) area. Drag the Quantity field from SalesData2021 to the Values area to calculate the sum of quantity sold. Change the chart type to a Pie chart. Apply Style 9 to the PivotChart. Add a Chart Title that reads Volume Sales by Category. Add a Timeline slicer connected to the PivotChart, click the Pursbassenate check box, and position it below the chart. Apply the Light Green, TimelineSble Light 6 to the slicer. Step Instructions 7 Name the PivotTable EmployeeRxGoals, Drag the LastName field from VolumeRxEme to the Rows area. Drag the Sum of Revenue Value field from SalesData2021 to the Values area. Drag the Sum of Revenue KPI Status field to the Values area. Rename the Row Labels heading in J2 to Employees. Rename the Sum of Revenue heading in K2 to 2021 Revenue. Rename the Sum of Revenue Status heading in L2 as $500 Goal Status. If necessary, resize the column to fit the text. Apply the Pivot Table Style, Light Green, Pivot Style Medium 14 to the PivotTable. 8 From the Power Pivot window, create a PivotTable on the Metrics Dashboard worksheet in cell B25. Drag the State field from OrdersyState to the Rows area and the Orders field to the Values area. Convert the Pivot Table to formulas. Change the label in cell B25 to State. 9 Insert a Filled Map chart to the MatriceRashboard, worksheet and complete the following. Change the chart title to Number of Orders by State. Position the map within the cell range B25:H39. 10 Prepare the dashboard for production by hiding the SalesData worksheet. Hide the column and row headings as well as the gridlines on the MetricsRastboard worksheet 11 Minimize the ribbon. Protect the worksheet, allowing only to Use PivotTable & PivotChart and Edit objects. 12 Save and close Excel_Ch13_PS1_Metrics.xlsx. Exit Excel. Submit your files as directed. Total Points Points Possible 0 10 6 8 6 15 Points Possible 22 8 10 9 6 0 100

Respuesta :

Otras preguntas

Which scenario is the best example of the "tragedy of the commons?" A country experiences widening income inequality. Two countries engaged in international tra

Which of these connections was illustrated by the reign of ashurbanipal?

What is similar about a satire and a parable? O A. Both are based on a previous work. O B. Both attempt to persuade an audience. O C. Both use humor to entertai

What factors might push a person to immigrate to another country? What might be some of the greatest challenges and rewards for them?

Which activity is part of the prewriting process?Aproofreading to correct grammatical errorsB. doing research for information about a topicc.rechecking the fact

Anthony is making A collage for his art class my picking Shapes randomly. He has five squares, two triangles, two ovals, and four circles. find p( circle is ch

Peggy, a 62-year-old woman, has been unable to work for the past year because of a back injury that she sustained at her job as a cafeteria worker. Her adult so

The term globalization is best defined as: A. a reduction in the political and military power of imperial countries over their colonies. B. an increasing intera

If x is 6, then 7x= A. 13 B. 42 C. 42x D. 76

Solve |2x - 6| > 10 {x|x < -8 or x > 2} {x|x < -2 or x > 8} {x|-2 < x < 8}