Answer To: Microsoft Word - ITECH1103 Analytic Group Presentation - Semester XXXXXXXXXXdocx Weight – 10% Due...
Pooja answered on Jan 28 2021
customer data
Table of Contents
Executive Summary 3
Background information 4
Analysis 5
1) Data dictionary 5
2) Number of Customers 6
3) Customers and countries 7
4) Country and Revenue 7
5) Customers and total revenue 8
6) days to place and order 9
7) Customer type and quantity ordered 10
8) Customer type and quantity ordered 11
9) top 5 countries with respect to each customer type 12
10) customer type and continent by quantity ordered 13
11) Title 14
12) Days of Delivery 14
13) Most efficient predictor of Quantity ordered 15
14) country of customer 16
15) Cluster Analysis for Quantity ordered on basis of Customer Type 16
16) Days to delivery for each continent type by customer type. 16
17) days to delivery by customer type name 18
18) days to deliver & number of orders by order type 18
19) cost, days to deliver and discount percent 19
20) customer type with unit cost and quantity ordered 19
Discussion of findings 20
2) Number of Customers 20
3) Customers and countries 20
4) Country and Revenue 20
5) Customers and total revenue 20
6) days to place an order 20
7) Customer and quantity ordered 21
8) Customer type and quantity ordered 21
9) top 5 countries with respect to each customer type 21
10) customer type and continent by the quantity ordered 21
11) Title 22
12) Days of Delivery 22
13) Most efficient predictor of Quantity ordered 22
14) country of the customer 22
15) Cluster Analysis for Quantity ordered on basis of Customer Type 22
16) Days to delivery for each continent type by customer type. 22
17) days to delivery by customer type name 22
18) days to deliver & number of orders by order type 23
19) cost, days to deliver and discount percent 23
20) customer type with unit cost and quantity ordered 23
Conclusion 23
Reflection 24
References 25
Figure 1 5
Figure 2 6
Figure 3 7
Figure 4 8
Figure 5 9
Figure 6 10
Figure 7 11
Figure 8 12
Figure 9 13
Figure 10 13
Figure 11 14
Figure 12 15
Figure 13 15
Figure 14 16
Figure 15 17
Figure 16 17
Figure 17 18
Figure 18 18
Figure 19 19
Table 1 5
Table 2 6
Table 3 6
Table 4 8
Table 5 9
Table 6 9
Table 7 10
Table 8 11
Table 9 12
Table 10 13
Table 11 14
Table 12 17
Executive Summary
There is a total of 9,51,669 customers. The top country with highest total of the retail price is the United States with a total retail price $3,29,01,896. The top customers with the highest retail price are Michael and David have a retail price of $8,79,353 and $8,24,643 respectively.
On February 28, 2014, and December 19, 2016, the highest number of orders were placed corresponding to 1096 and 1,003 orders. The customers David, Michael, and John have the highest quantity ordered with a value of 10600, 10192, and 10000. The highest Quantity Ordered corresponds to customer type Orion Club Gold members high activity, Orion Club Gold members medium activity, and Orion Club members high activity. For all customers type, the top 5 countries include the United States and Germany. The maximum ordered quantity was received from Europe. The cities Madrid, London, Paris, and Milano have maximum days of delivery corresponding to 51587, 35916, 34602, and 18148 respectively.
The maximum number of customers belongs to the United States. The days to delivery are the highest by Europe for customer type Internet/Catalog Customers. The top 3 customer type receiving fastest delivery are Orion Club members low activity, Orion Club Gold members low activity, and Orion Club members medium activity.
The maximum number of order type corresponds to retail sale. There is a weak linear relationship between (cost, days to deliver) and (discount percentage, days to deliver). As the value of cost increases the value of quantity ordered also increases.
Background information
Companies need people who know how to use data to understand their customer’s needs. Once they understand their needs, they can provide the products customers want to buy. A good understanding of customers is extremely important for running a successful business.
KYC or ‘know your customer’ is what actually makes all the difference for many companies. Customer Analytics is a very broad area. this includes characteristics of customers and their behaviour and numerous different. Outcomes and performance indicators that the business might be interested in. The segmentation, targeting, and positioning is called as ‘S T P framework’ which can be applied to all areas of business. Grljević, O., & Bošnjak, Z. (2018).
An article was published in the name of “Customer Classification of Discrete Data Concerning Customer Assets Based on Data Mining” which was written by Lei Zuo and Junfeng Guo. In this study, a customer classification model based on outlier data analysis concerning customer asset was performed. The 4 dimensions were transaction frequency, types of products or services traded, transaction amount and client age. the aim was to divide twenty-five types of outlier customer data into four categories. Various marketing strategies were also applied here. Zuo, L., & Guo, J. (2019, January).
Analysis
1) Data dictionary
The dataset has 22 columns and a total of 951.7K rows. The categorical variables are listed as
· City Name
· Continent Name
· Customer Birth Date
· Customer Country
· Customer Group Name
· Customer ID
· Customer Type Name
· Customer First name
· Customer Last name
· Date order was delivered
· date order was placed
· Order ID
· Order Type
· Postal code
· State name
· Title
The continuous variables are listed as
· Cost
· Days to delivery
· Discount in percent of Normal total retail price
· Frequency
· Profit
· Quantity ordered
· Retail price
· Frequency percent
2) Number of Customers
Table 1
Customer Group Name
Frequency
Internet/Catalog Customers
76,965
Orion Club Gold members
4,83,438
Orion Club members
3,91,266
Count: 9,51,669
Figure 1
Customer Type Name
Frequency
Orion Club Gold members high activity
2,23,488
Orion Club Gold members medium activity
1,60,666
Orion Club members high activity
1,60,304
Orion Club members medium activity
1,28,241
Orion Club members low activity
1,02,721
Orion Club Gold members low activity
99,284
Internet/Catalog Customers
76,965
3) Customers and countries
Table 2
Customer_FirstName
Frequency
Antonio
2,581
Barbara
2,480
Andrea
2,329
Alain
1,921
Andrew
1,888
Ana
1,731
Anne
1,490
Andreas
1,485
Alberto
1,433
Anna
1,380
Angela
1,075
Alan
1,065
Figure 2
4) Country and Revenue
Table 3
Customer Country
Retail Price
$13,31,96,488.48
United States
$3,29,01,896.80
Germany
$1,97,60,678.03
France
$1,47,01,399.68
Italy
$1,45,25,623.82
United Kingdom
$1,31,75,549.39
Spain
$1,22,33,250.16
Netherlands
$95,49,237.18
Australia
$78,94,103.00
Belgium
$31,37,551.64
Denmark
$24,62,872.19
Figure 3
5) Customers and total revenue
Table 4
Customer_FirstName
Retail Price
Michael
$8,79,353.92
David
$8,24,643.56
John
$7,94,653.59
Robert
$6,94,692.47
Peter
$6,48,676.25
James
$5,76,694.37
Thomas
$5,71,126.76
Paul
$4,89,962.85
William
$4,49,091.91
Christine
$4,12,559.50
Figure 4
6) days to place and order
Table 5
Date Order was placed by Customer
Frequency
February 28, 2014
1,096
December 19, 2016
1,003
December 06, 2016
998
December 13, 2016
931
December 27, 2016
926
December 12, 2016
914
December 26, 2016
912
December 20, 2016
899
December 05, 2016
884
December 16, 2016
876
December 02, 2016
872
November 01, 2016
857
August 09, 2016
855
July 26, 2016
854
December 08, 2016
853
December 18, 2016
849
July 08, 2014
843
December 01, 2016
839
December 15, 2016
836
December 03, 2016
835
Figure 5
7) Customer type and quantity ordered
Table 6
Customer_FirstName
Quantity Ordered
David
10,600
Michael
10,192
John
10,000
Robert
8,427
Peter
7,668
Elfonza
1
Elery
1
Elainna
1
Kinta
1
Kimyen
1
Kimlie
1
Effy
1
Figure 6
8) Customer type and quantity ordered
Table 7
Customer Type Name
Quantity Ordered
Orion Club Gold members high activity
3,73,905
Orion Club Gold members...