Desarrollo de una solución de inteligencia de negocios para integrar datos de censo y encuesta en un SIG

In this paper we present the development of a Business Intelligence solution to manage the large volume of data generated from two data collection instruments, such as the National Census of people, households and housing and the Household Survey with the aim to develop a platform management integrated of databases for consultation of socioeconomic variables microterritorial with cartographic visualization. This solution involves the implementation of an Intermediate Data Warehouse that allows an overview of both data sources. Data integration is done by Spatial Matching technique that requires homogeneity conditions between the two instruments on the sample characteristics, the administrative units of spatial disaggregation and the answer or questions in the data. Using spatial location codes incorporated in a Spatial Database a through Geographic Information System (GIS), are added cartographic visualization tools, which facilitates the observation and analysis of spatial relationships between administrative geographical units and as observation and analysis of intra-regional particularities. In the application, we present the distribution of income per capita household in intracommunal units, information that has not been achieved so far as the data of household income in the household survey does not allow one disaggregation less than the Commune.Revista Ciencias Espaciales, Volumen 8, Numero 2 Otono, 2015; 287-303