Aplicación y reconocimiento de herramientas informáticas de código sql, r y power bi en la optimización de la gestión del tratamiento de datos en la línea de negocios bienestar

Abstract

Data analysis reveals phenomena and makes decisions based on large datasets, transforming our understanding of the world. In today's society, this practice is crucial for identifying problems and improving services, fostering innovation in line with the needs of the population. This project aims to present data management tools such as SQL, R, and Power BI, highlighting their role in optimizing data management. Their fundamentals and applications are explored through case studies, emphasizing best practices for efficient usage. Furthermore, it seeks to bridge the gap between university education and the professional career, enabling future mathematicians to contribute to the technological and scientific development of the country. This project is developed in R Markdown, combining text with Markdown formatting and R programming code in a single file, providing a dynamic environment for data exploration.