The Design And Implementation Of Data Statistical Analysis System About The Cooperation Between Bank And School Card

With the whole great development of society digitization, the campus information technology also intense to be pursued. in our country, various colleges and universities have gradually integrate resources during construction tasks, aims to integrate the information inside the campus, the information resources full integration of rational planning, easy to manage shared.More and more schools are in the use of campus IC card, the IC card contains the amount of very large data, the vast data must be much more than the original campus card.If these large data are professional statisticed, analysised, and further data mining, I believe that we can analyze andquantify the card users consumption, thus to obtain the certain regularity, and provide some support for school management school for a management control decisions; Provide data support for the IC company, in business can be more accurate to judge system requirements, helping other IC construction projects after reasonable allocation for resources; For cooperation with the IC bank, these huge data to bank means to provide certain data to support marketing decisions.Banking scene to save is the product of campus Id cooperation with bank deposit business, based on students as the main body of a customer relationship management(CRM). This study focuses on campus id in the data, and bank deposit business relevant data mining, aiming at students circle stock transfer, card consumption data for effective analysis, extract implied in it, but it is potentially useful information and knowledge, the control system for the students circle up data, and through to the related departments in different stages of the data statistics, analysis, mining, make the campus of highly concentrated and all kinds of resources and information fusion, thus related decisions for the school, the bank provide powerful data support for students in all kinds of business.Set the campus Id data as analysis object, to data statistics, analysis and mining. Based on the existing campus Id function, the realization of two databases(bank deposit database, the school campus Id database) circle the deposit bank account data extraction, data and student for one cartoon, static data in the database from the students’ gender, age, grade, registered permanent residence to statistics. Deductions for one cartoon dynamic data, the net net silver-colored top-up comparison, analysis of data storage, with the student behavior characteristics of students, the user of the IC card consumption category, date of consumption, consumption amount on clustering analysis, and use the results combined with the user data to analyze related family situation of students, found that the user’s consumption habits and consumption law of potential, thus can through these data for bank loans, bank marketing operations for the work to provide data basis.The development of this system is based on.Net framework, using c # development language, Microsoft Analysis Services to establish data warehouse development. This system have the function of the database from one cartoon and bank deposit in the database data preprocessing, to extract and determine processing data is mainly the students’ basic information, student deposit information analysis and the analysis of the consumption of students information; Design data warehouse; Data mining for specific targets; Decision analysis of the mining results. In this article, the data will be issuing loans to Banks, Banks set up deposit all-in-one, provide data support other business development.