DASHBOARD USABILITY IN FINANCIAL MODELING
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
Copyright information
- Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License (Creative Commons Attribution License 3.0 - CC BY 3.0) that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (See The Effect of Open Access).
info@iseic.cz, www.iseic.cz, ojs.journals.cz