Design And Implementation Of Reporting System For Financial Supervision Data

At present,the report product market at home and abroad is in the ascendant,and various report tools will have broader development prospects with the expansion of enterprise business and the rise of e-commerce.However,with the continuous opening of the financial market,in addition to the establishment of various private banks and foreign banks,Internet finance led by ant financial services is also developing vigorously,These financial institutions produce huge data every day,which makes the traditional commercial reporting software unable to meet the analysis needs of financial regulatory institutions such as the people's Bank of China.For a long time,a central branch of the people's Bank of China,as a macro-control department that supervises and manages the financial industry,has accumulated a large amount of financial supervision data.However,there are two main problems in the construction of the existing report business system of the central sub branch: first,the data reporting,collection and processing rely on manual input and manual screening by staff,the data timeliness is poor,and the data quality cannot be guaranteed.Second,the financial supervision department of the central sub branch has the problems of long report preparation cycle and incomplete reflection of supervision indicators.In view of the above problems,combined with the analysis requirements of the central sub branch for financial supervision data,this paper aims to use data warehouse and data visualization technology to establish an enterprise level unified data integration and reporting platform,adopt advanced data architecture and establish a scientific financial data model.In order to design and implement the financial report system,this paper mainly does three aspects:First,system requirements analysis and overall design.According to the current problems faced by a central branch of the people's Bank of China and the needs of financial supervision business,the data integration requirements,data warehouse requirements,report visualization requirements,subject analysis requirements and authority management requirements of the report system for financial supervision data are confirmed.On the basis of system requirements analysis,the overall design of each functional module of the report system is carried out,and the design process is described in combination with use case diagram and functional structure diagram.Effectively open up the data gap between various business systems and form a unified data sharing center.The second is the specific implementation of each functional module of the system.The project adopts B/S architecture and integrates multi-source heterogeneous data through kettle as ETL tool;Based on the hierarchical design of data warehouse and data quality management,the star model of data warehouse is realized by using dimension modeling technology;Rendering the front-end chart of the report module based on Vue and echarts;On this basis,it realizes the visual display of investigation and statistics theme analysis and currency gold and silver theme analysis,and effectively improves the comprehensiveness of financial supervision data analysis.The third is system testing.In order to verify whether the report system can meet the actual needs of the central branch,the functional test and non functional test are carried out on the system.The non functional test is to simulate the performance bottleneck that the system may encounter through technical means to verify whether all indicators meet the needs of users.At present,the system has been successfully put into operation,which effectively saves the human cost for the central sub branch,improves the report submission and decision-making efficiency,and has reference significance for the construction of report system in financial supervision data analysis.