QuickHelper

(10)

$20/per page/

About QuickHelper

Levels Tought:
Elementary,High School,College,University,PHD

Expertise:
Accounting,Applied Sciences See all
Accounting,Applied Sciences,Business & Finance,Chemistry,Engineering,Health & Medical Hide all
Teaching Since: May 2017
Last Sign in: 352 Weeks Ago, 4 Days Ago
Questions Answered: 20103
Tutorials Posted: 20155

Education

  • MBA, PHD
    Phoniex
    Jul-2007 - Jun-2012

Experience

  • Corportae Manager
    ChevronTexaco Corporation
    Feb-2009 - Nov-2016

Category > Accounting Posted 23 May 2017 My Price 11.00

Excel grader chapter 7 need to get 90 percent thank you

Question description

 

 

Vehicle Maintenance

 

Project Description:

In this project, you will import an Access database into the Data Model and use PowerPivot to create a PivotTable and Pivot Chart using multiple tables. Then you will create a Power View sheet.

Instructions:

For the purpose of grading the project you are required to perform the following tasks:

Step

Instructions

Points Possible

1

Start Excel. Open and save the downloaded Excel workbook named GO_e07_Grader_h2.xlsx.

0

2

Use PowerPivot to import both tables in the downloaded Access database 7F_Vehicle_Parts.accdb into the Data Model. 

Insert a PivotTable in a new worksheet. Rename the new sheet PivotTable.

10

3

Place the Supplier field from the Suppliers table in the COLUMNS area. From the Supply Order Summary table, place the Item field in the ROWS area, and the Quantity field in the VALUES area.

12

4

In cell B5, use Quick Explore to drill to Supply ID, and then drill to Item.

10

5

In PowerPivot, on the Supply Order Summary table, add a calculated column that multiplies [Quantity] * [Cost]. Rename the column Total. Copy the entire worksheet and paste it into cell A2 of the Vehicle Maintenance worksheet in the main workbook.

8

6

In PowerPivot, insert a PivotChart in a new worksheet. Rename the new sheet PivotChart.

2

7

Place the Supplier field from the Suppliers table in the LEGEND (SERIES) area. From the Supply Order Summary table, place the Total field in the VALUES area, and place the Year Ordered field in the AXIS (CATEGORY) area.

12

8

Insert a Power View report. Add the title Vehicle Maintenance Orders 2014 – 2016.

12

9

From the Supply Order Summary table, place the Item, Quantity, and Year Ordered fields (in that order) in the FIELDS area. Change the visualization to a Stacked Column chart.

12

10

Insert a Map visualization using the City, State, and Supplier fields from Suppliers and the Total field from Supply Order Summary. Resize the map to fill the right side of the canvas. Set the legend to display at the bottom.

12

11

Change the Power View worksheet Text Size to 75%. Set the background to Light 1 Center Gradient.

10

12

Ensure that the worksheets are correctly named and placed in the following order in the workbook: Power View1, PivotChart, PivotTable, Vehicle Maintenance. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.

0
 

Total Points

Answers

QuickHelper
(10)
Status NEW Posted 23 May 2017 12:05 PM My Price 11.00

Hel-----------lo -----------Sir-----------/Ma-----------dam----------- T-----------han-----------k Y-----------ou -----------for----------- us-----------ing----------- ou-----------r w-----------ebs-----------ite----------- an-----------d a-----------cqu-----------isi-----------tio-----------n o-----------f m-----------y p-----------ost-----------ed -----------sol-----------uti-----------on.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age----------- I -----------wil-----------l

Not Rated(0)