Finance big data center-Analytical applicationsThe integration of financial information constructi

Finance big data center
-Analytical applications
The integration of financial information construction focuses on the entire process of financial revenue and expenditure management, and on the basis of fully sorting out business, constructs two major data resource pools of internal and external finance, forming a true financial data warehouse. By utilizing the data center and constructing a data analysis algorithm model, statistical analysis, monitoring and early warning are carried out according to a certain caliber, and a big data support system is established with fiscal revenue and expenditure, predictive decision-making, theme display, and other main contents.
1 Analysis application
Financial endogenous data analysis is based on the perspective of analyzing internal financial data, from macro to micro levels, with the main analysis framework being the income and expenditure lines. Conduct a comprehensive analysis from the perspective of finance, fully considering the needs of vertical supervision and horizontal management of finance and regulatory departments. Extract data from core business systems such as indicators, plans, payments, taxes, non taxes, budgets, and final accounts, standardize data through data cleaning, conversion, and loading, and form an analysis theme library according to the needs of financial endogenous data analysis. Realize statistical analysis of financial data, and flexibly customize various query conditions to query the required business data analysis. The automatic flow of data across systems has been achieved, greatly improving the sharing, accuracy, timeliness, and scientificity of data processing. This enables the finance department to comprehensively and effectively monitor the situation of the finance department and all regions under its jurisdiction, and provides a basis for future annual budget preparation, improving management and decision-making levels. At the same time, in order to meet the needs of business changes, after data governance, the functions proposed in this article can be freely customized through various visualization methods such as pie charts, bar charts, line charts, scatter plots, heat maps, radar charts, etc., to meet the functional needs of users.
1.1 Financial Situation Analysis
Assist users in controlling financial dynamic data from three aspects of revenue and expenditure surplus, and analyze the composition of financial resources from three levels of bank deposits, accounting books, and budget in terms of financial fund surplus.
1.1.1 Application level
Provincial level centralized, hierarchical authorization query
1.1.2 Using departments and units
Data collection, data maintenance, modeling, data analysis and utilization
Treasury Department
Information Department ●
Budget Department ●
People's Bank of China ●
1.1.3 Dynamic analysis of general public budget revenue
1.1.3.1 Business Description
By analyzing the general public budget revenue overview, general public budget revenue trend, regional ranking of general public budget revenue, general public budget revenue structure ranking, and analysis of the proportion of general public budget revenue composition by administrative division, financial users can have a comprehensive understanding of the general public budget revenue situation in the local area. To provide a basis for judging the stability of general public budget revenue.
1.1.3.2 Detailed Business Description
Overview of General Public Budget Revenue: By summarizing the cumulative amount, current year's budget amount, budget completion rate, revenue amount for the same period, and year-on-year increase or decrease rate, provide an overall description of the general public budget revenue in a certain region, providing a visual understanding of the general public budget revenue situation in the region for the finance department.
Monthly trend analysis of general public budget revenue: By comparing the completed amount of general public budget revenue per month with the corresponding monthly revenue budget, it helps the finance department determine the difficulty of general public budget revenue in a certain period of time in the future, and provides reference for the next step of implementing fiscal revenue measures.
Trend analysis of general public budget revenue in the past 10 days: Click on this month's node to view the revenue trend of the past 10 days of the month and compare it with the progress trend of the budget sequence. This provides a more detailed and intuitive understanding of the difficulty of completing the general public budget revenue budget for the current year, allowing the finance department to have a clear understanding of the budget completion status.
Regional ranking analysis of general public budget revenue: By analyzing the ranking of general public budget revenue in each district under its jurisdiction, and based on the comprehensive ranking analysis of the cumulative completed amount, budget completion rate, and growth rate of general public budget revenue in each region under its jurisdiction, financial users can clearly grasp the main factors affecting the growth of general public budget revenue and identify potential hidden danger areas that may affect the stability of general public budget revenue in the future. Finance can provide guidance on the next steps of general public budget revenue work based on the analysis results. And you can further drill down to view the corresponding general public budget revenue budget, monthly completion, and cumulative completion details for each region.
Ranking analysis of general public budget revenue structure: Through ranking analysis of general public budget revenue structure, comprehensive ranking analysis is conducted based on the cumulative completion amount, budget completion rate, and growth rate of subjects, so that financial users can clearly grasp the main factors affecting the growth of general public budget revenue and identify potential hidden factors that may affect the stability of general public budget revenue in the future. Finance can provide guidance on the next steps of general public budget revenue work based on the analysis results. And you can further drill down to view the corresponding general public budget revenue budget, monthly completion, and cumulative completion status details for each subject.
Analysis of the proportion of general public budget revenue composition: Master the proportion of national tax, local tax, and non tax revenue composition as of the previous day, and real-time grasp the proportion of non tax revenue to general public budget revenue. If the proportion exceeds 20%, it indicates that the quality of revenue needs to be improved. And further drilling can be conducted to view the details of the completion and cumulative completion of the corresponding regional and collection authorities for this month.
1.1.4 Dynamic analysis of government fund budget revenue
1.1.4.1 Business Description
By analyzing the overview of government fund budget revenue, trend of government fund budget revenue, regional ranking of government fund budget revenue, structure ranking of government fund budget revenue, and proportion analysis of government fund budget revenue by administrative division, financial users can have a comprehensive understanding of the local government fund budget revenue situation. To provide a basis for judging the stability of government fund budget revenue.
1.1.4.2 Detailed Business Description
Overview of Government Fund Budget Revenue: By analyzing the cumulative amount, current budget amount, budget completion rate, revenue amount during the same period, and year-on-year increase or decrease rate, this provides an overall description of the government fund budget revenue in a certain region, providing a visual understanding of the overall government fund budget revenue situation in the region.
Monthly trend analysis of government fund budget revenue: By comparing and analyzing the completed amount of government fund budget revenue per month with the corresponding monthly revenue budget, it helps the finance department determine the difficulty of government fund budget revenue in a certain period of time in the future, and provides reference for the next step of implementing fiscal revenue measures.
Analysis of the Trend of Government Fund Budget Revenue in the Past 10 Days: Click on this month's node to view the revenue trend of the past 10 days of the month and compare it with the progress trend of the budget timeline. This will provide a more detailed and intuitive understanding of the difficulty of completing the government fund budget revenue budget for the current year, allowing the finance department to have a clear understanding of the budget completion situation.
Regional ranking analysis of government fund budget revenue: By analyzing the ranking of government fund budget revenue in each district under its jurisdiction, and based on the comprehensive ranking analysis of the cumulative completed amount, budget completion rate, and growth rate of government fund budget revenue in each region under its jurisdiction, financial users can clearly grasp the main factors affecting the growth of government fund budget revenue and identify potential hidden danger areas that may affect the stability of government fund budget revenue in the future. Finance can provide guidance on the next step of government fund budget revenue work based on the analysis results. And you can further drill down to view the corresponding regional government fund budget revenue budget, monthly completion and cumulative completion status details.
Ranking analysis of government fund budget revenue structure: By analyzing the ranking of government fund budget revenue structure, a comprehensive ranking analysis is conducted based on the cumulative completion amount, budget completion rate, and growth rate of subjects, so that financial users can clearly grasp the main factors affecting the growth of government fund budget revenue and identify potential hidden factors that may affect the stability of government fund budget revenue in the future. Finance can provide guidance on the next step of government fund budget revenue work based on the analysis results. And you can further drill down to view the corresponding government fund budget revenue budget for each subject, as well as the detailed completion and cumulative completion status for this month.
1.1.5 Dynamic analysis of vault inventory
1.1.5.1 Business Description
Analyze the treasury inventory at all levels based on the daily report data provided by the People's Bank of China. Understand and grasp the inventory situation of the vault, and provide data reference for judging the rationality and safety of the vault inventory.
1.1.5.2 Detailed Business Description
Recent trend analysis of treasury cash: visually display the daily trend of treasury inventory changes, and judge the rationality of the current treasury balance based on the optimal range of treasury funds. Thus inferring the rationality of fiscal revenue and expenditure measures.
Treasury cash inventory warning analysis: By analyzing the average, low, and peak inventory of the current year, reflecting the rationality of current treasury management, and comparing it with the safe treasury balance, the risk level of treasury management can be inferred, and the income and expenditure situation of historical low and peak values can be viewed by drilling down, providing analytical reference for avoiding treasury risk in the future.
Overview analysis of the cash balance of the national treasury: Through statistical analysis of the balance of the current day's treasury, the balance of the beginning of the month's treasury, the amount received this month, and the amount disbursed this month, the current treasury situation is visually displayed. By analyzing the increment and increase of warehouse funds, we can determine the rationality of the appreciation of outbound payments, and thus help infer whether there is a hidden danger of slow expenditure progress from a certain level.
1.2 Comprehensive analysis of income and expenditure
By comprehensively utilizing budget indicator data, departmental budget data, fiscal revenue data, fiscal expenditure data, and basic information of budget units, a comprehensive analysis of fiscal revenue and expenditure data is conducted to provide a basis for strengthening revenue and expenditure management.
1.2.1 Application level
Provincial level centralized, hierarchical authorization query
1.2.2 Using departments and units
Data collection, data maintenance, modeling, data analysis and utilization
Information Department ●
Treasury Department
Budget Department
City and County Treasury Department ●
City and County Budget Department ●
1.2.3 Overview of income and expenditure
1.2.3.1 Business Description
The revenue and expenditure overview is a comprehensive reflection of the financial revenue and expenditure situation at all levels. It can be divided into four budgets (i.e. general public budget, government fund budget, state-owned capital operation budget, social insurance fund budget) to view the cumulative revenue and expenditure completion amount, cumulative expenditure amount, annual revenue budget, annual expenditure budget, cumulative revenue and expenditure execution progress of each region, and to provide a comprehensive and intuitive understanding of the annual revenue and expenditure situation.
1.2.3.2 Detailed Business Description
Analysis of total fiscal revenue and expenditure: Statistics and analysis of the cumulative completed amount of total fiscal revenue, revenue budget, year-on-year increase and decrease, revenue completion progress, total fiscal expenditure cumulative expenditure, expenditure budget, year-on-year increase and decrease, and expenditure completion progress, enabling the finance department to intuitively understand the overall situation of current total revenue and total expenditure.
General Public Budget Revenue and Expenditure Analysis: Statistical analysis of the cumulative completed amount of general public budget revenue, revenue budget amount, year-on-year increase/decrease amplitude, revenue completion progress, cumulative expenditure amount of general public budget expenditure, expenditure budget amount, year-on-year increase/decrease amplitude, and expenditure completion progress, enabling finance to intuitively understand the overall situation of current general public budget revenue and general public budget expenditure.
Analysis of government fund budget revenue and expenditure: Conduct statistical analysis on the cumulative completed amount of government fund budget revenue, revenue budget amount, year-on-year increase/decrease amplitude, revenue completion progress, cumulative expenditure amount of government fund budget, expenditure budget amount, year-on-year increase/decrease amplitude, and expenditure completion progress, so that the finance department can intuitively understand the overall situation of current government fund budget revenue and government fund budget expenditure.
Analysis of revenue and expenditure of state-owned capital operation budget: Statistics and analysis of the cumulative completed amount of revenue budget, revenue budget, year-on-year increase and decrease, revenue completion progress, cumulative expenditure, expenditure budget, year-on-year increase and decrease, and expenditure completion progress of state-owned capital operation budget, enabling finance to intuitively understand the overall situation of current state-owned capital operation budget revenue and state-owned capital operation budget expenditure.
Analysis of social security fund budget revenue and expenditure: Analyze the cumulative completed amount of social security fund budget revenue, revenue budget amount, year-on-year increase/decrease amplitude, revenue completion progress, as well as the cumulative expenditure amount, expenditure budget amount, year-on-year increase/decrease amplitude, and expenditure completion progress of the fiscal social security fund budget, so that the fiscal department can intuitively understand the overall situation of the current social security fund budget revenue and social security fund budget expenditure.
Multi year revenue and expenditure trend analysis: Analyzing historical multi year revenue and expenditure trends can to some extent reflect the local economic vitality, and has guiding significance for the government to adjust economic policies in the next step.
Income correlation analysis: By comparing and analyzing the relationship between the total fiscal revenue and the long-term changes in the four budget revenue, it helps the government discover the correlation and impact relationship (positive or negative) between the total fiscal revenue and a certain item of revenue, thereby playing an enlightening role in finding the focus of revenue growth for the government.
Income and expenditure difference analysis: By analyzing the difference between total fiscal revenue and total expenditure, the goal of measuring the balance of fiscal revenue and expenditure is achieved.
1.2.4 Analysis of fiscal revenue progress
1.2.4.1 Business Description
By analyzing the progress of fiscal revenue, all levels of finance can timely understand the degree of budget completion of fiscal revenue and evaluate the rationality of fiscal revenue progress, identify the main factors affecting fiscal revenue progress, and provide guidance for taking further fiscal measures.
1.2.4.2 Detailed Business Description
Overview analysis of fiscal revenue progress: Statistically display the progress of fiscal revenue at the local level and within its jurisdiction. The fiscal department understands the overall progress of fiscal revenue for the four major budgets in the local area based on cumulative revenue, annual budget, budget completion rate, same period last year, and year-on-year increase and decrease.
Analysis of changes in fiscal revenue progress: By continuously monitoring and comparing the actual progress of multi month revenue budgets with the chronological progress, it is convenient for the government to timely identify potential risks of lag in revenue budget progress (if the actual progress is lower than the chronological progress for three consecutive months, there may be a hidden danger of serious lag in progress in the coming months), providing guidance for early measures to be taken.
Analysis of changes in fiscal revenue growth rate: By comparing the year-on-year growth rate of the current year and the previous year's monthly growth rate of the four local fiscal revenue, it is found that there may be risks in fiscal revenue, and it is suggested that the government should take timely measures to increase revenue.
Ranking analysis of regional increase in fiscal revenue: By analyzing the ranking of regional revenue under its jurisdiction, it helps the government identify the main regions that affect or slow down the growth of regional fiscal revenue, providing reference for the government to take measures in the next step.
Ranking analysis of fiscal revenue subject growth: By analyzing the subject revenue ranking, it helps the government identify the factors that affect the growth or slowdown of fiscal revenue, and provides a drill down analysis to further examine the fundamental problems caused. Facilitate the formulation of further revenue measures by the government.
Income sub account progress analysis: By ranking the progress of accounts, identify the main and fundamental reasons that affect income progress.
1.2.5 Analysis of fiscal expenditure progress
1.2.5.1 Business Description
By analyzing the progress of fiscal expenditure, the government can timely understand the degree of budget completion of fiscal expenditure and evaluate the rationality of fiscal expenditure progress, identify the main factors affecting fiscal expenditure progress, and provide guidance for collecting further fiscal measures.
1.2.5.2 Interface requirements
Overview analysis of fiscal expenditure progress: Statistically display the progress of fiscal expenditure at the local level and within its jurisdiction. The fiscal department understands the overall progress of fiscal expenditure in the four main budgets of the region based on cumulative expenditure, annual budget, budget completion rate, same period last year, and year-on-year increase and decrease.
Analysis of changes in fiscal expenditure progress: through multiple analysis