Design And Implementation Of Student Affairs Data Analysis System

As college student information database becomes larger in amount and dimension, corresponding information develops faster than ever. As an important part of student affairs management information, the campus card system contains a large number of student affairs data. Through multiple dimensions of data analysis, we would find potential problems and drawbacks within student card system, which provides important guidance and suggestion on how to improve counseling service for students. Therefore, the topic is focused on how to use information technology to analyze the student affairs data effectively and improve the efficiency of analysis.Based on student affairs data, this topic designed and implemented a student affairs data analysis system, which utilized data processing method incorporating Hadoop, Spark and Shark. The system also employed the secondary development of BIEE, associated data mining algorithm, and implemented multidimensional and efficient database processing. This paper firstly introduces the development background and the significance of student affairs data analysis system, and principles and applications of Spark and BIEE. Secondly introduces the requirement analysis, function module and framework of the system, and the design of data warehouse model of multidimensional star structure. Finally describes the implementation of the system framework, function modules, and how to use association rules algorithm based on clustering to analyze model of student affairs on Spark.By using data mining technology based on Spark, the student affairs data analysis system designed and implemented in this topic has improved the efficiency of data analysis; utilization of BIEE technology has made the system page more user-friendly. The topic finds the new system successfully meets most of the needs of the college student affairs.