tutorial.dunder_mifflin_paper_sales

tutorial Updated about 3 years ago

Rows

1,000

Preview

order_id purchased_at status cancelled_at returned_at product_id product_name price discount shipping_cost quantity business_size payment_cycle account_id account_name account_manager days_to_close shipping_mode shipping_address shipping_city shipping_state shipping_zip shipping_region shipping_latitude shipping_longitude days_to_ship reviewed_at rating index review
6d9132b3-63b1-4cbb-961d-d05290a3ca80
2021-07-07T06:40:27
RETURNED
2021-07-08 11:14:03
3r02047pl
Hammermill Copy Plus Copy Paper, 92 Brightness, 20lb, 8-1/2 X 11, White, 200,000 Sheets/CT
6919.99
180.0
729.0
BIWEEK
60906229fc13ae0a6b0000b6
Trantow-Dickens
Stanley Hudson
5.0
REGULAR
71 Waxwing Court
Port Zoraville
MT
63644.0
West
37.754674
-90.380562
7.0
15.0
899f02ad-546b-41dd-a175-d2aae1201cdb
2021-03-11T20:08:03
CANCELLED
2021-03-22T07:36:57
3R11458
Xerox Bold 8.5" x 11" Cardstock Paper, 80 lbs, 94 Brightness, 250/Ream, 8 Reams/Carton
171.89
30.94
60.0
4063.0
60906229fc13ae0a6b00013d
Sanford Ltd
Michael Scott
115.0
6 Northwestern Hill
Veronicachester
PA
12455.0
Northeast
42.140733
-74.659478
15.0
b93e8afe-dcef-4d8e-aced-c0af1a4c7bd7
2021-03-24T10:29:39
CANCELLED
2021-07-08T01:21:10
191259
JAM Paper® Strathmore 24lb Paper, 8.5 x 11, Ivory Wove, 100 Sheets/Pack
13.29
20.0
519.0
60906229fc13ae0a6b0001a4
O'Conner-Davis
Erin Hannon
145.0
2 Goodland Place
Terryside
MT
5451.0
West
44.894578
-72.795246
5.0
61c13570-c857-46a4-8548-8ef110623083
2021-10-31T06:45:22
COMPLETED
3R02047
Xerox Vitality Multipurpose Paper, 8.5" x 11", 20 lbs., White, 500 Sheets/Ream, 10 Reams/Carton
65.99
8.58
100.0
40.0
724.0
ANNUAL
60906229fc13ae0a6b0002c9
O'Kon Group
Pam Beesly
20.0
EXPRESS
84767 Graceland Parkway
Wizaville
ME
27361.0
Northeast
35.86058
-80.099288
1.0
2021-11-24T16:06:58
4.0
5.0
Excellent customer service. The product itself is standard, but I enjoy working with my account manager so much that we end up resubscribing.
1c653e7e-3ff8-4daf-98f6-46afa01a5058
2021-08-15T21:26:37
COMPLETED
3R11458
Xerox Bold 8.5" x 11" Cardstock Paper, 80 lbs, 94 Brightness, 250/Ream, 8 Reams/Carton
171.89
5.16
100.0
140.0
4632.0
ANNUAL
60906229fc13ae0a6b000128
Senger-Hammes
Meredith Palmer
75.0
EXPRESS
5117 Continental Avenue
Nestorchester
HI
93634.0
West
37.22358
-119.000834
5.0
2021-09-13T17:50:37
3.0
4.0
Wish they had more selection. I have to order paper from various sources just to make sure that our company is completely stocked.
ffc9170f-851b-4819-850c-9e6ca7225fa6
2021-11-10T16:06:13
COMPLETED
91335
Neenah Paper Creative Collection Basic 8.5" x 11" Cardstock Paper, 65 lbs., 50 Sheets/Pack
3.69
160.0
902.0
WEEK
60906229fc13ae0a6b000028
Kutch-Witting
Oscar Martinez
146.0
REGULAR
279 La Follette Center
Vandervortburgh
NY
48793.0
Northeast
44.251183
-83.814184
1.0
2021-12-09T22:49:25
4.0
13.0
Excellent customer service. The product itself is standard, but I enjoy working with my account manager so much that we end up resubscribing.
8a1c4705-63b6-4a3d-84d7-1c172f471f06
2021-01-18T09:38:52
COMPLETED
191259
JAM Paper® Strathmore 24lb Paper, 8.5 x 11, Ivory Wove, 100 Sheets/Pack
13.29
100.0
210.0
952.0
BIWEEK
60906229fc13ae0a6b0002d4
Hill-Kutch
Stanley Hudson
51.0
EXPRESS
4 7th Parkway
Kodyville
AL
84272.0
South
40.770444
-111.901105
4.0
2021-02-02T12:31:40
3.0
6.0
Pretty good. The salesperson was not well prepared and couldn't answer many of our questions.
039a86fd-414a-42b9-9fec-6ee7999f51c8
2021-08-25T16:52:13
COMPLETED
OX9001
Boise X-9 Multipurpose Paper, 20 lbs., 92 Brightness, 500 Sheets/Ream, 10 Reams/Carton
78.19
100.0
50.0
503.0
ANNUAL
60906229fc13ae0a6b0003e5
Robel, Dooley and Prosacco
Oscar Martinez
18.0
EXPRESS
17 Southridge Park
Port Pauline
HI
13445.0
West
43.226377
-75.408248
6.0
2021-09-11T21:25:49
3.0
11.0
They get the job well, but not particularly well or in any special way. Solid, dependable.
90ad528e-95c2-4026-bfc0-5a442733c261
2021-12-07T14:03:47
COMPLETED
91335
Neenah Paper Creative Collection Basic 8.5" x 11" Cardstock Paper, 65 lbs., 50 Sheets/Pack
3.69
100.0
50.0
961.0
ANNUAL
60906229fc13ae0a6b000158
Volkman Group
Dwight Schrute
142.0
EXPRESS
2 Swallow Court
Rennertown
SC
31852.0
South
32.796402
-84.53509
4.0
2021-12-26T06:37:23
2.0
2.0
Rats chewed through my paper during the shipping process
38191650-9275-40bf-b936-7c8a7d8ceb06
2021-11-30T15:24:16
COMPLETED
191259
JAM Paper® Strathmore 24lb Paper, 8.5 x 11, Ivory Wove, 100 Sheets/Pack
13.29
140.0
637.0
BIWEEK
60906229fc13ae0a6b0001e4
Oberbrunner, Rolfson and Considine
Andy Bernard
69.0
REGULAR
0610 Reindahl Lane
South Malinda
HI
51990.0
West
40.734708
-95.156343
9.0
2021-12-17T08:12:16
4.0
5.0
Docking one star because they could have better selections and offers. Otherwise, I love Dundler Mifflin and see ourselves becoming repeat customers!