PROCESS AUTOMATION WITH PYTHON AND POWER BI: OPERATIONAL GAINS IN CORPORATE ENVIRONMENTS
DOI:
https://doi.org/10.56238/levv12n30-024Keywords:
Process Automation, Python, Power BI, Operational Efficiency, Data GovernanceAbstract
This study examines operational gains resulting from the integration of programmatic automation using Python with analytic visualization through Power BI, aiming to quantify cycle time reductions, changes in error rates and impacts on human resource allocation, the research relied on a systematic bibliographic review synthesizing empirical studies, technical reports and academic works, findings show that automated ETL pipelines, code governance and optimized data models enhance continuous indicator availability, improve process traceability and free up capacity for higher-value analytical tasks, risks related to credential security, interoperability with legacy systems and error propagation from unvalidated automations were also observed, in response the study recommends controlled pilots, automated testing, version control policies and training programs as necessary conditions to convert automations into sustainable operational advantages.
Downloads
References
CHIEN, H.-Y. Use of business analytics in accounting firms Taking Deloitte as an example. E3S Web of Conferences, [s.l.], v. 218, p. 03004, 2020.
DESTIANDI, N.; HERMAWAN, A. Business intelligent method for academic dashboard. BIT Tech, [s.l.], v. 1, n. 2, p. 11–20, 2018.
GEYER-KLINGEBERG, J. et al. Process mining and robotic process automation: a perfect match. In: NEPAL, S. et al. (org.). BPM 2018: dissertation, demos and industry track. Aachen: CEUR-WS, 2018. p. 124–131.
GIL, A. C. Como elaborar projetos de pesquisa. 6. ed. São Paulo: Atlas, 2017.
LAKATOS, E. M.; MARCONI, M. de A. Fundamentos de metodologia científica. 7. ed. São Paulo: Atlas, 2017.
NORDMAN, J. Google Cloud and solution for industrial automation systems. 2020. Master’s thesis (Software Engineering) – University of Turku, Turku, 2020.
PHELPS, S. Scientific computing for finance using Python. 2019.
TASIĆ, N.; ĐURIĆ, Ž.; MALEŠEVIĆ, D.; MAKSIMOVIĆ, R.; RADAKOVIĆ, N. “Automation of Process Performance Management in a Company”. Tehnički vjesnik, v. 25, n. 2, p. 565-572, 2018.
WIDJAJA, S.; MAURITSIUS, T. The development of performance dashboard visualization with Power BI as platform. International Journal of Mechanical Engineering and Technology, [s.l.], v. 10, n. 5, p. 235–249, 2019.
YAHAYA, J. et al. The implementation of business intelligence and analytics integration for organizational performance management: a case study in public sector. International Journal of Advanced Computer Science and Applications, [s.l.], v. 10, n. 11, p. 292–299, 2019.
