Module 03 Course Project - Data Retrieval

User Generated

Wrjryf

Business Finance

Description

se the 2014 Fourth Quarter spreadsheet for this deliverable.

Take the original spreadsheet and delete the columns that will not be necessary in your analysis.

In the same Excel spreadsheet, create a new tab called "Module 03 Explanation". In the Module 03 Explanation tab, provide an explanation on the fields that you will use and the fields that you eliminated. What was your reasoning?

Submit the edited spreadsheet with only the fields you will use to determine if the sales consultants are in policy.

Submit your completed assignments to the drop box below. Please check the Course Calendar for specific due dates.

Save your spreadsheet as a Microsoft Excel. (Mac users, please remember to append the ".xls" extension to the filename.) The name of the files should be your first initial and last name, followed by an underscore and the name of the assignment, and an underscore and the date. An example is shown below:

Unformatted Attachment Preview

Module 03 Course Project - Data Retrieval Use the 2014 Fourth Quarter spreadsheet for this deliverable. Take the original spreadsheet and delete the columns that will not be necessary in your analysis. In the same Excel spreadsheet, create a new tab called "Module 03 Explanation". In the Module 03 Explanation tab, provide an explanation on the fields that you will use and the fields that you eliminated. What was your reasoning? Submit the edited spreadsheet with only the fields you will use to determine if the sales consultants are in policy. Submit your completed assignments to the drop box below. Please check the Course Calendar for specific due dates. Save your spreadsheet as a Microsoft Excel. (Mac users, please remember to append the ".xls" extension to the filename.) The name of the files should be your first initial and last name, followed by an underscore and the name of the assignment, and an underscore and the date. An example is shown below:
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

please use thiscopy

Sales System Number
265801-2014111
265801-2014111
315320-2014111
265980-2014111
329247-2014111
399053-2014111
407197-2014111
407886-2014111
410718-2014111
265005-2014111
265288-2014111
265440-2014111
265778-2014111
265758-2014111
265068-2014111
265609-2014111
265862-2014111
266104-2014111
265823-2014111
330618-2014111
332509-2014111
333704-2014111
407148-2014111
265752-2014111
265848-2014111
266106-2014111
331393-2014111

Date of Sale
Extract Date
Sales Consultant ID
10/1/2014
11/1/2014
35353356
10/1/2014
11/1/2014
66464667
10/3/2014
11/1/2014
57575758
10/3/2014
11/1/2014
75265980
10/5/2014
11/1/2014
83748200
10/10/2014
11/1/2014
26354410
10/11/2014
11/1/2014
33407197
10/12/2014
11/1/2014
40278386
10/13/2014
11/1/2014
41107218
10/14/2014
11/1/2014
26150025
10/20/2014
11/1/2014
26354410
10/20/2014
11/1/2014
26354410
10/20/2014
11/1/2014
26356778
10/20/2014
11/1/2014
26457518
10/20/2014
11/1/2014
26520168
10/20/2014
11/1/2014
26526109
10/25/2014
11/1/2014
12658262
10/25/2014
11/1/2014
26161204
10/25/2014
11/1/2014
26531823
10/26/2014
11/1/2014
33011618
10/26/2014
11/1/2014
33255099
10/28/2014
11/1/2014
33233704
10/28/2014
11/1/2014
43207148
10/30/2014
11/1/2014
26325752
10/30/2014
11/1/2014
26621106
10/30/2014
11/1/2014
26621106
10/31/2014
11/1/2014
33135393

SC Last name
Rucco
Wiare
Frank
Manuter
Travas
Smith
Heston
Nova
Buster
Jones
Smith
Smith
Dimit
Hansen
Vega
Periter
Wearever
Uarlike
Nayen
Kite
York
Amisher
Bush
Regan
Justin
Justin
Williams

SC First Name
Adriano F
Carol P.
Benjamin
Victor
Francisco A
Debbie
Kelly L
Jeremy S
Jacqueline M
Jennifer
Debbie
Debbie
Enrique
Vanessa
William
Eugene
Erick
Yaniri A
Alicia
David N
Alex V
Aisha T
Douglas B
Andres A
Micah Rae
Micah Rae
Clarence P

State
NY
GA
FL
NY
TX
FL
AR
AR
MS
NY
FL
FL
FL
NY
NY
NY
NY
NY
IL
KY
NY
NY
AR
NY
LA
LA
KY

Office
MANHATTAN
ATLANTA
MIAMI
MANHATTAN
EL PASO
MIAMI
Arkansas
Arkansas
Tri-State
MANHATTAN
MIAMI
MIAMI
MIAMI
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
MANHATTAN
CHICAGO
LOUISVILLE
MANHATTAN
BRONX
Arkansas
MANHATTAN
NEW ORLEANS
NEW ORLEANS
LOUISVILLE

Region
NORTH
SOUTH
FL/HI
NORTH
SOUTH
FL/HI
SOUTHWEST
SOUTHWEST
SOUTHWEST
NORTH
FL/HI
FL/HI
FL/HI
NORTH
NORTH
NORTH
NORTH
NORTH
NORTH
SOUTH
NORTH
NORTH
SOUTHWEST
NORTH
SOUTH
...


Anonymous
Excellent resource! Really helped me get the gist of things.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags