ICPM 2024 · 2024
Modelo metodológico para facilitar la toma de decisiones en empresas del sector de la construcción y ferretería en Colombia
The Business Intelligence model implementation provides a competitive advantage allowing a better analysis of both financial and operational situation of organizations. In the strategic processes of many small and medium-sized companies in the construction supply and hardware industry in Colombia, there is currently a need to establish a more effective and timely management of financial information, as well as the centralization of data. The case study is a company located in the city of Tunja, Colombia. The proposed methodology includes external and internal situational diagnosis. The importance of the management of financial indicators for decision makers, is highlighted. The proposed methodology includes stages ranging from the definition of the company's objectives to dashboards that incorporate key performance indicators in the financial area. The project management proposal involves management of a data warehouse, design of data model, data extraction, transformation and loading (ETL) processes and development of data analysis and visualization tools. This article proposes a methodological model to significantly improve the management and exploitation of financial data in companies of the construction and hardware sector in Colombia with a focus on more agile decision-making process.