Pivot Table

demmyemi

DYS546_course_project_part_one.xlsx

Home >Business & Finance homework help >Pivot Table

Part One Instructions

Course Project

Part One: Relating Data

Instructions:

You have been provided elecronic files that contain crucial data to assist management in a review of operations. For Relationship Management purposes, the CEO is interested to know which Sales Reps sell to which companies. Once this is determined, a budget for Sales Rep travel can be developed for the coming year.

Each file contains data relevant to the department it came from and cannot be merged. You have one tab of data already in .XLS format. Import the .txt file into a new tab in this file. Name the tab "Sales Report". Next, import the .accdbs file into an additional tab. Name the tab "Sales Rep ID". Once there are three tabs of data, create a data model in this workbook that will allow you to create a pivot table using all tabs.

Once you have created the data model, design a pivot table that will illustrate the following:

● Sales will be illustrated as values in the pivot table.

● Sales Rep Name will illustrate in the columns of the pivot table.

● Company Name will be illustrated in the rows of the pivot table.

● Be sure to properly format numbers and edit labels in the pivot table.

To complete this project, save the Sales Rep ID.accdb and Sales Report.txt files to your desktop.

To submit this assignment, please refer to the instructions in the course.

Company Data

Company	Company Code
Non Sollicitudin A Limited	977372-7467
Sit Amet Institute	667177-2868
Duis Dignissim Tempor LLC	306039-4099
Nulla PC	894439-5907
Elit Dictum Eu LLC	743066-5302
Purus Mauris Institute	028002-7160
Vel Vulputate Corp.	574697-0762
Lobortis Quis Industries	174597-7650
Arcu Vestibulum Ante Limited	449019-8027
Felis Nulla Foundation	027634-7796
Suscipit Associates	969012-1430
Rutrum Magna Cras Limited	374133-1445
Mauris Corporation	859464-7490
In Nec Orci PC	248404-1708
Orci LLC	259822-4844
Ornare Lectus Justo Ltd	809754-3691
Torquent Per Conubia Incorporated	828889-0216
Suspendisse Institute	369263-1504
Proin Ultrices Associates	635558-8747
Ipsum Non Arcu Limited	052951-9050
Venenatis Vel Corp.	446499-4203
Massa Corp.	665311-2380
Dui Cras Pellentesque Incorporated	679826-6182
Fermentum Arcu Consulting	893267-7282
Dignissim Magna A Inc.	444677-0077
Et Ultrices Incorporated	783967-4731
Diam Eu Foundation	182309-5037
Lobortis Quis Associates	683316-4863
Duis Sit LLC	997274-7522
A Corp.	084086-5968
Senectus Inc.	847651-3539
Enim Industries	388224-2088
Eget Varius LLP	835654-6161
Lobortis Ultrices Industries	783553-4210
Dapibus Ligula LLC	845817-6875
Libero Donec Industries	457207-5580
Ipsum Curabitur Company	675703-7251
Sagittis Lobortis Incorporated	797030-5608
Non Dui Corp.	106511-0353
Donec Limited	067096-1069
Vitae Orci Limited	307971-2711
Amet Orci Consulting	604717-9871
Diam Company	017951-2892
Penatibus PC	613391-7069
Etiam Imperdiet Corporation	012665-0696
Eget Odio Consulting	272545-9792
Metus Facilisis Foundation	206667-1112
Metus Limited	986874-9335
Feugiat Corp.	854981-5317
Enim Curabitur Massa Corp.	319870-2643
Scelerisque Mollis Corp.	737434-3239
Magna Inc.	208320-2024
Eros Industries	329076-2917
Ipsum Suspendisse Sagittis Limited	762217-0160
Non Incorporated	298203-3140
Ut LLC	163447-5568
Ut Cursus Luctus Inc.	418483-1578
Non Cursus Corp.	017279-9751
Velit Justo Industries	962513-2619
Est Congue A Foundation	677107-6186
Penatibus Et Magnis Company	803709-7071
Vitae Erat Vel Limited	493471-6111
Sapien Molestie Company	704442-8535
Eget Consulting	267214-4298
Sit Amet PC	397104-6317
Nonummy Institute	148192-3694
Eu Limited	745671-1972
Lacus LLC	903455-8214
Sed Molestie Consulting	708365-8612
Eget Venenatis LLC	518692-9732
Gravida Praesent Eu PC	949855-0004
Semper Limited	152508-4438
Ut Dolor Ltd	509662-7897
Faucibus Ut Nulla Ltd	966908-5533
Consectetuer Euismod LLP	999539-3387
Vivamus Industries	157944-5931
Lorem Tristique LLC	635926-5466
Iaculis Consulting	129555-6904
Ullamcorper Duis Company	189292-5452
Porttitor Scelerisque Neque Company	984880-8995
In Faucibus Orci Corp.	269465-3961
Elit Institute	046222-2654
Dolor Inc.	648589-8131
Sapien Nunc PC	304466-7982
Nam Company	812196-9318
Nibh Quisque Nonummy LLC	026303-7855
Nec Euismod Company	387891-2637
Ut Eros Non PC	802234-2300
Eu Eleifend Company	449873-7768
Suspendisse Inc.	933165-8881
Et Netus Corp.	616878-0077
Enim Etiam Ltd	136311-8868
Nascetur Ridiculus Company	454008-4896
Suscipit Est Ac Inc.	857471-0227
Justo Praesent Luctus PC	935471-6582
Erat Consulting	475806-5876
Arcu Imperdiet Company	632304-1134
Gravida Nunc Sed Incorporated	566317-7557
Mauris Blandit Enim Company	163571-5715
Sed Diam Lorem Associates	354019-1727