50.1K

Verified Solution

Link Copied!

3. list of data which Mr. is interested in viewing:

a. Information on the countries and regions which are most profitable and have the most sales activity;

b. An insight into Stores most popular products and those products which generate the most profit;

c. Identification of any products which may be poor performing or at risk of becoming obsolete;

d. Who Stores best and worst customers are and an indication of which products they enjoy, including margins (this will help Angelo to decide what products to discount);

e. A monthly analysis of sales to help Mr. with stock and distribution staff levels. Mr. would really appreciate it if this can also show him which products are more popular at different times of the year;

4. In addition to the above request, Mr. highlighted that he would like to extend Stores technology product offering. You decide to include an additional analysis regarding the technology category of products to help Mr. understand what customers and stores would be ideal for the new offerings.

5. Mr. would like to see the data represented in a variety of charts and pivot tables. He would also like to be able to vary the data that is on these charts using filters and or slicers to make it as interactive as possible. In particular, he would like to be able to slice the data by some of the following categories, as appropriate for the pivot tables you have selected:

a. Year

b. Month

c. Country

d. State

e. Product Category

f. Sub Category

S A B D H M N 1 Date Date Month Month Year Customer Customer Age Gros Customer gen-Country State Product CategSub Catego Product ID Product Name 8/01/2016 1 January 2016 NOO015080 24 Youth MI FUI Rewal Furniture Furnishings FUR-FU-10002759 12-1/2 Diameter Round Wall Clock 9 14/01/2016 1 January 2016 ENO0016516 18 Youth F FUI Namosi Furniture Furnishings FUR-FU-10002759 12-1/2 Diameter Round Wall Clock 10 18/02/2016| 2 February 2016NO0025746 20 Youth FUnited Kingdom England Furniture Furnishings FUR-FU-10002759 12-1/2 Diameter Round Wall Clock 1112/03/2016 3 March 2016N00017925 22 Youth M New Zealand North Island Furniture Furnishings FUR-FU-10002759 12-1/2 Diameter Round Wall Clock 12 31/03/2016 3 March 2016 NO0015838 23 Youth M Canada British Columbia Furniture Furnishings FUR-FU-10002759 12-1/2 Diameter Round Wall Clock 137/06/2016 6 June 2016 NOOO28631 24 Youth New Zealand South Island Furniture Furnishings FUR-FU-10002759 12-1/2 Diameter Round Wall Clock 14 13/06/2016 6 6 June 2016N00011702 24 Youth M United States California Furniture Furnishings. FUR-FU-10002759 12-1/2 Diameter Round Wall Clock 151/12/2019 12 December 2019 ENO0013603 19 Youth F Australia South Australia Furniture Furnishings FUR-FU-10002759 12-1/2 Diameter Round Wall Clock 1616/02/2020 SA 2 February 2020-NO0021177 18 Youth J New Zealand North Island Furniture Furnishings FUR-FU-10002759 12-1/2 Diameter Round Wall Clock 171 12/04/2020 4 April 2020ENOOO28843 22 Youth MI Canadal Alberta Furniture Furnishings FUR-FU-10002759 12-1/2 Diameter Round Wall Clock 18 15/04/2020 April 2020 INOOO24976 24 Youth M Australia New South Wales Furniture Furnishings FUR-FU-10002759 12-1/2 Diameter Round Wall Clock 19 26/04/2020 April 2020 NO0015200 22 Youth M M Australia Victorial Furniture Furnishings FUR-FU-10002759 12-1/2 Diameter Round Wall Clock 20 28/07/2020 7 July 2020|NO0027828 21 Youth Fl United States California Furniture Furnishings FUR-FU-10002759 12-1/2 Diameter Round Wall Clock 218/01/2015 1 January 2015 NOO014924 23 Youth United Kingdom England Furniture Furnishings FUR-FU-10000076 24-Hour Round Wall Clock 22 25/12/2015 12 December 2015 NO0016793 21 Youth M United States Washington Furniture Furnishings FUR-FU-10000076 24-Hour Round Wall Clock 23 11/02/2016 2 February 2016 NOOO2 1073 18 Youth M Australia Queensland Furniture Furnishings FUR-FU-10000076 24-Hour Round Wall Clock 24 6/08/2017 8 August 2017 NO00188541 23 Youth M United States California Furniture Furnishings FUR-FU-10000076 24-Hour Round Wall Clock 25 17/10/2018 10 October 2018 NOO015070 22 Youth MUnited Kingdom England! Furniture Furnishings FUR-FU-10000076 24-Hour Round Wall Clock 26 14/11/2019 11 November 2019N00022658 16 18 Youth F Australia New South Wales Furniture Furnishings FUR-FU-10000076 24-Hour Round Wall Clock 27 14/01/2020 Ml United States Tornia 1 January 2020-NOO013219 22 Youth Furniture Furnishings FUR-FU-10000076 24-Hour Round Wall Clock 28 27/01/2020 1 2 January 2020 NOO013922 22 Youth MUnited Kingdom England Furniture Furnishings FUR-FU-10000076 24-Hour Round Wall Clock 29 21/03/2020 3 March 2020 ENOO014601 19 Youth F FOI Bua Furniture Furnishings FUR-FU-10000076 24-Hour Round Wall Clock 306/06/2020 6 June 2020N00027238 19 Youth M M New Zealand North Island Furniture Furnishings FUR-FU-10000076 24-Hour Round Wall Clock 31 16/12/2015 12 December 01 SINO0012444 24 Youth| FUnited Kingdom England Furniture Furnishings FUR-FU-1000324736X48 HARDFLOOR CHAIRMAT 32 2/04/2016 4 4 April 2016 NO0011219 20 Youth M Canada British Columbial Furniture Furnishings FUR-FU-10003247 36X48 HARDFLOOR CHAIRMAT 33 17/05/2016 5 May 2016 ENO0016690 23 Youth F Australia Queensland Furniture Furnishings FUR-FU-10003247 36X48 HARDFLOOR CHAIRMAT 34 25/07/2016 7 7 July 2016 NO0022659 18 18 Youth F Australia Queensland Furniture Furnishings FUR-FU-10003247 36X48 HARDFLOOR CHAIRMAT 3526/11/2018 11 November 2018 (NO0011696 24 Youth F FI Canada British Columbia Furniture Furnishings FUR-FU-10003247 36X48 HARDFLOOR CHAIRMAT 36 1/08/2019 8 August 2019N00013748 23 Youth M New Zealand North Island Furniture Furnishings FUR-FU-10003247 56X48 HAROFLOOR CHARMAT 37 14/02/2020 2020 INO0012744 21 Youth F Australia Tasmania Furniture Furnishings FUR-FU-10003247 36X48 HARDFLOOR CHAIRMAT st 38 22/03/20201 3 March 2020 NO0021213 17 Youth FUnited Kingdom England Furniture Furnishings FUR-FU-10003247 36X48 HARDFLOOR CHAIRMAT 39 13/06/2020 6 6 June 2020 NO00213511 18 Youth M United States California Furniture Furnishings FUR-FU-10003247 36X48 HARDFLOOR CHAIRMAT 23/06/20201 6 June 2020 NO0026512 24 Youth F Australia Victorial Furniture Furnishings FUR-FU-10003247 36X48 HARDFLOOR CHARMAT 41 24/09/2015 9 September 2015 NO0026860 17 Youth M United States Washington Furniture Furnishings FUR-FU-10001935 3M Hangers With Command Adhesive 426/10/2015 10 October 2015 NO0011577 Youth F Canada British Columbia - Furniture Furnishings FUR-FU-10001935 3M Hapers With Command Adhesive 43 16/11/2015 11 November 2015 NO0015506 18 Youth M United States California Furniture Furnishings FUR-FU-10001935 3M Hangers With Command Adhesive 44 21/11/2015 ) 12 November 2015 NO0015893 21 Youth FI Canada British Columbia Furniture Furnishings FUR-FU-10001935 3M Hangers With Command Adhesive 4527/11/2015 11 November 2015 NO0015838 23 Youth M Canada British Columbia Furniture Furnishings FUR-FU-10001935 3M Hangers With Command Adhesive 46 14/12/2015 12 December 2015 NOC028485 19 Youth FUnited Kingdom England Furniture Furnishings FUR-FU-10001935 M Hangers With Command Adhesive 47 19/12/2015 12 December 2015 NOO023644 18 Youth Canada British Columbia Furniture Furnishings FUR-FU-10001935 3M Hangers With Command Adhesive 48 12/03/2016) 3 March 2016 NO0017924 22 Youth Tou! M New Zealand South Island Furniture Furnishings FUR-FU-10001935 3M Hangers With Command Adhesive 49 16/06/2017 6 June 2017 NO0024390 23 Youth El United States Oregon Furniture Furnishings FUR-FU-10001935 3M Hangers With Command Adhesive sn 17/11/2njal 111 Number 201002265R 1 Youth Aurelin New South Wales Furniture Furnishina FLIR.FLI.10001925 MHE. With Command Adecine Sales Data # Sales $ $ Is > IS $ IS TS S ts $ LES $ IS + $ 15 IS TS IS TS S S IS IS $ TS S IS S IS S S IS IS IS IS ES IS S $ S $ S $ ES O Q R Quantity Discount Profit - 40.11 2 0.00 $ 14.51 23.98 3 0.60-S 14.39 32.04 2 0.20 $ 6.47 39.96 5 0.60 -S 23.98 32.12 2 0.20 $ 651 24.05 31 0.60 - 14.31 40.18 51 0.6015 23.78 24.05 3 0.60 $ 14.31 40.18 5 0.605 23.78 40.03 2 0.00 $ 14.46 111 89 71 0.20 $ 22.38 111.96 71 0.20 $ 22.45 200.02 101 0.00 $ 72.12 40.03 2 0.00 $ 17.26 48.10 1 3 0.2015 1391 79.92 4 0.00 $ 34.37 19.98 1 0.00 $ 859 48.10 3 0.20 $ 13.91 139.86 71 0.00 5 60.14 139.86 7 0.00 $ 6014 48.02 3 0.2015 13 86 20.13 1 0.00 $ 8.71 40.03 2 0.00 5 17.26 42.03 2 0.001s 301 33.57 2 0.2015 5.45 25.18 0.60LS 33.36 42.18 2 0.00 $ 3.13 84.07 41 0.00 $ 5.99 33.57 21 0.2015 5.45 25.18 3 0.60 $ 33.36 167 84 of 1 8 0.00 $ 11.75 25.18 3 0.60 $ 33.36 42.11 2 0.00 S 3.06 22.27 6 0.00 $ 9.18 15.02 4 0.00 S 6.26 4 11.84 0.20 $ 3.11 22.20 6 0.00 $ 9.10 3.11 1 0.20 $ 0.90 23.68 8 81 0.20 S 6.22 22.20 60 0.00 $ 9.10 23.68 8 0.20 6.22 2.96 1 0.20 $ 0.78 22 2 S A B D H M N 1 Date Date Month Month Year Customer Customer Age Gros Customer gen-Country State Product CategSub Catego Product ID Product Name 8/01/2016 1 January 2016 NOO015080 24 Youth MI FUI Rewal Furniture Furnishings FUR-FU-10002759 12-1/2 Diameter Round Wall Clock 9 14/01/2016 1 January 2016 ENO0016516 18 Youth F FUI Namosi Furniture Furnishings FUR-FU-10002759 12-1/2 Diameter Round Wall Clock 10 18/02/2016| 2 February 2016NO0025746 20 Youth FUnited Kingdom England Furniture Furnishings FUR-FU-10002759 12-1/2 Diameter Round Wall Clock 1112/03/2016 3 March 2016N00017925 22 Youth M New Zealand North Island Furniture Furnishings FUR-FU-10002759 12-1/2 Diameter Round Wall Clock 12 31/03/2016 3 March 2016 NO0015838 23 Youth M Canada British Columbia Furniture Furnishings FUR-FU-10002759 12-1/2 Diameter Round Wall Clock 137/06/2016 6 June 2016 NOOO28631 24 Youth New Zealand South Island Furniture Furnishings FUR-FU-10002759 12-1/2 Diameter Round Wall Clock 14 13/06/2016 6 6 June 2016N00011702 24 Youth M United States California Furniture Furnishings. FUR-FU-10002759 12-1/2 Diameter Round Wall Clock 151/12/2019 12 December 2019 ENO0013603 19 Youth F Australia South Australia Furniture Furnishings FUR-FU-10002759 12-1/2 Diameter Round Wall Clock 1616/02/2020 SA 2 February 2020-NO0021177 18 Youth J New Zealand North Island Furniture Furnishings FUR-FU-10002759 12-1/2 Diameter Round Wall Clock 171 12/04/2020 4 April 2020ENOOO28843 22 Youth MI Canadal Alberta Furniture Furnishings FUR-FU-10002759 12-1/2 Diameter Round Wall Clock 18 15/04/2020 April 2020 INOOO24976 24 Youth M Australia New South Wales Furniture Furnishings FUR-FU-10002759 12-1/2 Diameter Round Wall Clock 19 26/04/2020 April 2020 NO0015200 22 Youth M M Australia Victorial Furniture Furnishings FUR-FU-10002759 12-1/2 Diameter Round Wall Clock 20 28/07/2020 7 July 2020|NO0027828 21 Youth Fl United States California Furniture Furnishings FUR-FU-10002759 12-1/2 Diameter Round Wall Clock 218/01/2015 1 January 2015 NOO014924 23 Youth United Kingdom England Furniture Furnishings FUR-FU-10000076 24-Hour Round Wall Clock 22 25/12/2015 12 December 2015 NO0016793 21 Youth M United States Washington Furniture Furnishings FUR-FU-10000076 24-Hour Round Wall Clock 23 11/02/2016 2 February 2016 NOOO2 1073 18 Youth M Australia Queensland Furniture Furnishings FUR-FU-10000076 24-Hour Round Wall Clock 24 6/08/2017 8 August 2017 NO00188541 23 Youth M United States California Furniture Furnishings FUR-FU-10000076 24-Hour Round Wall Clock 25 17/10/2018 10 October 2018 NOO015070 22 Youth MUnited Kingdom England! Furniture Furnishings FUR-FU-10000076 24-Hour Round Wall Clock 26 14/11/2019 11 November 2019N00022658 16 18 Youth F Australia New South Wales Furniture Furnishings FUR-FU-10000076 24-Hour Round Wall Clock 27 14/01/2020 Ml United States Tornia 1 January 2020-NOO013219 22 Youth Furniture Furnishings FUR-FU-10000076 24-Hour Round Wall Clock 28 27/01/2020 1 2 January 2020 NOO013922 22 Youth MUnited Kingdom England Furniture Furnishings FUR-FU-10000076 24-Hour Round Wall Clock 29 21/03/2020 3 March 2020 ENOO014601 19 Youth F FOI Bua Furniture Furnishings FUR-FU-10000076 24-Hour Round Wall Clock 306/06/2020 6 June 2020N00027238 19 Youth M M New Zealand North Island Furniture Furnishings FUR-FU-10000076 24-Hour Round Wall Clock 31 16/12/2015 12 December 01 SINO0012444 24 Youth| FUnited Kingdom England Furniture Furnishings FUR-FU-1000324736X48 HARDFLOOR CHAIRMAT 32 2/04/2016 4 4 April 2016 NO0011219 20 Youth M Canada British Columbial Furniture Furnishings FUR-FU-10003247 36X48 HARDFLOOR CHAIRMAT 33 17/05/2016 5 May 2016 ENO0016690 23 Youth F Australia Queensland Furniture Furnishings FUR-FU-10003247 36X48 HARDFLOOR CHAIRMAT 34 25/07/2016 7 7 July 2016 NO0022659 18 18 Youth F Australia Queensland Furniture Furnishings FUR-FU-10003247 36X48 HARDFLOOR CHAIRMAT 3526/11/2018 11 November 2018 (NO0011696 24 Youth F FI Canada British Columbia Furniture Furnishings FUR-FU-10003247 36X48 HARDFLOOR CHAIRMAT 36 1/08/2019 8 August 2019N00013748 23 Youth M New Zealand North Island Furniture Furnishings FUR-FU-10003247 56X48 HAROFLOOR CHARMAT 37 14/02/2020 2020 INO0012744 21 Youth F Australia Tasmania Furniture Furnishings FUR-FU-10003247 36X48 HARDFLOOR CHAIRMAT st 38 22/03/20201 3 March 2020 NO0021213 17 Youth FUnited Kingdom England Furniture Furnishings FUR-FU-10003247 36X48 HARDFLOOR CHAIRMAT 39 13/06/2020 6 6 June 2020 NO00213511 18 Youth M United States California Furniture Furnishings FUR-FU-10003247 36X48 HARDFLOOR CHAIRMAT 23/06/20201 6 June 2020 NO0026512 24 Youth F Australia Victorial Furniture Furnishings FUR-FU-10003247 36X48 HARDFLOOR CHARMAT 41 24/09/2015 9 September 2015 NO0026860 17 Youth M United States Washington Furniture Furnishings FUR-FU-10001935 3M Hangers With Command Adhesive 426/10/2015 10 October 2015 NO0011577 Youth F Canada British Columbia - Furniture Furnishings FUR-FU-10001935 3M Hapers With Command Adhesive 43 16/11/2015 11 November 2015 NO0015506 18 Youth M United States California Furniture Furnishings FUR-FU-10001935 3M Hangers With Command Adhesive 44 21/11/2015 ) 12 November 2015 NO0015893 21 Youth FI Canada British Columbia Furniture Furnishings FUR-FU-10001935 3M Hangers With Command Adhesive 4527/11/2015 11 November 2015 NO0015838 23 Youth M Canada British Columbia Furniture Furnishings FUR-FU-10001935 3M Hangers With Command Adhesive 46 14/12/2015 12 December 2015 NOC028485 19 Youth FUnited Kingdom England Furniture Furnishings FUR-FU-10001935 M Hangers With Command Adhesive 47 19/12/2015 12 December 2015 NOO023644 18 Youth Canada British Columbia Furniture Furnishings FUR-FU-10001935 3M Hangers With Command Adhesive 48 12/03/2016) 3 March 2016 NO0017924 22 Youth Tou! M New Zealand South Island Furniture Furnishings FUR-FU-10001935 3M Hangers With Command Adhesive 49 16/06/2017 6 June 2017 NO0024390 23 Youth El United States Oregon Furniture Furnishings FUR-FU-10001935 3M Hangers With Command Adhesive sn 17/11/2njal 111 Number 201002265R 1 Youth Aurelin New South Wales Furniture Furnishina FLIR.FLI.10001925 MHE. With Command Adecine Sales Data # Sales $ $ Is > IS $ IS TS S ts $ LES $ IS + $ 15 IS TS IS TS S S IS IS $ TS S IS S IS S S IS IS IS IS ES IS S $ S $ S $ ES O Q R Quantity Discount Profit - 40.11 2 0.00 $ 14.51 23.98 3 0.60-S 14.39 32.04 2 0.20 $ 6.47 39.96 5 0.60 -S 23.98 32.12 2 0.20 $ 651 24.05 31 0.60 - 14.31 40.18 51 0.6015 23.78 24.05 3 0.60 $ 14.31 40.18 5 0.605 23.78 40.03 2 0.00 $ 14.46 111 89 71 0.20 $ 22.38 111.96 71 0.20 $ 22.45 200.02 101 0.00 $ 72.12 40.03 2 0.00 $ 17.26 48.10 1 3 0.2015 1391 79.92 4 0.00 $ 34.37 19.98 1 0.00 $ 859 48.10 3 0.20 $ 13.91 139.86 71 0.00 5 60.14 139.86 7 0.00 $ 6014 48.02 3 0.2015 13 86 20.13 1 0.00 $ 8.71 40.03 2 0.00 5 17.26 42.03 2 0.001s 301 33.57 2 0.2015 5.45 25.18 0.60LS 33.36 42.18 2 0.00 $ 3.13 84.07 41 0.00 $ 5.99 33.57 21 0.2015 5.45 25.18 3 0.60 $ 33.36 167 84 of 1 8 0.00 $ 11.75 25.18 3 0.60 $ 33.36 42.11 2 0.00 S 3.06 22.27 6 0.00 $ 9.18 15.02 4 0.00 S 6.26 4 11.84 0.20 $ 3.11 22.20 6 0.00 $ 9.10 3.11 1 0.20 $ 0.90 23.68 8 81 0.20 S 6.22 22.20 60 0.00 $ 9.10 23.68 8 0.20 6.22 2.96 1 0.20 $ 0.78 22 2

Answer & Explanation Solved by verified expert

See Answer