Product_Category Customer_Segment Payment_Method Region Sales_Channel Order_Status

Electronics Individual Credit Card South Online Cancelled

Clothing Business Bank Transfer East Online Completed
Home & Kitchen Wholesale Bank Transfer North Online Cancelled
Sports & OutdoorsWholesale Credit Card East Catalog Returned
Electronics Business Cash South Phone Pending
Electronics Individual Bank Transfer South In-store Cancelled
Electronics Wholesale Cash West Online Cancelled
Electronics Individual PayPal North Catalog Returned
Electronics Individual Bank Transfer South Catalog Cancelled
Clothing Wholesale Cash West Catalog Cancelled
Sports & OutdoorsIndividual Cash North In-store Returned
Home & Kitchen Wholesale PayPal South Online Completed
Home & Kitchen Individual Cash South Phone Returned
Home & Kitchen Wholesale Cash North Phone Completed
Home & Kitchen Business PayPal North Catalog Pending
Clothing Wholesale Bank Transfer North In-store Completed
Beauty & Health Wholesale Cash South In-store Completed
Sports & OutdoorsWholesale Cash South In-store Pending
Electronics Wholesale Cash West Phone Completed
Beauty & Health Individual Credit Card East Catalog Returned
Home & Kitchen Business PayPal North Online Completed
Beauty & Health Wholesale Credit Card South Phone Pending
Sports & OutdoorsIndividual PayPal South Catalog Returned
Electronics Business Bank Transfer North Catalog Pending
Electronics Business Bank Transfer East Online Pending
Sports & OutdoorsBusiness Cash North Online Cancelled
Sports & OutdoorsBusiness PayPal East Online Cancelled
Home & Kitchen Wholesale Bank Transfer South In-store Pending
Electronics Wholesale PayPal East Online Pending
Beauty & Health Individual Bank Transfer West Catalog Pending
Clothing Individual Credit Card South Online Cancelled
Clothing Individual Bank Transfer West Catalog Cancelled
Sports & OutdoorsBusiness Credit Card North Phone Completed
Home & Kitchen Business Bank Transfer North In-store Completed
Clothing Wholesale Cash North Phone Pending
Electronics Business Credit Card East Phone Returned
Sports & OutdoorsBusiness Bank Transfer South Catalog Returned
Beauty & Health Business Cash North Phone Cancelled
Sports & OutdoorsIndividual Credit Card North Catalog Cancelled
Beauty & Health Individual Cash South Online Cancelled
Sports & OutdoorsWholesale PayPal North Online Pending
Sports & OutdoorsBusiness PayPal West Catalog Returned
Sports & OutdoorsBusiness Credit Card South Online Completed
Beauty & Health Wholesale Bank Transfer South In-store Pending
Beauty & Health Business Credit Card South Phone Completed
Sports & OutdoorsBusiness Cash West In-store Completed
Clothing Individual Bank Transfer South Phone Pending
Home & Kitchen Wholesale PayPal West Online Completed
Home & Kitchen Wholesale Bank Transfer South In-store Returned
Home & Kitchen Wholesale PayPal East Online Completed
Beauty & Health Wholesale Bank Transfer North Phone Returned
Beauty & Health Individual Bank Transfer East Catalog Returned
Clothing Individual Bank Transfer North Catalog Returned
Home & Kitchen Business Cash West In-store Cancelled
Home & Kitchen Business Cash East Online Completed
Sports & OutdoorsBusiness Credit Card South Online Pending
Beauty & Health Business Credit Card North In-store Pending
Home & Kitchen Individual PayPal North Catalog Completed
Clothing Wholesale Cash East Phone Cancelled
Clothing Individual PayPal West In-store Cancelled
Home & Kitchen Business Credit Card East Phone Returned
Beauty & Health Individual PayPal West Catalog Completed
Clothing Wholesale Credit Card West Online Completed
Sports & OutdoorsWholesale Cash North Catalog Pending
Clothing Individual Bank Transfer East In-store Completed
Electronics Individual Cash East Online Cancelled
Electronics Individual PayPal West In-store Completed
Beauty & Health Business PayPal East In-store Pending
Home & Kitchen Individual Cash South Catalog Returned
Beauty & Health Individual Cash South In-store Pending
Beauty & Health Individual Credit Card East Catalog Pending
Beauty & Health Wholesale PayPal East Online Returned
Beauty & Health Wholesale PayPal West Catalog Pending
Sports & OutdoorsBusiness Cash South Online Pending
Sports & OutdoorsBusiness Bank Transfer South Catalog Completed
Clothing Wholesale PayPal North Phone Completed
Electronics Wholesale Bank Transfer West Phone Returned
Beauty & Health Wholesale Cash North In-store Completed
Clothing Individual Cash South Catalog Completed
Electronics Individual Credit Card West Catalog Pending
Home & Kitchen Wholesale PayPal East Online Cancelled
Sports & OutdoorsIndividual Bank Transfer West In-store Completed
Electronics Individual Credit Card East Catalog Cancelled
Home & Kitchen Business PayPal East In-store Completed
Electronics Wholesale Credit Card West Phone Completed
Sports & OutdoorsWholesale Cash East Catalog Returned
Sports & OutdoorsIndividual PayPal North Catalog Returned
Clothing Wholesale Credit Card South In-store Returned
Beauty & Health Business Credit Card East Catalog Cancelled
Electronics Business Bank Transfer North In-store Pending
Electronics Business Credit Card East Catalog Completed
Home & Kitchen Wholesale PayPal South Online Completed
Sports & OutdoorsWholesale PayPal North In-store Completed
Electronics Wholesale Bank Transfer South Catalog Cancelled
Sports & OutdoorsWholesale PayPal South Phone Returned
Electronics Wholesale Cash North Catalog Pending
Clothing Business PayPal North Phone Cancelled
Beauty & Health Individual PayPal North Phone Returned
Electronics Business Credit Card West Online Cancelled
Sports & OutdoorsWholesale Credit Card North In-store Pending
Average_Sale_Amount Quantity_Sold Discount_Rate Profit_Margin Delivery_Days City
599.34 21.69 0.12 0.12 1.81 San Jose
472.35 41.59 0.13 0.14 3.80 Los Angeles
629.54 43.15 0.15 0.27 5.01 San Diego
804.61 33.95 0.15 0.26 5.09 Philadelphia
453.17 46.77 0.03 0.20 4.10 Phoenix
453.17 58.08 0.05 0.21 6.25 Dallas
815.84 87.72 0.13 0.33 2.86 New York
653.49 53.49 0.13 0.14 4.72 Phoenix
406.11 55.15 0.13 0.25 5.24 Philadelphia
608.51 48.51 0.29 0.18 6.03 Phoenix
407.32 11.62 0.13 0.18 6.42 Philadelphia
406.85 49.47 0.16 0.31 2.75 Philadelphia
548.39 51.20 0.15 0.28 1.93 San Antonio
117.34 99.26 0.13 0.28 7.56 Houston
155.02 46.15 0.08 0.33 5.66 San Diego
387.54 56.03 0.14 0.20 3.50 San Antonio
297.43 49.31 0.06 0.27 8.10 Dallas
562.85 26.63 0.09 0.17 5.23 San Antonio
318.40 72.86 0.08 0.23 7.36 Chicago
217.54 65.04 0.10 0.19 5.14 Chicago
793.13 65.82 0.22 0.21 9.12 San Diego
454.84 31.81 0.01 0.26 8.51 Phoenix
513.51 78.06 0.13 0.12 4.50 Houston
215.05 21.96 0.02 0.41 6.94 San Diego
391.12 61.74 0.08 0.10 6.29 Philadelphia
522.18 93.81 0.15 0.08 7.74 Los Angeles
269.80 30.19 0.10 0.32 3.07 Houston
575.14 38.67 0.05 0.28 6.37 Houston
379.87 51.99 0.06 0.26 7.12 Philadelphia
441.66 39.93 0.13 0.26 1.48 Philadelphia
379.66 18.99 0.06 0.20 2.63 New York
870.46 51.37 0.11 0.11 1.00 San Diego
497.30 28.75 0.10 0.21 4.46 Philadelphia
288.46 59.47 0.07 0.13 6.44 Chicago
664.51 31.61 0.21 0.30 8.00 Dallas
255.83 81.00 0.13 0.19 5.15 Los Angeles
541.77 34.33 0.00 0.12 8.26 San Diego
108.07 43.56 0.11 0.17 2.24 San Jose
234.36 66.27 0.07 0.24 1.59 Chicago
539.37 25.38 0.14 0.14 4.89 Phoenix
647.69 54.55 0.06 0.12 5.77 Philadelphia
534.27 76.14 0.09 0.22 4.93 San Jose
476.87 17.85 0.13 0.22 1.00 Philadelphia
439.78 53.69 0.14 0.15 4.82 Houston
204.30 55.20 0.04 0.15 2.39 Chicago
356.03 65.64 0.08 0.22 6.34 Houston
407.87 25.26 0.08 0.06 5.73 New York
711.42 23.59 0.07 0.06 3.12 Houston
568.72 60.44 0.19 0.13 3.97 New York
147.39 55.94 0.12 0.18 2.88 New York
564.82 55.01 0.04 0.23 4.87 San Jose
422.98 56.93 0.15 0.35 6.91 Philadelphia
364.62 36.40 0.21 0.29 3.03 Phoenix
622.34 54.65 0.15 0.18 6.01 Houston
706.20 55.86 0.02 0.20 3.94 Chicago
686.26 35.71 0.08 0.10 3.41 New York
332.16 87.32 0.16 0.20 4.79 Philadelphia
438.16 59.48 0.06 0.17 2.93 Los Angeles
566.25 26.17 0.12 0.23 3.89 San Diego
695.11 63.13 0.14 0.12 2.60 San Jose
404.17 30.51 0.05 0.25 8.93 Phoenix
462.87 65.74 0.10 0.35 5.07 San Antonio
278.73 73.17 0.00 0.19 3.60 San Jose
260.76 33.59 0.05 0.24 5.43 Los Angeles
662.51 69.27 0.09 0.27 4.78 San Diego
771.25 58.26 0.04 0.16 4.56 Los Angeles
485.60 66.44 0.18 0.22 6.23 Houston
700.71 87.94 0.03 0.20 6.52 New York
572.33 45.09 0.08 0.21 3.94 Phoenix
370.98 34.93 0.11 0.12 3.85 Dallas
572.28 32.21 0.17 0.20 4.45 New York
807.61 33.68 0.03 0.25 1.00 Dallas
492.83 48.46 0.16 0.35 1.97 San Diego
812.93 56.82 0.10 0.30 7.73 Philadelphia
0.00 55.53 0.05 0.42 8.29 San Antonio
664.38 66.54 0.12 0.12 4.50 Chicago
517.41 50.26 0.11 0.29 6.15 New York
440.20 79.07 0.07 0.22 5.62 Phoenix
518.35 44.71 0.10 0.42 11.16 Los Angeles
102.49 104.40 0.08 0.12 7.24 Phoenix
456.07 62.51 0.11 0.12 4.74 San Diego
571.42 32.86 0.13 0.14 3.09 Dallas
795.58 28.58 0.18 0.00 1.79 Los Angeles
396.35 59.65 0.04 0.15 5.41 Chicago
338.30 45.53 0.21 0.12 3.49 Chicago
399.65 64.28 0.00 0.22 2.16 New York
683.08 59.46 0.09 0.23 3.71 San Diego
565.75 48.54 0.13 0.39 2.84 Philadelphia
394.05 33.06 0.11 0.30 8.37 San Diego
602.65 19.70 0.07 0.14 6.76 Dallas
519.42 41.07 0.09 0.11 4.98 Phoenix
693.73 67.13 0.08 0.25 7.96 Chicago
359.59 54.28 0.07 0.07 5.15 Phoenix
434.47 25.09 0.14 0.38 3.28 Phoenix
421.58 53.46 0.12 0.32 8.05 Phoenix
207.30 57.71 0.07 0.15 6.08 Chicago
559.22 32.32 0.14 0.03 2.93 San Jose
552.21 53.07 0.12 0.34 4.62 Houston
501.02 51.16 0.14 0.19 3.25 Dallas
453.08 27.14 0.13 0.32 2.23 San Jose
Product_Category Delivery_Days Product Category Average Delivery Days
Electronics 1.81 #NAME? 5.07
Clothing 3.80 #NAME? 4.38
Home & Kitchen 5.01 #NAME? 5.19
Sports & Outdoors 5.09 #NAME? 4.94
Electronics 4.10 #NAME? #NAME?
Electronics 6.25
Electronics 2.86
Electronics 4.72 Average Delivery Days by Product Category
Electronics 5.24 5.40
Clothing 6.03
5.20
Sports & Outdoors 6.42
Home & Kitchen 2.75 5.00

Home & Kitchen 1.93 4.80

Home & Kitchen 7.56 4.60
Home & Kitchen 5.66
4.40
Clothing 3.50
Beauty & Health 8.10 4.20
Sports & Outdoors 5.23 4.00
Electronics 7.36
3.80
Beauty & Health 5.14 #NAME? #NAME? #NAME? #NAME? #NAME?
Home & Kitchen 9.12
Beauty & Health 8.51
Sports & Outdoors 4.50
Electronics 6.94
Electronics 6.29
Sports & Outdoors 7.74
Sports & Outdoors 3.07
Home & Kitchen 6.37
Electronics 7.12
Beauty & Health 1.48
Clothing 2.63
Clothing 1.00
Sports & Outdoors 4.46
Home & Kitchen 6.44
Clothing 8.00
Electronics 5.15
Sports & Outdoors 8.26
Beauty & Health 2.24
Sports & Outdoors 1.59
Beauty & Health 4.89
Sports & Outdoors 5.77
Sports & Outdoors 4.93
Sports & Outdoors 1.00
Beauty & Health 4.82
Beauty & Health 2.39
Sports & Outdoors 6.34
Clothing 5.73
Home & Kitchen 3.12
Home & Kitchen 3.97
Home & Kitchen 2.88
Beauty & Health 4.87
Beauty & Health 6.91
Clothing 3.03
Home & Kitchen 6.01
Home & Kitchen 3.94
Sports & Outdoors 3.41
Beauty & Health 4.79
Home & Kitchen 2.93
Clothing 3.89
Clothing 2.60
Home & Kitchen 8.93
Beauty & Health 5.07
Clothing 3.60
Sports & Outdoors 5.43
Clothing 4.78
Electronics 4.56
Electronics 6.23
Beauty & Health 6.52
Home & Kitchen 3.94
Beauty & Health 3.85
Beauty & Health 4.45
Beauty & Health 1.00
Beauty & Health 1.97
Sports & Outdoors 7.73
Sports & Outdoors 8.29
Clothing 4.50
Electronics 6.15
Beauty & Health 5.62
Clothing 11.16
Electronics 7.24
Home & Kitchen 4.74
Sports & Outdoors 3.09
Electronics 1.79
Home & Kitchen 5.41
Electronics 3.49
Sports & Outdoors 2.16
Sports & Outdoors 3.71
Clothing 2.84
Beauty & Health 8.37
Electronics 6.76
Electronics 4.98
Home & Kitchen 7.96
Sports & Outdoors 5.15
Electronics 3.28
Sports & Outdoors 8.05
Electronics 6.08
Clothing 2.93
Beauty & Health 4.62
Electronics 3.25
Sports & Outdoors 2.23
Product Category

#NAME? #NAME?
Average_Sale_AmountQuantity_Sold Region Region Total AVG SalesTotal Quantity
599.34 21.69 South #NAME? 13905.52 1265.01
472.35 41.59 East #NAME? 11513.56 #NAME?
629.54 43.15 North #NAME? 12803.22 #NAME?
804.61 33.95 East #NAME? 9724.72 #NAME?
453.17 46.77 South
453.17 58.08 South
815.84 87.72 West
653.49 53.49 North Sales and Quantity by Regions
406.11 55.15 South
16000.00
608.51 48.51 West
407.32 11.62 North 14000.00
406.85 49.47 South
12000.00
548.39 51.20 South
117.34 99.26 North 10000.00
155.02 46.15 North
8000.00
387.54 56.03 North
297.43 49.31 South 6000.00
562.85 26.63 South
4000.00
318.40 72.86 West
217.54 65.04 East 2000.00
793.13 65.82 North
454.84 31.81 South 0.00
#NAME? #NAME? #NAME?
513.51 78.06 South
215.05 21.96 North Total AVG Sales Total Quantity

391.12 61.74 East

522.18 93.81 North
269.80 30.19 East
575.14 38.67 South
379.87 51.99 East
441.66 39.93 West
379.66 18.99 South
870.46 51.37 West
497.30 28.75 North
288.46 59.47 North
664.51 31.61 North
255.83 81.00 East
541.77 34.33 South
108.07 43.56 North
234.36 66.27 North
539.37 25.38 South
647.69 54.55 North
534.27 76.14 West
476.87 17.85 South
439.78 53.69 South
204.30 55.20 South
356.03 65.64 West
407.87 25.26 South
711.42 23.59 West
568.72 60.44 South
147.39 55.94 East
564.82 55.01 North
422.98 56.93 East
364.62 36.40 North
622.34 54.65 West
706.20 55.86 East
686.26 35.71 South
332.16 87.32 North
438.16 59.48 North
566.25 26.17 East
695.11 63.13 West
404.17 30.51 East
462.87 65.74 West
278.73 73.17 West
260.76 33.59 North
662.51 69.27 East
771.25 58.26 East
485.60 66.44 West
700.71 87.94 East
572.33 45.09 South
370.98 34.93 South
572.28 32.21 East
807.61 33.68 East
492.83 48.46 West
812.93 56.82 South
0.00 55.53 South
664.38 66.54 North
517.41 50.26 West
440.20 79.07 North
518.35 44.71 South
102.49 104.40 West
456.07 62.51 East
571.42 32.86 West
795.58 28.58 East
396.35 59.65 East
338.30 45.53 West
399.65 64.28 East
683.08 59.46 North
565.75 48.54 South
394.05 33.06 East
602.65 19.70 North
519.42 41.07 East
693.73 67.13 South
359.59 54.28 North
434.47 25.09 South
421.58 53.46 South
207.30 57.71 North
559.22 32.32 North
552.21 53.07 North
501.02 51.16 West
453.08 27.14 North
al Quantity
Chart Title

#NAME?

#NAME?

and Quantity by Regions #NAME?

#NAME?

0.00 2000.00 4000.00 6000.00 8000.00 10000.00 12000.00 14000.00 160

Total Quantity Total AVG Sales

Chart Title
16000.00

14000.00

12000.00
#NAME? #NAME? #NAME?
10000.00
Total AVG Sales Total Quantity
8000.00

6000.00

4000.00

2000.00

0.00
#NAME? #NAME? #NAME? #NAME?

Total AVG Sales Total Quantity

e

0 10000.00 12000.00 14000.00 16000.00

al AVG Sales

le

#NAME? #NAME?

otal Quantity