Design And Implementation Of Data Warehouse System For Insurance Company Customer Analysis

Current insurance market is at a stage of rapid development,industry competition is also increasing year by year at the same time,and conventional marketing mode in the past cannot satisfy current market demand again,all insurance companies improve their marketing capacity by means of data analysis,and how to effectively use business data of insurance company to analyze customers to find potential customer demand has become an urgent problem to be solved by all insurance companies.Based on daily operation data of insurance companies,and combining with demand of customer analysis,this paper designs and creates a set of data warehouse system supporting all kinds of complex analysis functions flexibly and effectively.Different from centralized data storage of a single business database,there are many internal systems in insurance company,data storage is relatively scattered and data standards are different,which causes great difficulty for construction of data warehouse system.This paper focuses on data extraction to different databases and data cleaning and transformation function etc.and finally stores all kinds of data into data warehouse uniformly.This paper firstly introduces related theoretical knowledge,such as development status of current data warehouse technology and data warehouse construction mode and composition etc.in detail,lists past implementation cases of data warehouse in insurance industry,and gives detailed design of data warehouse system after making detailed analysis to system status and business requirements of insurance company,and realizes data extraction,data cleaning and data transformation function etc.based on it,and finishes construction of the whole data warehouse system.It finally realizes the function to establish data mart according to different analysis topics in data warehouse system,makes classified counting to customers in each data mart by using k-means algorithm and describes classification results one by one,and verifies support power of data warehouse system to customer analysis function through realization of customer analysis function to prove that design and realization of data warehouse system conform to demand of customer analysis.