The key points and value of the unified data analysis platform for agricultural firms

According to IDC, human-generated data is growing exponentially, doubling about every two years. The information processing ability is one of the core competitiveness of the agricultural firm, if it can introduce the idea and technology of big data, it will improve the informationization to the level, and improve the efficiency of data analysis and business decision. However, the sail soft legend found that as an important part of the banking industry, big Data application lags behind, this is mainly because of the early information construction of agricultural firms on the application of data to the lack of consideration.

As a whole, the application of informatization in agricultural firms has the following problems:

Agricultural firms generally exist in a number of systems, such as performance, supervision, and many of these systems are built by different manufacturers, data format, report style and analysis of latitude are not the same. The business unit habitually enters the business system to carry on the report view and the analysis, even if deploys the unified report platform, the style also is difficult to adapt, simultaneously with the time passes, because the multi-system view data, will cause the statistical caliber is not unified, the calibration data is very difficult. and decision-making because the front-end analysis scattered in each system, unable to effectively summarize the analysis, the value of data participation decisions is difficult to play out.

Second, the agricultural firm's report demand changes very much, these report demand generally comes from the business development brings the new report demand, the agriculture firm leader pays attention to the statement demand, the business personnel's temporary demand and the report statistic caliber change multi-demand. Although the department worked hard to stay up late, these needs were not answered in time. Demand can not be timely response, but also cause decision-making can not be timely to view the information concerned, it is necessary to carry out two analysis of the data, increase the difficulty of decision. And business departments often have to adjust their own two times to make statements, difficult, repetitive labor, response to decision-making needs slow. Both the business unit and the branch office were very miserable.

Thirdly, the problem of statistical caliber is very obvious. The report of the system is usually developed from the point of view of the Provincial association, to statistics credit, supervision and other data, but can not sink to the local network, local lines and subordinate lines if there is demand, such as statistical caliber adjustment, in-line personalization needs, activity situation, the subordinate row data extraction requirements, it is difficult to be satisfied. This further increased the pressure of the Department of Credit.

In order to solve these problems, many farmers are also aware of the online unified data analysis platform to achieve data analysis diversification, multidimensional, in order to provide strong data support in customer analysis, channel analysis, risk analysis, marketing analysis, but after all, do not know how to build, build into what kind of unified data analysis platform. Here, the soft legend of the elder brother has been involved in the Copper Mountain Farm Unified Report Analysis platform, Xinyi agricultural firm All-Bank report platform and Xinchang Farm loan platform and other projects, summarize the agricultural firm's unified data analysis platform for the construction of the main points and display.

First of all, the definition of a unified data analysis platform for agricultural firms, which is based on the information background of agricultural firms, puts forward five aspects:

First, facing the leadership: a full range of data display, can support their convenient and accurate decision-making;

Second, business-oriented: report changes without repeated manual processing, can quickly respond to their business needs;

Third, the letter to the Department: to provide maintenance tools to reduce the development of the volume, improve response speed;

Four, data-oriented: the construction of Data Warehouse, the data processing as the core, the unified database caliber;

Five, query-oriented: Front-end reports can be embedded in the system in advance, the latter is gradually unified.

Secondly, the paper clarifies the functional structure and functional requirements of the unified data analysis platform of agricultural firms.

First, the structure requirements:

1, leadership decision-making analysis: In line with the overall business objectives and management of the situation, set the agricultural firm multi-system data integration, reporting center, Analysis Center, control center in one of the omni-directional business intelligence solutions. Flexibly and quickly respond to changes in financial industry management, to build a set of perfect auxiliary decision-making analysis system for agricultural firms. Such as: Expected interest income analysis, customer relationship analysis, business objectives analysis, key source analysis and so on.

2, Business Custom report: In order to meet the People's bank, the CBRC, Provincial Association and other regulatory departments to provide management analysis of the report. belongs to the custom class report.

3, custom flexible query: Line leaders, management departments, business lines, grass-roots line leaders, field supervisors, host accounting and so on according to their own management needs to customize the query criteria query source and other statistical reports. such as: deposit and loan situation, customer information situation, card trading situation.

4, mobile query: For each business unit and line leader to provide mobile view, effective use of debris time.

Second, functional requirements:

1, the bottom data acquisition: Support the province issued operating data and local database data;

2, Management report query: Support business management, electronic banking, credit category, Financial accounting category analysis and inquiry;

3, custom front-end analysis: The bottom of each business unit build, clear the operational role of the front-end analysis, support the front-end free analysis (data drilling, graph linkage, drag analysis, retrospective analysis, etc.)

4, cross-platform search view: Support pc-side, handheld pad, mobile iOS, mobile Android;

5, unified Platform Management and maintenance: You can quickly add, adjust, assign reports and data analysis, you can flexibly assign data permissions and report permissions.

Finally, the development tool is selected. We can see from the above requirements, the tool must meet the multi-data source association, the production of Chinese-style complex report, self-service report, mobile and portal These functions, legend Brother Contact project is using finereport+Finebi combination put up to solve, of course, there are many other reporting tools, we can choose according to their own conditions.

Well, to the best of the article, we will summarize the farm business unified data Analysis platform value, there are five main aspects.

One, the various statistical statements to solve the problem: the various business reports to the leadership, departments for the basic use of objects to meet the agricultural credit second generation business system trading information as the basis for data sources, based on the agricultural credit Transaction statistics, business analysis, management-oriented to build goals. From the agricultural credit core business deposits, loans, electronic banking, intermediary business, credit card, non-performing loans, business analysis and management of seven aspects, to achieve a series of statistical analysis functions.

Second, the leadership decision-making analysis: Make full use of the Data Warehouse platform construction results and platform flexibility, to establish a comprehensive, convenient, intuitive operation, finance, performance, risk, supervision and integration of the display platform, through historical trend analysis, branch vertical comparison, the organization of horizontal comparison model analysis of the various business situation;

Third, the Business custom class report. Mainly for the report format changes fixed, the content of more than the processing of the report, and business personnel can not be prepared by themselves, relatively complex, need to develop related program Class report-based. Data is stored by day processing. According to the actual department classification, electronic banking, accounting, credit, risk control and so on. Can be displayed in a custom graphical format. such as: 2D and 3D pie chart, histogram, linear chart, bubble plot, scatter, funnel, pyramid and cone chart, such as graphic display.

Iv. Customizing the query report. Custom query mainly for the relevant business personnel according to their own analysis needs can customize the query report and share; Data is stored by day processing. Ability to quickly generate reports in a timely manner in the form of reports. Can be displayed in a custom graphical format. such as: 2D and 3D pie chart, histogram, linear chart, bubble plot, scatter, funnel, pyramid and cone chart, such as graphic display. Easy to find, no technician intervention required.

V. Mobile applications. Lead out of the communication, can real-time view of the business analysis of the situation, can be a quick review of the results of the display, the mode to send the results; device binding mechanism, to avoid the loss of mobile phones and other circumstances resulting in in-line data leakage, support QR code scanning server mode, convenient mobile phone-side quick configuration query.

[Article original Sail soft legend brother, No.: Frbiaoge. ］

The key points and value of the unified data analysis platform for agricultural firms