Application of Business Intelligence to Analysis of Factors for the Prevention of Non-communicable Diseases

In Atlántico, Colombia, the Departmental Health Secretariat has been proactive in promoting healthy lifestyles to prevent non-communicable diseases (NCDs), adhering to the strategies outlined in the Health Action Plan (PAS) as recommended by the Ministry of Health’s Promotion and Prevention and Epidemiology and Demography Directorates. However, the efficacy of these activities is often hampered by a reliance on external data sources or studies from regions with dissimilar health determinants. This paper highlights the role of business intelligence tools—including dimensional fact models, multidimensional databases, ETL (Extract, Transform and Load) processes, and data visualization dashboards—in enhancing local data analysis, thereby providing valuable insights for public health management and research within Atlántico. By leveraging accurate, localized data, this approach strengthens decision-making processes in NCD prevention. The study aims to ascertain the impact of a healthy diet and physical activity on preventing NCDs among Atlántico’s vulnerable populations, utilizing a confirmatory research methodology that employs observation, surveys, and interviews within the constraints of the COVID-19 pandemic. The findings underscore the critical role of diet and exercise in NCD prevention and demonstrate the efficacy of employing digital analytical tools and business intelligence to inform user-centric health interventions. This research lays the groundwork for developing evidence-based, locally tailored NCD prevention strategies, marking a significant advancement in public health initiatives in Atlántico.