Research And Application Of Report Generation Method Of Big Data Statistical Analysis Based On Template

With the continuous advancement of informatization,enterprise information systems have accumulated a large amount of data after long-term application practice.Data is the core of an enterprise.It affects the industry's competitiveness and future development.The report is an important carrier of enterprise management data.Decision-makers can be provided with a clear,intuitive and powerful basis from analyzing a large amount of historical data of the enterprise,digging out valuable information from it,and presenting it in the report in a graphic manner.At present,most enterprise reporting systems are customized according to requirements.The data in the report and the format are highly coupled,the unformatted data is meaningless.If you need to modify or generate a new report,you can only re-code it for secondary development,which seriously affects the flexibility and versatility of the reporting system and cannot meet the dynamic needs of the enterprise.In addition,the data sources in enterprises are often different,and data islands are common.Most reporting systems do not support the analysis of heterogeneous data,and the value of data cannot be well tappedIn view of the problems in the current enterprise reporting system,this paper designs and proposes a template-based statistical report generation method,and codes to implement a big data reporting system according to this method.The main contents of this article include(1)Providing a uniform acquisition interface for heterogeneous data,and used data warehouse technology to integrate the acquired data to provide a data basis for the report.(2)Designing a reusable XML report template.The report template is composed of a data template and a format template,which means the separation of data and format has been realized,making the report data no longer depends on the format.Both templates use visual design to improve the ease of use of the system.The format template design interface adopts Excel-like style,which is suitable for the development of Chinese reports and reports with complex formats.The report template greatly increases the versatility and flexibility of the reporting system(3)Realizing the corresponding report generator,analyzing the meaning of the report template via the report generator and generating a complete report.Due to the existence of dynamic data in the template,the template will expand dynamically when the report is generated,making the report generation dynamic,uncertain and complex.In this regard,the report generator provides a data filling method to automatically fill the data into the report according to certain rules.(4)Designing and coding a Web reporting system,the system uses Hadoop technology to integrate data from different data sources,and statistically analyze massive data through Hive and Impala big data analysis tools,which greatly improves the efficiency of data statistical analysis.Finally,the report system is integrated into the practical application of the Zhaoqing College project cooperated by the laboratory,and the function interface of the report system is displayed and tested to verify the feasibility of the template-based statistical report generation method.