Using this data set , help build a fully automated and professional looking dashboard Please ensure you are writing out step by step what you did to get there for the final result, so I know how to do the assignment Every step written out would be very beneficial Dataset Part Number Inventory Class Average Daily Use Value of part Average Total Value Warehouse 93657 B 890 $384 $341,760 Dallas 99784 C 562 $250 $140,500 Dallas 84481 C 776 $245 $190,120 Dallas 42950 A 871 $287 $249,977 Dallas 83104 A 845 $168 $141,960 Dallas 88335 C 190 $63 $11,970 Dallas 74813 B 610 $342 $208,620 Dallas 83491 C 550 $361 $198,550 Dallas 85239 A 796 $188 $149,648 Dallas 32613 B 371 $32 $11,872 Dallas 38081 C 476 $313 $148,988 Dallas 61447 C 706 $499 $352,294 Dallas 46844 A 198 $254 $50,292 Dallas 63241 B 890 $87 $77,430 Dallas 94251 B 831 $18 $14,958 Dallas 85393 A 456 $477 $217,512 Dallas 76776 C 367 $91 $33,397 Dallas 12942 B 525 $214 $112,350 Dallas 42933 B 134 $133 $17,822 Dallas 71199 B 672 $269 $180,768 Dallas 39784 C 786 $151 $118,686 Dallas 25936 B 704 $206 $145,024 Dallas 32198 C 958 $377 $361,166 Dallas 67237 B 530 $405 $214,650 Dallas 19451 C 152 $394 $59,888 Dallas 98366 C 739 $50 $36,950 Dallas 42237 A 676 $309 $208,884 Dallas 30508 A 872 $210 $183,120 Dallas 12215 C 486 $91 $44,226 Dallas 30201 C 367 $421 $154,507 Dallas 97979 C 701 $197 $138,097 Dallas 97054 B 157 $400 $62,800 Dallas 54407 A 692 $400 $276,800 Dallas 46715 C 520 $368 $191,360 Dallas 43093 C 312 $53 $16,536 Dallas 53275 C 873 $218 $190,314 Dallas 72636 A 872 $317 $276,424 Dallas 55804 B 710 $290 $205,900 Dallas 11373 C 436 $95 $41,420 Dallas 11726 A 498 $125 $62,250 Dallas 96584 A 400 $199 $79,600 Daytona Beach 65513 A 313 $264 $82,632 Daytona Beach 95858 B 215 $135 $29,025 Daytona Beach 54124 B 592 $14 $8,288 Daytona Beach 47561 C 115 $417 $47,955 Daytona Beach 58112 B 134 $58 $7,772 Daytona Beach 21486 C 397 $252 $100,044 Daytona Beach 23537 C 922 $385 $354,970 Daytona Beach 99746 C 960 $110 $105,600 Daytona Beach 44752 B 922 $121 $111,562 Daytona Beach 11063 A 710 $67 $47,570 Daytona Beach 13143 C 676 $214 $144,664 Daytona Beach 89887 B 486 $438 $212,868 Daytona Beach 43867 A 167 $499 $83,333 Daytona Beach 84802 B 728 $245 $178,360 Daytona Beach 32482 B 958 $141 $135,078 Daytona Beach 37038 A 855 $38 $32,490 Daytona Beach 19338 A 238 $405 $96,390 Daytona Beach 41111 C 307 $166 $50,962 Daytona Beach 15418 C 408 $6 $2,448 Daytona Beach 87930 A 541 $160 $86,560 Daytona Beach 17243 A 140 $227 $31,780 Daytona Beach 85672 C 569 $389 $221,341 Daytona Beach 78497 C 970 $42 $40,740 Daytona Beach 35711 C 904 $398 $359,792 Wilmington 21066 C 354 $21 $7,434 Wilmington 13774 A 160 $237 $37,920 Wilmington 60983 C 142 $336 $47,712 Wilmington 29934 C 238 $478 $113,764 Wilmington 42931 B 896 $387 $346,752 Wilmington 67628 B 553 $234 $129,402 Wilmington 30882 B 954 $95 $90,630 Wilmington 42218 C 130 $240 $31,200 Wilmington 62276 A 930 $90 $83,700 Wilmington 15614 C 955 $271 $258,805 Wilmington 62613 A 990 $492 $487,080 Wilmington 46740 B 628 $427 $268,156 Wilmington 79495 A 627 $265 $166,155 Wilmington 67833 B 512 $494 $252,928 Wilmington 75788 B 192 $435 $83,520 Wilmington 99876 A 685 $106 $72,610 Wilmington 11135 C 733 $194 $142,202 Wilmington 58596 B 855 $95 $81,225 Wilmington 53955 B 781 $18 $14,058 Wilmington 15128 C 873 $294 $256,662 Wilmington 89251 C 709 $364 $258,076 Wilmington 62471 C 364 $37 $13,468 Wilmington 42247 C 518 $464 $240,352 Wilmington 79054 B 614 $209 $128,326 Wilmington 91860 C 763 $1 $763 Wilmington 80075 C 719 $405 $291,195 Wilmington 23136 B 867 $356 $308,652 Wilmington 58931 B 495 $285 $141,075 Wilmington 35026 A 574 $13 $7,462 Wilmington 48962 C 160 $433 $69,280 Wilmington 38463 C 653 $364 $237,692 Wilmington 85774 C 384 $234 $89,856 Wilmington 89756 C 102 $499 $50,898 Wilmington 39909 C 561 $113 $63,393 Wilmington 75703 A 471 $391 $184,161 Wilmington The final dashboard will look almost exactly like the one attached to the data given Please tell me step by step how to get there I will give it a thumbs up with no hesitation if done like this ZOOM W Date LX Units Sold Total Q1 2019 Q1 2021 QUARTERS 160,000 Sum of 2019 2020 2021 Row Labels Units Sold 140,000 Q1 Q2 Q3 04 01 Q2 03 04 Q1 Product A 144,082 120,000 Product B 148,214 Product C 115,000 100,000 Product D 142,420 80,000 Product E 114,505 Product A Grand Total 664,221 60,000 11 40,000 Product B 12 Revenue 1 20,000 Product C Sum of 13 Product D Row Labels Revenue Product A Product B Product C Product D Product E 14 Product A $144,082 Product E 15 Product B $296,428 16 Product C $345,000 Values Sum of Cost Sum of Revenue 17 Product D $569,680 $700,000 18 Product E $572,525 19 Grand Total $1,927,715 $600,000 20 $500,000 21 Cost vs Revenue $400,000 Sum of $300,000 Row Labels Cost Sum of Revenue $200,000 Product A $72,050 $144,082 Product B $151,895 $296,428 $100,000 Product C $175,784 $345,000 SO 26 Product D $283,464 $569,680 Product B Product D Product E Product C Product A 27 Product E $288,336 $572,525 28 Grand Total $971,528 $1,927,715 an

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jun 28, 2024

Using this data set , help build a fully automated and professional-looking dashboard. Please ensure you are writing out step-by-step what you did to get

Using this data set,help build a fully automated and professional-looking dashboard. Please ensure you are writing out step-by-step what you did to get there for the final result, so I know how to do the assignment. Every step written out would be very beneficial!

Dataset :

Part Number	Inventory Class	Average Daily Use	Value of part	Average Total Value	Warehouse
93657	B	890	$384	$341,760	Dallas
99784	C	562	$250	$140,500	Dallas
84481	C	776	$245	$190,120	Dallas
42950	A	871	$287	$249,977	Dallas
83104	A	845	$168	$141,960	Dallas
88335	C	190	$63	$11,970	Dallas
74813	B	610	$342	$208,620	Dallas
83491	C	550	$361	$198,550	Dallas
85239	A	796	$188	$149,648	Dallas
32613	B	371	$32	$11,872	Dallas
38081	C	476	$313	$148,988	Dallas
61447	C	706	$499	$352,294	Dallas
46844	A	198	$254	$50,292	Dallas
63241	B	890	$87	$77,430	Dallas
94251	B	831	$18	$14,958	Dallas
85393	A	456	$477	$217,512	Dallas
76776	C	367	$91	$33,397	Dallas
12942	B	525	$214	$112,350	Dallas
42933	B	134	$133	$17,822	Dallas
71199	B	672	$269	$180,768	Dallas
39784	C	786	$151	$118,686	Dallas
25936	B	704	$206	$145,024	Dallas
32198	C	958	$377	$361,166	Dallas
67237	B	530	$405	$214,650	Dallas
19451	C	152	$394	$59,888	Dallas
98366	C	739	$50	$36,950	Dallas
42237	A	676	$309	$208,884	Dallas
30508	A	872	$210	$183,120	Dallas
12215	C	486	$91	$44,226	Dallas
30201	C	367	$421	$154,507	Dallas
97979	C	701	$197	$138,097	Dallas
97054	B	157	$400	$62,800	Dallas
54407	A	692	$400	$276,800	Dallas
46715	C	520	$368	$191,360	Dallas
43093	C	312	$53	$16,536	Dallas
53275	C	873	$218	$190,314	Dallas
72636	A	872	$317	$276,424	Dallas
55804	B	710	$290	$205,900	Dallas
11373	C	436	$95	$41,420	Dallas
11726	A	498	$125	$62,250	Dallas
96584	A	400	$199	$79,600	Daytona Beach
65513	A	313	$264	$82,632	Daytona Beach
95858	B	215	$135	$29,025	Daytona Beach
54124	B	592	$14	$8,288	Daytona Beach
47561	C	115	$417	$47,955	Daytona Beach
58112	B	134	$58	$7,772	Daytona Beach
21486	C	397	$252	$100,044	Daytona Beach
23537	C	922	$385	$354,970	Daytona Beach
99746	C	960	$110	$105,600	Daytona Beach
44752	B	922	$121	$111,562	Daytona Beach
11063	A	710	$67	$47,570	Daytona Beach
13143	C	676	$214	$144,664	Daytona Beach
89887	B	486	$438	$212,868	Daytona Beach
43867	A	167	$499	$83,333	Daytona Beach
84802	B	728	$245	$178,360	Daytona Beach
32482	B	958	$141	$135,078	Daytona Beach
37038	A	855	$38	$32,490	Daytona Beach
19338	A	238	$405	$96,390	Daytona Beach
41111	C	307	$166	$50,962	Daytona Beach
15418	C	408	$6	$2,448	Daytona Beach
87930	A	541	$160	$86,560	Daytona Beach
17243	A	140	$227	$31,780	Daytona Beach
85672	C	569	$389	$221,341	Daytona Beach
78497	C	970	$42	$40,740	Daytona Beach
35711	C	904	$398	$359,792	Wilmington
21066	C	354	$21	$7,434	Wilmington
13774	A	160	$237	$37,920	Wilmington
60983	C	142	$336	$47,712	Wilmington
29934	C	238	$478	$113,764	Wilmington
42931	B	896	$387	$346,752	Wilmington
67628	B	553	$234	$129,402	Wilmington
30882	B	954	$95	$90,630	Wilmington
42218	C	130	$240	$31,200	Wilmington
62276	A	930	$90	$83,700	Wilmington
15614	C	955	$271	$258,805	Wilmington
62613	A	990	$492	$487,080	Wilmington
46740	B	628	$427	$268,156	Wilmington
79495	A	627	$265	$166,155	Wilmington
67833	B	512	$494	$252,928	Wilmington
75788	B	192	$435	$83,520	Wilmington
99876	A	685	$106	$72,610	Wilmington
11135	C	733	$194	$142,202	Wilmington
58596	B	855	$95	$81,225	Wilmington
53955	B	781	$18	$14,058	Wilmington
15128	C	873	$294	$256,662	Wilmington
89251	C	709	$364	$258,076	Wilmington
62471	C	364	$37	$13,468	Wilmington
42247	C	518	$464	$240,352	Wilmington
79054	B	614	$209	$128,326	Wilmington
91860	C	763	$1	$763	Wilmington
80075	C	719	$405	$291,195	Wilmington
23136	B	867	$356	$308,652	Wilmington
58931	B	495	$285	$141,075	Wilmington
35026	A	574	$13	$7,462	Wilmington
48962	C	160	$433	$69,280	Wilmington
38463	C	653	$364	$237,692	Wilmington
85774	C	384	$234	$89,856	Wilmington
89756	C	102	$499	$50,898	Wilmington
39909	C	561	$113	$63,393	Wilmington
75703	A	471	$391	$184,161	Wilmington

The final dashboard will look almost exactly like the one attached to the data given. Please tell me step-by-step how to get there! I will give it a thumbs up with no hesitation if done like this:

ZOOM + W Date LX Units Sold Total Q1 2019 - Q1 2021 QUARTERS 160,000 Sum of 2019 2020 2021 Row Labels | Units Sold 140,000 Q1 Q2 Q3 04 01 Q2 03 04 Q1 Product A 144,082 120,000 Product B 148,214 Product C 115,000 100,000 Product D 142,420 80,000 Product E 114,505 Product A Grand Total 664,221 60,000 11 40,000 Product B 12 Revenue 1 20,000 Product C Sum of 13 Product D Row Labels |Revenue Product A Product B Product C Product D Product E 14 Product A $144,082 Product E 15 Product B $296,428 16 Product C $345,000 Values Sum of Cost -Sum of Revenue 17 Product D $569,680 $700,000 18 Product E $572,525 19 Grand Total $1,927,715 $600,000 20 $500,000 21 Cost vs. Revenue $400,000 Sum of $300,000 Row Labels . Cost Sum of Revenue $200,000 Product A $72,050 $144,082 Product B $151,895 $296,428 $100,000 Product C $175,784 $345,000 SO 26 Product D $283,464 $569,680 Product B Product D Product E Product C Product A 27 Product E $288,336 $572,525 28 Grand Total $971,528 $1,927,715 an