Dashboards automation

Ing. Viktorie Láchová

Master's thesis

Abstract:

This master thesis presents a comprehensive exploration of dashboard automation within the enterprise workspace. It articulates a dual approach, starting with a robust theoretical foundation that encompasses the multifaceted aspects of Business Intelligence (BI), revealing its importance in the modern business environment. The information weaves together performance metrics for BI investments and key stakeholder roles while demystifying complex BI techniques and methodologies. Considerable emphasis is placed on optimization strategies and dashboard design, which can significantly increase the usefulness and effectiveness of BI tools in an organizational environment. Moving from theory to application, the work dives into the practical aspect, where the main task involves the development of a dashboard based on data from the Showpad Platform. This segment sheds light on the painstaking process of gathering requirements directly from the business project owner and ensuring that dashboard features are aligned with strategic business goals. The thesis details the data extraction process using Python, followed by sophisticated data transformation methods that solidify the backbone of a dynamic BI system. The culmination of this work is the strategic deployment of these techniques, which will not only make data visualization more efficient but also enable end users to quickly make informed decisions. The result of this thesis is a dashboard, which is evidence of the convergence of theoretical knowledge and practical application and offers substantial added value for the field of dashboard automation and potential end-users. The work asserts the potential of automated dashboards to revolutionize data interaction in enterprises, catalyzing better dissemination of business intelligence and strategic decision-making.

Keywords

Dashboard Automation, Business Intelligence, Data Management, Microsoft power BI, ETL, Data Modeling, Showpad Platform, REST API

Language used: English

Date on which the thesis was submitted / produced: 17. 4. 2024

Thesis defence

• Date of defence: 24. 5. 2024
• Supervisor: prof. RNDr. Petra Poulová, Ph.D.
• Reader: doc. Ing. Pavel Čech, Ph.D.

University of Hradec Králové

Faculty of Informatics and Management

Master programme / field:
Informační management / Informační management