Describe how your examples apply to analysis and the value of the visualization of data. Provide your source for your 2 dashboards and describe how you might improve each dashboard to increase ease of use and data visualization. Include the name of your dashboards in your subject line.
Prompt
Summarize how the assets, liabilities, and owner’s equity have changed over three years for Company A and Company B. Include screenshots of your data visualization as follows.
Summarize your observations about the financial performance of both companies. Include any insights you may have about their performance trends or how they have performed compared to each other over the past three years.
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
