DASHBOARD USABILITY IN FINANCIAL MODELING

  • Ivan Stríček University of Žilina in Žilina, FPEDaS, Department of Communication
  • Ivana Andrisková University of Žilina in Žilina, FPEDaS, Department of Communication
Keywords: Dashboard, financial, modeling, tool, excel, data

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.

References

Benninga, S. (2014). Financial Modeling (4th ed.). Massachusetts Institute of Technology. ISBN 978-0-262-02728-1

Bobot, V., Jakubeková, M., & RURÁK, M. (2012). Využívanie informačno-komunikačných technológií vo vyučovaní [The use of ICT in education]. Bratislava: Metodicko-pedagogické centrum v Bratislave. Retrieved from http://iktmpcke.blgz.cz/data/subory/ikt_material.pdf. ISBN 978-80-8052-389-3

Campbell, J. Y., Lo, A. W., & McKinley, A. C. (1996). The Econometrics of Financial Markets. Princeton University Press.

Centre for educational research and innovation, (1995). Measuring the quality of schools. Paris: OECD. ISBN 9789264043558

Creemers Bert P. M., & Kyriakides, L., (2011). Improving Quality in Education: Dynamic Approaches to School Improvement. Taylor and Francis. ISBN 9780203817537

DeMiguel, V., Garlappi, L., & Uppal, R. (2007). Optimal versus Naive Diversifi cation: How Ineffi cient Is the 1/N Portfolio Strategy? Review of Financial Studies

Freeth Della S., Hammick M., Reeves S., Koppel I., Barr H., (2005). Effective Interprofessional Education: Development, Delivery, and Evaluation. Wiley. ISBN 9781405116534

Frost, P. A., & Savarino, J. E. (1986). An Empirical Bayes Approach to Portfolio Selection. Journal of Financial and Quantitative Analysis, volume 21 (issue 03), 293-305.

Jorion, P. (1986). Bayes-Stein Estimation for Portfolio Analysis. Journal of Financial and Quantitative Analysis, volume 21 (issue 3), 279-292.

Juszczyk, S. (2003). Distančné vzdelávanie: konštruktivistický prístup [Distance learning: constructivist approach]. Bratislava: Sapientia, 170 s. ISBN 80-968797-3-1. Preklad z poľského originálu.

Matedeis, A., Pohančaník P., Cajchan J., Závadský J., Gabryšová M., Kapusta J. (2005). Manažérstvo kvality: história, koncepty, metódy [Quality management: history, concepts, methods]. EPOS Bratislava, 751 s. ISBN 80-8057-656-4

Nightingale, P., & O’Neil M., (2012). Achieving Quality Learning in Higher Education. Taylor and Francis, ISBN 9781136352409

Štofková, K., & Štofková, J. (2011). Manažment podniku [Business management]. EDIS: Žilinská univerzita v Žiline. ISBN 978-80-554-0418-9

Stríček, I. (2013). Costs of quality in company and their measurement. TRANSCOM 2013 Section 2, ISBN 978-80-8070-695-5

World Bank (2007). Education Quality and Economic Growth. Washington, D.C: The World Bank. ISBN 0821370588

Zounek, J. (2006). E-learning a vzdelávanie, nekolik pohledu na problematiku e-learningu [E-learning and training, several of view on the issue of e-learning]. Pedagogika, LVI, 335-340

Zounek, J., & Sudický, P. (2012). E-learning: učení (se) s online technologiemi. 1. vyd [E-learning: learning (IT) with online technologies (1st ed.)] Praha: Wolters Kluwer. ISBN 978-80-7357-903-6

Published
2015-09-19