The Design And Implementation Of Population Data Analysis System Based On Data Warehouse

With the development of information technology building of various industries,the application is becoming more widely used for varius operation systems,the size of population information data from business process is also gradually revealed.The mass population data should be researched and analysised for exploring the potential value,and the transformation of potential imformation will play more value and serve the actual business and decision support.Thus,the building of data analysis system based population information is practical and significant.Nowadays,data warehouse technology for massive data is widely researched and used,and also play a more and more important role.Population information data has the characteristics of mass storage.If we combine the data warehouse technology with the application of statistical analysis,the potential value of population information will be huge.This thesis based on population information date,data ware house technology,will put various data source ETL(Extraction Transformation Loading) into the date warehouse,sort out data according to the practical business needs,refine business data and dimension according to fact data and analytical review,build the model of analytical data comprise of fact tables and dimension tables,research basic method of population data statistics,and do analytical reports by OLAP(On-Line Analytical Processing) technology,build a population data analysis system for decision support and research.Building a data analysis system based on population information data,will support for decision,marketing,study and advertisement,provide effective and customizable analytical data to social institutions,explore more value from population data.