Graduate Employment Information System For Intelligence Analysis

College graduates meets the needs of society can be achieved smoothly, whether it can find suitable for their professionalism and expertise to the work, whether there is a comprehensive quality and working with ability to quickly adapt to the needs of jobs is China's colleges and universities have faced the an important issue. Numerous colleges and universities are using information technology to improve management level, both within its campus employment information management system, student management information systems. After a long run these systems, which has accumulated a lot of raw data, but because there is no management of data mining concept, the system only through the use of a simple sorting, statistics, preservation and collection of data, and a deeper hidden in these data level of information is not be exploited further. The data warehouse technology into the management of university student employment information, employment information and data on students in-depth analysis of the school leadership to provide decision support is an urgent need to resolve the issue.This utilization data warehouse concepts and OLAP technology, Beijing Industrial Vocational and Technical College employment information management system has accumulated a large number of employment-related raw data from multiple perspectives, multiple dimensions of analysis, from which excavated the promotion of employment of college students law. Graduate Employment information intelligence analysis system, through the Microsoft SQL Server2000 building data warehouse through data extraction, cleaning, conversion operation, then use the Analysis Servers provided in the OLAP analysis capabilities, through the rotation, slicing, drilling and other technical analysis of multidimensional data model, from which was found to promote the law of employment of university students for college administrators to provide reliable data basis.Around the completion of the above main tasks of this article include:in-depth study of data warehousing and master the characteristics of data warehouse, data warehouse architecture, data warehouse implementation strategy and the establishment of data warehouse steps; studied a variety of OLAP technology and OLAP implementation method. Mastered the necessary knowledge, based on the decision-making needs to establish a "student" and "employment" as its theme the data warehouse multidimensional data model; in building a successful multi-dimensional data sets, the use of OLAP technology to analyze the results of multi-dimensional data displayed on the client side. Through the establishment of models, of which data analysis, in order to better analysis of the image data results, using Excel analysis of data, analyze data in order to be pie charts, histograms, graphs and so on.