Question
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:
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Financial Accounting
Authors: W. Steve Albrecht, James D. Stice, Earl K. Stice
10th edition
324645570, 978-0324645576
