ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
4
Sheet NameDescriptionCompletion Rules
5
1. Sales DatasetTransaction history dataset of refrigerator sales for the last four months.The candidate can fill in the empty columns (columns with red headers) with effective and appropriate formulations referring to the subsequent sheets.
6
2. Shipping Address DatasetHelper dataset to complete sheet 1.
7
3. Unit DatasetHelper dataset to complete sheet 1.
8
4. Customer DatasetHelper dataset to complete sheet 1.
9
5. Question Box
Questions about the sales dataset that need to be completed.
Answer the questions in each question column by filling in the answer column and writing the detailed and accurate formula drafts in the provided space.
10
6. Dashboard"Sheet for visualizing the completed sales dataset. *Feel free to adjust the dashboard box as needed for space requirements."Create visualizations from the exploratory data analysis of the completed sales dataset, as follows:

1. Salesman chart based on revenue
2. Customer segmentation chart based on revenue
3. Shipping province chart based on quantity
4. Month-to-month revenue chart
5. Order priority comparison chart
6. Provide a summary based on the data visualization and recommendations for business development from the candidate.
Notes:
- The dashboard can be created on any preferred platform (Excel, Power BI, Looker, etc.);

the only requirement is that there are filters for Month, Business Segmentation, and Salesman, and users can check the results.
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100