EUVIMEDEUVIMED entdecken
Open Access · CC BY-NC 4.0

BUSINESS INTELLIGENCE IN DECISION-MAKING IN A WATER TREATMENT SYSTEM

Sarah Fernanda Araujo Ferreira, Alan Rodrigues

Revista e-TECH: Tecnologias para Competitividade Industrial - ISSN - 1983-1838 · 20.07.2026 · 19 (1)

DOI: 10.18624/e-tech.v19i1.1476 ↗

Kurz gefasst

Fachartikel in der Zeitschrift Revista e-TECH: Tecnologias para Competitividade Industrial - ISSN - 1983-1838, online erschienen am 20.07.2026. Verfasst von Sarah Fernanda Araujo Ferreira und 1 weiteren Autor:innen. Der Volltext ist frei zugänglich (Open Access, CC BY-NC 4.0).

AbstractBibliografische AngabenZitierenVerwandte Studien

Abstract (Originalsprache)

This study aims to develop a decision support tool based on BI techniques, designed to optimize the management of the Water for Injection (WFI) treatment system in a pharmaceutical industry, aligned with business rules that, guarantee the quality, traceability, and compliance of the process. The methodology adopted is structured in five main stages: acquisition of operational data; development of a digital tool for standardized data entry; storage and consolidation of information; dynamic visualization through dashboards; and analysis of performance indicators to support decision-making. As a practical solution, a UserForm® in Microsoft Excel® and a form in Microsoft Forms® were created for field data collection, which optimized the capture of operational readings. The data were processed using Power Query® and presented in Power BI®, which allowed for automation in the cleaning, filtering, and validation stages regarding integrity and consistency. Among the main products generated were indicators of temperature, conductivity, flow rate, and water consumption, which operated as essential information services for management. These indicators enable the early identification of deviations, rapid responses to non-conformities, and the promotion of continuous improvement. The application of this methodology has yielded gains in operational efficiency and reliability. For the production sector, the direct consumer of the service, the benefits include the safety and quality of the input, ensuring compliance with the regulatory standards in the pharmaceutical sector.

Zitieren

APA

Ferreira, S. F. A., & Rodrigues, A. (2026). BUSINESS INTELLIGENCE IN DECISION-MAKING IN A WATER TREATMENT SYSTEM. Revista e-TECH: Tecnologias para Competitividade Industrial - ISSN - 1983-1838, 19(1). https://doi.org/10.18624/e-tech.v19i1.1476

Vancouver

Ferreira SFA, Rodrigues A. BUSINESS INTELLIGENCE IN DECISION-MAKING IN A WATER TREATMENT SYSTEM. Revista e-TECH: Tecnologias para Competitividade Industrial - ISSN - 1983-1838. 2026;19(1). doi:10.18624/e-tech.v19i1.1476

BibTeX
@article{Ferreira2026,
  author = {Ferreira, Sarah Fernanda Araujo and Rodrigues, Alan},
  title = {BUSINESS INTELLIGENCE IN DECISION-MAKING IN A WATER TREATMENT SYSTEM},
  journal = {Revista e-TECH: Tecnologias para Competitividade Industrial - ISSN - 1983-1838},
  year = {2026},
  volume = {19},
  number = {1},
  doi = {10.18624/e-tech.v19i1.1476}
}
Kostenlos starten →