ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
2
BUSINESS QUESTIONS / KPIsSum of Total SalesCount of Total Sales
Distinct Count of Region
Distinct Count of State
Distinct Count of City
3
₦11,488,062 9,994 449531
4
SALES DRIVERSWHERE THE BUSINESS IS LOSING MONEYAREAS REQUIRING ATTENTION
5
CategorySum of Total SalesRegionSum of Total SalesStateSum of Total Sales
6
Technology₦4,080,262West₦3,595,228California₦2,301,218
7
Furniture₦3,859,215East₦3,379,326New York₦1,561,073
8
Office Supplies₦3,548,585Central₦2,475,833Texas₦834,088
9
Grand Total₦11,488,062South₦2,037,675Washington₦692,360
10
Based on the Pivot Table above, Supplies, Bookcases, and Tables have been identified as the products where business is losing money.Pennsylvania₦602,127
11
Based on the Pivot Table above, the Technology category has been identified as the key driver of sales.Based on the Pivot Table above, Supplies, Bookcases, and Tables have been identified as the areas that require attention.Florida₦472,091
12
Michigan₦410,351
13
Virginia₦376,454
14
Illinois₦365,084
15
Ohio₦362,534
16
North Carolina₦282,778
17
Indiana₦267,038
18
Sub-CategorySum of Total SalesSum of Profit MarginGeorgia₦242,265
19
Envelopes₦74,1799%Kentucky₦197,201
20
Paper₦389,4049%New Jersey₦182,951
21
Copiers₦657,7218%Wisconsin₦171,542
22
Labels₦70,6358%Arizona₦170,003
23
Fasteners₦17,0586%Tennessee₦158,655
24
Art₦136,0215%Colorado₦145,591
25
Accessories₦878,9235%Minnesota₦134,978
26
Appliances₦547,3683%Massachusetts₦131,234
27
Binders₦1,013,4543%Rhode Island₦129,435
28
Furnishings₦454,1173%Alabama₦118,424
29
Phones₦1,628,8283%Delaware₦115,659
30
Storage₦1,099,2292%Missouri₦112,045
31
Chairs₦1,662,7582%Maryland₦109,223
32
Machines₦914,7900%Oklahoma₦98,110
33
Bookcases₦597,826-1%Nevada₦86,832
34
Supplies₦201,236-1%Oregon₦79,009
35
Tables₦1,144,514-2%Mississippi₦59,277
36
Connecticut₦58,948
37
Vermont₦54,626
38
Utah₦51,470
39
Arkansas₦49,896
40
South Carolina₦42,627
41
New Hampshire₦42,140
42
Nebraska₦39,926
43
Louisiana₦38,008
44
Iowa₦26,256
45
Sub-CategorySum of ProfitMontana₦24,150
46
Copiers₦55,618New Mexico₦24,125
47
Phones₦44,516District of Columbia₦15,724
48
Accessories₦41,937Idaho₦14,056
49
Paper₦34,054Kansas₦8,954
50
Binders₦30,222Maine₦7,624
51
Chairs₦26,590Wyoming₦6,413
52
Storage₦21,279West Virginia₦6,027
53
Appliances₦18,138South Dakota₦3,773
54
Furnishings₦13,059North Dakota₦3,688
55
Envelopes₦6,964
56
Art₦6,528
57
Labels₦5,546
58
Machines₦3,385
59
Fasteners₦950
60
Supplies-₦1,189
61
Bookcases-₦3,473
62
Tables-₦17,725
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