Answer Happy

Essay Question #T1: . You can determine how well each department is performing by comparing key performance indicators for Customer, Product, Shipment, and other Operations. What is your assessment of each department? . ● Write down your answers based on the KPIs that you identified in Tableau data source. Essay Question #T2: ● You can determine how well this company is performing by comparing key performance indicators. ● What is your overall assessment of Superstore Company? ● Write down your answers based on the Key Performance Indicators (KPIs) that you identified in Tableau data source. Important Note: . Your written report should include at least 700 words. ● Your report should analyze in greater depth the issue of sales, customers, shipping, commissions, forecast, etc. . The followings are some examples: o Sales trend from Product View, sales figures based on different regions, Sales and Profit by Customer View, detailed customer analysis based on Category and Segment View, shipping trends based on different regions and different quarters.
table-Tabinay European Dutaurt 2002 (1) File Data Winchert Dunboard Story Aulyus Map Temat Server Window Help 349 FN- OF F Dashboard Layout ♥ Product Drilldown. Delat Phone Sales by Product Category Devce Preve Dec Furniture Jan T6752 10302 Mar 14436 Jun EL 240 2017 2010 (27771 16,341 En 961 £30,543 £25, 160 min 2000x620 ade 2020 16.100 114625 113,138 121.993 Sales 2020 £15,361 Sheets (19) EX0-22 FREES 12.197 £15.904 £15.632 14.079 (11 300 FRO 116.675 office 7017 19.374 £18,009 KROON Supplies Performance Forecast 16,225 EX7,401 118,631 £33.300 2018 15,459 E15,307 35795 201 K27,329 122:383 114,361 €29,30 £19.045 (3104 10.999 122,105 What Forecast 2009 2020 121254 (20963 X21.038 453, 131 119,395 £41,0 Testology 2017 EXOM 25,130 2018 17.607 [4747 13,916) E11,062 121,000 138202 17,448 115.283 122,254 CERTA (13.025 121.500 111971 IR DET 123,678 F34053 130,104 €18.771 134634 125.695 147,449 K27,268 2009 112,942 E27,32 1012 013 124.554 121.244 $29.273 121/01 66.718 142.322 €11624 -149.827 120.037 (26432 £25.764 842,748 124428 F41555 Q14 2015 Sales and Profit by Product Names Year A, Mon All Product Category Al 017 Furniture Objects Chan Fungs Tols Appliances ome Evertor Alle Supples A Binders Ceper EEE & Ovenka 17 #m Fir Auke Pajer ... Ted Fosting ein 45,000 30.000 15.000 20.000 25000 a Sales 15.000 €10.000 (15,000 €20,000 £25,000 60 Sales 15.00 Show dashboard ste Ove Product Customers fiecast What F 00 00 00 02 03 04 05 06 07 08 090465 Sery HD-1080- MEYE 010 110 ino WICE meng Feb ODNETY Apr 17.489 F4330 47355 198023 113,442 €12.950 £12,503 123112 19,202 100913 CHODI May 10.429 £10 041 £10.000 131,078 XIX 537 (12,409 €17.392 €24,488 90083 SECTED D Aal 12.197 €11,836 (97313 GOE63 Sep Aug 111454 EXCUR 254.337 £15,424 124306 124,371) 25303 (25.365 139429 Sos 17.304 121,74 EN 729 141660 C+0283 250'223 SICTED Ort 05E83 Now 014376 FI-224 £29.03 €34568 121.304 (8563 DEB 221 WE'RE 500293 Office $10.000 Sales ING £15,000 Regen OA) Central North South Profit Kat -50% Show 406 120.000 125.000 205 PM 5/3/2022
Nampen Data 2022 Des Wirtsheet Daan Sy Ay Map Formal Server Window Help GG Dashboard Layout Customer Analysis DAN Cut Neve Central 777 DecePrevie South Neth Sales and Profit by Customer 4000 10000 Forecast Sheets 688 30.000 911 OF 012 110 CIA 940 INCON 16 Objects 30 6 Showde { $2000 same HEEF 2591061 1625575 €1720553 1652 0.000 12111 Customer Ranking Defens store l Patrick Obe 2 Carrot 1 Maten Mathew Rese Greg Trae E Carl Macintyre B Denty B Harry Creme B Pet Walters Sy Hey Ma B Meh On Anderse 12000 15000 1000000 40000 Sales Perfect W 00gm quou BRUN Jumpiru Hare) www.i aligie Ale Martly) They Cake) apel Besty Letra HD HDD 54013 1,02051 1221435 Fire 185.516 checit TO HEAD 119.939 9300 148.20 H 130,467 00017 CARS ICLE 500 FELIX 198 1953 200TES 1235534 $15,000 IND 15,364 MEE 936 TEAM Category ma Profi Cantare AN Consumer 20 home off Show Me 306 PM Supplies 479
s Tebles forpean Detart 2002 ( Data Wektet Dastboird Shory Ana Mip Format Server Window Help D Dashboard Layout On-Time Shipment Trends Defaut Phone De Praw 1000e Performance What If Forc Qo out 012 #013 004 on 010 017 OUR Obiects Alter 334 Q 7amme 1 F 51% Shipped Early 400 110 Days to Ship by Product for Q4 of 2020 had D Aco e P Count of Orders ANER Aw Acc ACH BAR PR Ma Bey 26 40 1800 2501 MO 1 Now lov 25 25% Shipped On Time 29 N Dec 11 Dec 10m 350 250 G QPQ 019 02044 N 20 Dec 25% Shipped Late 270 AMING Order Year 2017 2018 2010 10) 2010 Order Quarter 01 OF 03 004 Region CAR Ship Mode CANT 362
ftpen Data 2002 ( Cala Werther Canon 744 Data Tables Onders Returns -Muhares -wp.prift . FRAU Target Dut Parameters Story Ay Map Format Server Window Hep 2.26 DAF 4 Pages Fiden YEAR(Order Da Marks 11 One Sa Tiety A & ADGI SURATS Gath GID B PRY abor. Ta Oulunes Category YEAR Order C Sales Performance vs Target Computer Corporate Home Office Center Corporate Home Office Comune Corporate Offe Omer Orporate March D Coper w Open Hee Copery lity My Ap Que Standard • MONTH Order D SUMS furniture W-7 Segment ................... www-baldella > Office Supplies EXTRU Piper LLLL sebab womb 10 10 beb Ep0000 95 20.000 30.000 You (AN 2017 2018 201 2020 Addales atv Abive Target Below Target
Ses Tabs Tumpen Data 2002 O Wochet Denecart Story Ay Map Format Server Window Help 9 +254.0 P 10 B Colum Data Ac Papes 14 Tow Sear Sales Forecast Tables 000 160.000 £40.000 120.000 CO 000 ure Nam Apt.pn Mass # A 11 Format v m H LE400 apple FRON H C SUM P wwwww mon илим т m 2011 M 12 20/1 00 ONS MONTH(Order D Segret Entre View P O Show Consumer Actual Consumer Extmate Corporate Actual Corporate Estimate Home Office Actu Home Office Estimate PELLOK
The Date Winsheet Denboard vry Analysih Map lamat Server Window Hep DAGKO DAF Data Analytes Pr W Coupes QUARTERO Standard MONTHOrder Da Segment How Reg Meature Names YEAR Order Dare) Fides What if Forecast Based on All Sales (60% Growth, 6.40% Churn). (40) 04 2012 Region Se Total On 2016 2018 121212 Hote SAVE News Grith offer Tita un Sen 03 January February March Tine Apa May Ayne Total My August Sesters CAND FALLIO 151502 134201 151819 160.311 (103.623 4218,052 452.109 16 291 104 343 1272,841 for 172297 (G477,330 (233599 100.599 190.322115560503265556780043374300, 1336.264 €40.0 (L027 €22,092 4543 1,035 13745) (65.429 004 475 €367,753 S14705244 071 0125.240 15150 C4151 15628615668 179 €12/09 CA 117662 (MASI 656 €14,000 £28.03 150371 197 1254AN DENE 126450 156,720 124.495 625.000 (4) 19 RECRL RISESS 194,411 182545 1963 12P7LO99 399.00 197,00) 197,371 450 (101933 1228.112 1209, 41012 S4L450 4125117 £13371 1056 ALIN OTELS (5856 155050 LAO CHAIN BEEL North Conurer Sales (26,336 117,001370797 (04.00 138.745 178AH EMAJO 1/3290 11701 €20, 250 14/637 LEUE970 Seifer DH 2549 DL145 1954 CEE CHONEY ENCEN ESP8,745 25.565 458702 673. ME 0355799 Corporate S Des 15.250 13060 27204 1535 1015E CHOO (KOM (372) 100427 Salesfor E15.458 0.360 1815 1906 1905 15 20 25 52 CLASS ONZE FAM He 1918 (1523 14543 R546 11773 13.00 BUR 18850 BAG 2019,617 one A MSIS KES 38 AM nus du 117043 144 Tiem FALSE DRUM 05,900 1117,270 47006 (6304 TEGAS (HU) 05718 182006 476301194,023 SLPS CAIN ISOWELPSAM CALME LIZENZ C 2 Uper Se (200) 132084 197338 Chur Cenion (7240222470 153.4 Growth Rata Christo) entanther Mp fort Core Se Hype SARL) Tables Orders Return MN 10000km tout chang Cautio -boke - Pulpe Gro Puthe ST Sani Parameters -Dunha (EARCriar Dee} Cera Mey Ge U ME BJ 9 Fy Mas V AGG/SUM SA BUSAN www. THE 2 SARS AUTEUITY AWA 15:00 THE GEZE HAPPE MEMAS NEED Y 10: CUTE HAN LOS ALAN ATLER (LAT CIM < 20 KELE SWLED WED www GORY Wind 00 HOME ACHADO BOLE RENO SCO ven 57000 para o DETTE 1099) (TEE) perva OD 3070 SERIESSWID 00000 WWWDW 3000 SRE er www FECTOES, 990 TH 5 access mmi 160.09 (173 16030 (00304 78 PLZSUS CHLAZ 454,79 QUH DENE POB BUDET 143.575 1205) LUME GAI HAME AN ALB, FLUN FRA POMPA de 1775 L DUSH DOM FROH (4/41165370 1/1604 16 OLINE ASS EDATZE PACK 255 DPL CU CEI 19 1028 12240 CLAS LED BLU BASARN Sody What 0004 4 arar 12 Hashim Show Ma
Example 1: "One way of measuring a company's success is through assessing how well its departments are performing a thorough analysis of its key performance indicators. In this essay, we are going to dissect each vital information concerning the superstore company's various significant departments, product categories, its sales and profitability figures, together with forecasts. Every region has different profitability measures. If we compare the central, east, south and west, the sales and the results are entirely different, and each area has its customer base. The first region is central. The profit ratio per customer at the beginning of the year 2013 is different compared to the rate at the end of the year 2013. The sales per customer are $16, whereas the profit per customer is $6. This is very low, as the quantity that is being sold per customer was only 2.00 but fortunately, at the end of 2013, the sales and profit have increased. Every order date's profitability is unlike, though they do not follow a specific pattern. At the beginning of the year in 2013, the profit and the sales are less compared to orders at the end of the year which is higher, but in 2016, it's the opposite. As you can see in 2016, the sales in the west are $725,458 while the profit is $108,418. Compared to other regions, it is way higher than the rest especially in the south which has the lowest sales of $391,722 and profit of $46,749. Based on these observations, the company itself should investigate and find out how some regions (the ones with low profitability rate) can improve their sales and profits."