The Design And Implementation Of The Data Analysis System For A Large-scale Food Enterprise

With the development of computer technology, business operation process of all walks of life becoming more complex, data becoming more various, data analysis applies in the enterprise more and more widely. Complicate decision-making needed to make a wide face information sources, and information sources scattered large amount of information, and so on, but also need to have a fast and efficient enterprise information delivery, information analysis process and to assist decision-making mechanisms, in order to adapt to market competition frequent and rapid decision-making under varying needs. It is in this business trend, the group signed with the iterative development of the project agreement, continuing to meet customer needs, and establish a comprehensive data analysis system for business leaders to view status of business operations and make decisions for enterprise development.The data analysis system focuses on complex business systems business, financial, investment reports, food policy, human resources data management system. Firstly, we need collect and integrate these data and make ETL processing and analytical modeling of these data.In java programming language combining hierarchical development and integrated front-end report development tools, data required in the user page sub-themes for data analysis. Project team has now completed the second phase of iterative development of the system, has completed a comprehensive exhibition, assessment indicators analysis, business analysis, financial analysis, financial analysis, auxiliary estimates, early warning platform, competitive analysis and analysis of human resource analysis of nine topics Analysis of implementation. Each topic, for different projects, we show it in different analytical analysis. Cognos reporting tools provide a variety of chart styles. There are bar charts, line charts, pie charts, radar, multi-family histogram, stacked histogram, Combination, speedometer, bubbling, waterfall and so on. And in accordance with the functional design requirements for these charts add click event, the chart can be hyperlinked penetration of TAB pages, joint investigation, radio, multiple choice, to sort the data and so on. The system user can also set up their own home, the collection of personal favorite theme, the use of the platform for the analysis of news topics for discussion, setting the system time to ensure the system is simple to operate, with good interaction. The system will be multi-layered software architecture combines with the MVC design pattern, making the system has good scalability.Early in the project development team were well prepared for work. In this process, we mainly write for the specification, tests and a variety of technical solutions, and have completed the preparation of the project for use in a variety of specifications, the establishment of these specification documents makes evidence-based data center construction. In the project development process, we have completed a data warehouse design, data model design, data extraction and filling, and completed the business management information system data analysis. The data model design has establish a book inventory model, profit model, more than ten data model, covering the carrying amount, the actual rotation, quality indicators and other business assets and liabilities, profits, cash flow and other financial data and completed the development of a comprehensive exhibition, the key assessment criteria set features nine themes. After completion of the online system development line used within the enterprise, the system has been recognized by everyone, and has showed the effective leadership of the enterprise information analysis provides decision support. And the system performance proves to be good. Customers are very satisfied.