Research Of Bank CRM System Based On Data Warehouse

Customer Relationship Management (CRM), a more and more popular topic, brings every enterprise under a profound reform. CRM is a process that can obtain, maintain and increase profitable customers. Banks begin to transform share system in the face of challenge posed by WTO, and banks have to improve core competence in order to keep the persistent development under the opportunity and the pressure such as ruffling. CRM becomes much more important for banking than ever. A successful CRM system is based on the solution to two nuclear technical problems that is integration and analysis of customer information. The concerned problem of banks is how banks can integrate all information relevant to customer and provide a uniform data platform for all mutual activities with customers and decision-making by building the customer-oriented data warehouse.The thesis brings forward a frame of bank CRM system based on data warehouse by analyzing the request of bank CRM. Then the thesis further analyses some core techniques including the system of database, data warehouse and data mining and so on, and presents the frame of function of bank CRM. The thesis puts its emphasis on the research on the data preprocessing of data warehouse, data copying, data cleansing, data integration and quality verifying included. Finally the thesis discusses the key technology of data warehouse in bank CRM-the cleansing of data of customers, and presents some methods of cleansing aiming at noisy values, missing values, conflicting values and duplicated values.