基于BI的成教可视化分析系统

发布时间：2019-06-12 10:27

【摘要】：随着高校招生规模的壮大发展,教学管理信息化现已逐步在各大高校中实行实施,为高校能及时掌握综合的整体发展情况提供分析依据,并为教育机构建立良好的教育环境、引进优秀的教工和招收高素质的学生提供辅助决策[1]。教务管理系统普遍应用于学校的日常教学管理工作中,提高了各管理部门的管理效率。这些系统虽然基本满足了学校的教学需求并提供学籍管理、教务管理、成绩管理、毕业管理、考务管理等信息的查询功能,但是对系统积累的繁多的内部数据无法进行更深层次的分析,缺少灵活的和个性化的数据挖掘[2],难以发现数据背后隐藏的价值,不足以支持学校制定整体发展和建设规划的决策。商业智能[3](Business Intelligence,BI)是一个备受关注的领域,它应用于社会的各个行业中,旨在提供一个实时的、多维动态的可视化图表分析,及时发现当前业务的状况并作出预警,用“一图胜千言[4]”的形式将复杂的信息简化,帮助决策者快速理解和使用。结合商业智能技术与成教学院的办学实践,我们设计了一套成人教育教务可视化决策分析的解决方案,提供各种教务管理业务的综合分析和专题分析报告。系统的数据是基于成人教育学院正使用的教务管理系统的数据源。由于数据源的时间上跨越十几年数据库中累积了大量的数据类型不一致、记录为空、数据记录冗余等较差质量的数据。为保证系统决策平台提供有效、高价值的一致性信息展现,我们首先使用数据库管理工具对教务数据源进行数据清洗,并按决策主题的需要建立SQL联合查询视图,完成数据抽取与整合、数据转换工作,得到辅助分析的教务数据集。再运用BI[5]工具对教务数据集进行数据语义的规范和多维分析模型的建立,将多个维度视图直接关联事实视图的多维结构提升了检索效率。最后,运用OLAP技术(On-Line Analytical Processing)操作进行灵活的选取、细分、聚合数据,完成前端界面的数据可视化分析图表,包括综合校情子模块、招生毕业子模块、教师综合子模块、学生综合子模块与学业评价子模块,提供一个实时的数据获取、个性可视化、多维自助分析与钻取的决策分析模块。为校领导、管理部门领导和业务人员透过关键数据的直观分析,总结出有参考价值的信息以辅助决策的制定。
[Abstract]:With the development of enrollment scale in colleges and universities, the informatization of teaching management has been gradually implemented in colleges and universities, which provides an analytical basis for colleges and universities to grasp the comprehensive overall development in time, and provides auxiliary decision-making for educational institutions to establish a good educational environment, introduce excellent teaching staff and recruit high-quality students [1]. The educational administration management system is widely used in the daily teaching management of the school, which improves the management efficiency of each management department. Although these systems basically meet the teaching needs of the school and provide the query function of student status management, educational administration management, achievement management, graduation management, examination management and so on, they can not carry on the deeper analysis to the numerous internal data accumulated by the system, lack the flexible and individualized data mining [2], and it is difficult to find the hidden value behind the data. Not enough to support the school in making overall development and construction planning decisions. Business intelligence [3] (Business Intelligence,BI) is a field of concern, which is applied to various industries of society. It aims to provide a real-time, multi-dimensional dynamic visual chart analysis, timely discover the current business situation and make early warning, simplify the complex information in the form of "one graph is better than a thousand words [4]", and help decision makers to understand and use it quickly. Combined with business intelligence technology and the practice of running an adult education college, we design a set of solutions for visual decision analysis of educational administration in adult education, and provide comprehensive analysis and special analysis reports on all kinds of educational administration business. The data of the system is based on the data source of the educational administration management system being used by the Institute of Adult Education. Because the data source has accumulated a large number of data types inconsistency in the database for more than ten years, the records are empty, the data records are redundant and other poor quality data. In order to ensure the system decision platform to provide effective and high value consistency information display, we first use the database management tool to clean the educational administration data source, and establish the SQL joint query view according to the needs of the decision subject, complete the data extraction and integration, data conversion, and get the educational administration data set of auxiliary analysis. Then the specification of data semantics and the establishment of multidimensional analysis model of educational administration data set are carried out by using BI [5] tool, and the multi-dimensional structure of multi-dimensional view is directly related to the multi-dimensional structure of fact view, which improves the retrieval efficiency. Finally, using OLAP technology (On-Line Analytical Processing) operation for flexible selection, subdivision, aggregation of data, complete the front-end interface data visualization analysis chart, including comprehensive school situation sub-module, enrollment and graduation sub-module, teacher comprehensive sub-module, student synthesis sub-module and academic evaluation sub-module, to provide a real-time data acquisition, personality visualization, multi-dimensional self-help analysis and drilling decision analysis module. For school leaders, management leaders and business personnel through the intuitive analysis of key data, summed up valuable information to assist in decision-making.
【学位授予单位】：广西师范大学
【学位级别】：硕士
【学位授予年份】：2017
【分类号】：TP311.52

【参考文献】