The Bank Individual Customer Mining And Marketing System

Individual customers are the main customers of the bank, with the increasingly fierce competition of banking industry, the impact of the Internet banking is growing, for different customer characteristics, to provide customers with different services and recommend them with the products which they are more interested become one of the magic weapon of the bank. Although the banks accumulated large amounts of data from these years' online transaction system operation, but still lack of a set of data analysis and mining system to help business marketing. In order to solve this problem, the branches has launched the construction of individual customer mining and marketing system, the system provides support for the business marketing by the analysis and mining the relevant information of the individual customers, and at the same time to provide data statistics and other functions for the management of the organization and to provide help for business decisions.Firstly, This thesis discussed the data warehouse, data mart and related technologies,analyzed the differences of traditional database and data warehouse, the classification and system structure of data warehouse.Then, according to the customer's needs, we analyzed the main work to achieve the system by using object-oriented analysis techniques such as class diagram, use case model, sequence diagram and other methods. During the analysis process, this scheme designed the system performance, data security, data backup and recovery strategy based on the non functional requirements, and analyzed the data of the head bank and the branch bank, then the preliminary estimation of the data source and data scale which is used to establish the date mart is defined.Later, according to the concept model, logical model and physical model of data warehouse modeling technology, we abstract and analyze these three levels, and finally design the provincial branch of the data mart "two series, three layer" system architecture,Where "two" refers to the division of data storage, "three" refers to the division of achieve structure of the system.Subsequently, according to the results of the system analysis, we design the key module of the system from the data extract / transform / load, date mining, date display and other aspects. The system realization rule base for generating product relationships through Based on Association Rules Mining. When marketing is aimed at a specific customer, the system will matching the data in the rule base according to the customer's products have been held,the matching results will be recommended to customers. Improve the success rate of product recommendation by means of data mining, and further improve the user experience. Finally,this paper simply introduced the hardware and software environment of the system,and showed the actual operating results of the various modules of the system and the work done in data security.From the system's design to implementation, This paper preliminarily explored a set of methods for modeling the branches level data market in the domestic banking sector. After the system goes into operation, business sector gave the feedback when they acceptance the system :The system has basically met the business needs, and has completed the established objectives.Through the analysis of the system, the work of data mining can go further in the future,Add more dimensional data analysis, so that the data in the business marketing to play a greater role. moreover, increase more dimensions while analysis the data, so that the data can play a greater role in the business marketing.The implementation of this system has accumulated valuable experience for the construction of other subject analysis system,furthermore to lay a good foundation for the gradual completion of the enterprise level data warehouse.