Creating an excel spreadsheet using pivot tables by using the attachments below

 

MGIS 3310: Assignment 4PivotTable data analysis using a Data Model inExcel 2013 (100 points = 10%)In this assignment, you will useMicrosoft Excel 2013 and Power Pivot add-into build a PivotTable reportthat combines data from multiple tables. (Source: https://support.office.com/en-us/article/Tutorial-PivotTable-data-analysis-using-a-Data-Model-in-Excel-2013-f9ad8310-3b5b-48a3-913d-5cc1b364ee46?ui=en-US&rs=en-US&ad=US)To check if your Excel hasPower Pivot add-inand enable it,Go toFile>Options>Add-Ins.In theManagebox, clickCOM Add-ins>Go. Check theMicrosoft Office Power Pivot in Microsoft Excel2013box, and then clickOK.If you don’t haveExcel2013withPower Pivot add-in, you can access it via SHSU Remote DesktopConnection (RDC); see How to at:http://www.shsu.edu/dept/it@sam/technology-tutorials/remote_desktop/Note: You may have to type your user name as:shsu\your usernameIMPORTANT:If you use RDC or a campus computer, you MUST skip step 1 & 2 below and start fromstep 3. At step 5, go to this folder “T:\Mis\Wipawayangkool\ContosoV2" (under Common Drive (T:)). This"ContosoV2" folder contains the already extracted files.Let’s start by importing some data.1.Download sample data (ContosoV2) from Blackboard.2.Right-click the file to Extract and save all the data files in a location easily accessible, such as Desktop,Downloads, or My Documents.3.In Excel, open a blank workbook.4.ClickData>From Access.5.Go to the folder that contains the sample data files and selectContosoSales.6.ClickOpen. Because you are connecting to a database file that contains multiple tables, theSelectTabledialog appears so that you can choose which tables to import. In Select Table, checkEnableselection of multiple tables. Chooseallof the tables and clickOK.7.In Import Data, clickPivotTable Reportand clickOK.NotesYou’ve just created a data model. The model is a data integration layer that’s createdautomatically when you import or work with multiple tables simultaneously in the same PivotTablereport. The model is mostly transparent in Excel, but you can view and modify it directly using the