DASHBOARD USABILITY IN FINANCIAL MODELING

  • Stríček I
  • Andrisková I
N/ACitations
Citations of this article
11Readers
Mendeley users who have this article in their library.

Abstract

This article is focused on the possibility of utilizing dashboard applications in financial modeling. In the era of easy access to the spreadsheet generator, as well as applications and the Internet, it is appropriate to use these tools in each area. The increasing amount of data and the need for daily monitoring and evaluation lead to the development of management applications with graphical data analysis known as “Dashboards.” The manager has the option to buy the app with a predefined environment, or create his own version—specific to the company. If only a simpler design is needed, without an online base and a connection with external databases, then it is possible to create such a simple dashboard using Excel and manage it by trained personnel. In the article, we, therefore, introduced a sample of financial indicator suitable for analysis through the application process and also showed how to create the basic interactive application.

Figures

  • Figure 1: Balance sheet form and Profit and Loss Statement (formal Slovakia templates)
  • Figure 2: Balance sheet form and Profit and Loss Statement (Pivot tables templates)
  • Figure 4: Data drawing table for liquidity calculation
  • Figure 3: Manageable Pivot table constants with “Year” key
  • Figure 5: Liquidity calculation table
  • Figure 10. Control macro VBA Excel code
  • Figure 11: Summary of financial model dashboard

Register to see more suggestions

Mendeley helps you to discover research relevant for your work.

Already have an account?

Cite

CITATION STYLE

APA

Stríček, I., & Andrisková, I. (2015). DASHBOARD USABILITY IN FINANCIAL MODELING. CBU International Conference Proceedings, 3, 020–027. https://doi.org/10.12955/cbup.v3.579

Readers over time

‘19‘20‘21‘22‘23‘24‘2501234

Readers' Seniority

Tooltip

PhD / Post grad / Masters / Doc 3

60%

Lecturer / Post doc 2

40%

Readers' Discipline

Tooltip

Engineering 3

75%

Business, Management and Accounting 1

25%

Save time finding and organizing research with Mendeley

Sign up for free
0