Question

1 Approved Answer

Posted on Sep 09, 2024

Create a useful dashboard for the data in the Excel file Corporate Default Database. Use appropriate charts and layouts and other visualization tools that help

Create a useful dashboard for the data in the Excel file Corporate Default Database. Use appropriate charts and layouts and other visualization tools that help to convey the information. Explain why you chose the elements of the dashboard and how a manager might use them.

image text in transcribed

$1,574,352 $ $ Manufacturing Open with "Microsoft Excel 6 Corporate Default Database Company Category Credit Score Payment delay in last 3 months? Debt Equity Profit/Loss Amount Default Assessment 1 Service 604 Yes $11,672,388 $3,742,284 Profit $336,024 Yes 2 Manufacturing 714 No $3,294,252 $2,391,324 Profit $298,584 No 3 Manufacturing 732 No $192,816 NO Profit $704,496 No 4 Manufacturing 792 No $8,778,744 $11,463,348 Profit We $3,208,764 No NO 5 Service 623 No 020 $3,206.736 $3,200.00 $159,588 $710,580 No Loss Yes $109,500 Manufacturing 702 No 102 $4,048,356 Loss $66,924 Yes 7 Service 764 No Service $4,485.312 $6,107,868 50, 107.000 Profit $752,076 No $4,400.012 752016 No 8 Manufacturing 690 No $7,813,104 090 $5,870,904 Profit No $801,528 $801,520 From No 9 Service 802 No $7.149.948 OUZ $11,444,628 143,410 Profit No $2,864,004 From NO 10 Service 610 No TO $14,759,472 $3,911,232 Loss $1,560,312 Yes 11 Manufacturing 590 Yes $19.771.284 $8,254,740 Profit vou $2,003,352 ico From No 12 Manufacturing 824 No $542.568 $ 14 $31,290,168 Profit $11,336,832 No No 13 Service 762 No $873,600 $4,524,000 10 Loss No Los $66,456 NO 14 Manufacturing 601 No $1,631,604 Profit $320,112 ! $34.164 Yes NO From PS4,104 15 Manufacturing 655 Yes $32,253,936 $14.777.724 Loss Yes Too $407,472 Too 16 Manufacturing 792 No $4,853,472 $4,532,736 Profit TO $751,452 No NO NO 17 Manufacturing 721 12! No $3,705,468 $14,046,552 Profit Front $5,451,264 No NO 18 Manufacturing 750 No To $12,623,676 $11,253,060 Profit $1,446,432 No NO 19 Manufacturing 762 No 19 $5,384,340 $18,725,616 Profit No NO 20 Service 598 Yes $2,764,788 $534,924 Profit 20 $76,752 Yes TES 21 742 No 29 $7,101,588 Profit NO $4,167,228 No $409,032 NO 22 Manufacturing 821 $3,923,088 $14,434,524 Loss NO No $1,872 LOSS NO 23 657 No $3,950,544 $5,349,084 Loss $264,732 Yes 24 Manufacturing 798 No $3,341,988 $3,121,872 Profit $2,698,176 No 25 Manufacturing 695 No $9,971,208 $5,556,252 Profit $784,524 No om 26 Service 819 No $10,583,508 $9,030,684 Profit $6,391,476 No e c..01 om 27 Manufacturing 671 No $23,596,092 $6,685,692 Loss $51,324 Yes 28 Manufacturing 771 No $9.741,576 $6,742.788 Profit $1,077,024 No 29 Service 832 No $11,858,496 $13,613,652 Profit $533,988 No 30 Service 759 No $895,128 $1,894,932 Profit $163,332 No 31 Manufacturing 613 No $5,965,440 $828,672 Loss $146,796 Yes 32 Manufacturing 705 No $6,745,908 $5,966,220 Profit $878,280 No Service $1,574,352 $ $ Manufacturing Open with "Microsoft Excel 6 Corporate Default Database Company Category Credit Score Payment delay in last 3 months? Debt Equity Profit/Loss Amount Default Assessment 1 Service 604 Yes $11,672,388 $3,742,284 Profit $336,024 Yes 2 Manufacturing 714 No $3,294,252 $2,391,324 Profit $298,584 No 3 Manufacturing 732 No $192,816 NO Profit $704,496 No 4 Manufacturing 792 No $8,778,744 $11,463,348 Profit We $3,208,764 No NO 5 Service 623 No 020 $3,206.736 $3,200.00 $159,588 $710,580 No Loss Yes $109,500 Manufacturing 702 No 102 $4,048,356 Loss $66,924 Yes 7 Service 764 No Service $4,485.312 $6,107,868 50, 107.000 Profit $752,076 No $4,400.012 752016 No 8 Manufacturing 690 No $7,813,104 090 $5,870,904 Profit No $801,528 $801,520 From No 9 Service 802 No $7.149.948 OUZ $11,444,628 143,410 Profit No $2,864,004 From NO 10 Service 610 No TO $14,759,472 $3,911,232 Loss $1,560,312 Yes 11 Manufacturing 590 Yes $19.771.284 $8,254,740 Profit vou $2,003,352 ico From No 12 Manufacturing 824 No $542.568 $ 14 $31,290,168 Profit $11,336,832 No No 13 Service 762 No $873,600 $4,524,000 10 Loss No Los $66,456 NO 14 Manufacturing 601 No $1,631,604 Profit $320,112 ! $34.164 Yes NO From PS4,104 15 Manufacturing 655 Yes $32,253,936 $14.777.724 Loss Yes Too $407,472 Too 16 Manufacturing 792 No $4,853,472 $4,532,736 Profit TO $751,452 No NO NO 17 Manufacturing 721 12! No $3,705,468 $14,046,552 Profit Front $5,451,264 No NO 18 Manufacturing 750 No To $12,623,676 $11,253,060 Profit $1,446,432 No NO 19 Manufacturing 762 No 19 $5,384,340 $18,725,616 Profit No NO 20 Service 598 Yes $2,764,788 $534,924 Profit 20 $76,752 Yes TES 21 742 No 29 $7,101,588 Profit NO $4,167,228 No $409,032 NO 22 Manufacturing 821 $3,923,088 $14,434,524 Loss NO No $1,872 LOSS NO 23 657 No $3,950,544 $5,349,084 Loss $264,732 Yes 24 Manufacturing 798 No $3,341,988 $3,121,872 Profit $2,698,176 No 25 Manufacturing 695 No $9,971,208 $5,556,252 Profit $784,524 No om 26 Service 819 No $10,583,508 $9,030,684 Profit $6,391,476 No e c..01 om 27 Manufacturing 671 No $23,596,092 $6,685,692 Loss $51,324 Yes 28 Manufacturing 771 No $9.741,576 $6,742.788 Profit $1,077,024 No 29 Service 832 No $11,858,496 $13,613,652 Profit $533,988 No 30 Service 759 No $895,128 $1,894,932 Profit $163,332 No 31 Manufacturing 613 No $5,965,440 $828,672 Loss $146,796 Yes 32 Manufacturing 705 No $6,745,908 $5,966,220 Profit $878,280 No Service