Construcción y depuración de una base de datos como insumo para el desarrollo de un modelo de segmentación de clientes.

Abstract

This internship was conducted at DataKnow, an analytics consulting firm specialized in providing data-driven services through various tools. Founded in 2018 in Medellin, Colombia, DataKnow stands out in the technology sector by collaborating with leading companies such as Microsoft and SAS. The main focus of the internship was to develop an interest rate modeling for the banking sector, using data analysis to segment customers and determine optimal rates for various banking products. This involved building a database that encompassed risk, sociodemographic, transactional, and product information for both new and existing customers. Tools such as SAS® Guide, SQL, and Python were used for data analysis and exploration, ensuring data quality throughout the process.