Castillo-Rojas, WilsonWilsonCastillo-RojasAlcota Puga, FranciscoFranciscoAlcota PugaAngulo Olivares, VictorVictorAngulo Olivares2026-07-072026-07-072025EXTENDED REALITY AND SERIOUS GAMES FOR EDUCATION, COMPETITIVENESS, AND WELLBEING, CIIS 2024, 48, 68-90 (2025). https://doi.org/10.1007/978-3-031-91481-2_53004-958Xhttps://hdl.handle.net/20.500.12740/24781This article describes the design and implementation of a data warehouse that provides indicators on patient care for a network of public health centers in a Latin American country. The aim of this work is to provide a platform to support the decision-making of strategic users responsible for managing this healthcare network. Additionally, it validates a new methodology that combines different approaches, techniques, tools, and methodologies, such as information requirements specification, relational database modeling, and a combined development process based on the Kimball and Hephaestus methodologies. This process also incorporates a validation phase of indicators and integrated, interactive visualizations for the multidimensional analysis of the obtained indicators. Regarding the results obtained with the implementation of this data warehouse, it is noteworthy that the institution in charge of managing the health centers now has a platform that allows them to analyze the average rates of appointments and patient care, as well as the costs associated with these appointments, among other indicators. This enables them to more clearly identify health centers prone to patient care collapse and take preventive measures to avoid it. From the perspective of the data warehousing process development, the team responsible for it confirms the simplicity and effectiveness of the new methodological proposal.business intelligencedata warehousedata martdata warehousing processhealth centersArticulohttps://doi.org/10.1007/978-3-031-91481-2_5