Automatizace procesů zpracování dat a reportingu v prostředí Power Automate Online

This bachelor thesis focuses on digital automation of reporting using the Power Automate Online tool in a manufacturing environment. Repetitive steps required for manual report creation place an unnecessary burden on specialized employees, thereby creating inefficiency in business management. The aim of this thesis is to analyse this process and develop an automated ETL (Extract, Transform, Load) solution. The theoretical part provides a comparative analysis of approaches to automation, which justifies the choice of a cloud solution (DPA) over traditional VBA macros or robotic process automation (RPA). The practical part describes the implementation of a functional prototype that uses cloud flow orchestration and advanced scripting in TypeScript (Office Scripts). The result is a fully automated system for filtering and conditional classification of production orders. The implementation of the solution in a real company has demonstrated not only significant time savings (FTE savings) but also increased accuracy of output analyses. The conclusion of the thesis offers a critical assessment of the limitations of cloud solutions and recommendations for their scaling.