Data analysis self-help data fetching method and system based on indexes

Abstract

The invention relates to the technical field of data analysis, and in particular relates to a data analysis self-help data fetching method and system based on indexes. The data analysis self-help data fetching method comprises the following steps: firstly, defining a business index, needing to be used for analyzing and inquiring, through a standard index defining method, and generating index result data; forming a basic data source of self-help data fetching by an index data result; providing various types of defined indexes and dimension information capable of being used for analyzing the indexes on a user data fetching interface; after freely selecting and configuring the needed indexes and inquiring dimension by a user, constructing a data inquiring sentence by the system through an SQL (Structured Query Language) configuration device according to an index and dimension selecting condition of the user; operating and generating a final data result and displaying to the user. The data analysis self-help data fetching method and system based on the indexes have the beneficial effects that free combination of data content and a displaying structure is realized, and a more convenient and flexible data multi-dimensional analysis means is provided for data analysis of the user.

Description

technical field [0001] The invention relates to the technical field of data analysis, in particular to an index-based data analysis self-retrieving method and system. Background technique [0002] With the continuous development of enterprise informatization, data analysis has occupied an important position in various enterprises. The analysis of various production, operation, asset and other data in the enterprise can help users observe the state of the enterprise from multiple dimensions. Understand the changes of the enterprise and guide the business decision-making of the enterprise. [0003] Most enterprises will conduct business data analysis and data acquisition by establishing various business analysis systems. Generally speaking, the system provides users with prefabricated business analysis results through presentation forms such as reports or charts. However, different periods, different positions, and different personnel have different requirements for business...

AI Technical Summary

Problems solved by technology

However, different periods, different positions, and different personnel have different requirements for business analysis content. Users always hope that the system can obtain the results they want in the system. Business analysis to meet the needs of users, which increases the cost of development and maintenance, and makes the system increasingly bloated and difficult to use

[0004] In addition, if the various statistical indicators in the system do not have a unified data caliber constraint, statistical data results will be inconsistent to a large extent, which will seriously affect the accuracy of data quality and increase the system maintenance caused by data comparison. cost

Images