Overview: Excel dashboards are powerful, easy to design, and a great way to improve your Excel and data visualization skills. Because of its flexibility, you can virtually design any dashboard in Excel. To complete this assignment, you will create a data visualization dashboard by creating a pivot table for your pre-selected data. Review the steps and resources in the assignment to complete this assignment, including the resources for creating a pivot table.
Prompt: You have been asked by your manager to provide a brief report simulating a dashboard view. The report is to show the performance of small/short-term loans that were issued in the past five years. The report should consider information such as how many loans were issued by different categories and how much was issued, repaid, profited, etc. The brief report is to show the executive management audience performance using graphical representations of the data via charts and other visualization methods.