CN107818177B - Business intelligent model building method and building device - Google Patents
Business intelligent model building method and building device Download PDFInfo
- Publication number
- CN107818177B CN107818177B CN201711181236.XA CN201711181236A CN107818177B CN 107818177 B CN107818177 B CN 107818177B CN 201711181236 A CN201711181236 A CN 201711181236A CN 107818177 B CN107818177 B CN 107818177B
- Authority
- CN
- China
- Prior art keywords
- data
- model
- data table
- business
- processed
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 39
- 238000004458 analytical method Methods 0.000 claims abstract description 143
- 238000012545 processing Methods 0.000 claims description 31
- 238000013075 data extraction Methods 0.000 claims description 11
- 238000006243 chemical reaction Methods 0.000 claims description 8
- 238000013499 data model Methods 0.000 claims description 2
- 238000012163 sequencing technique Methods 0.000 claims 1
- 230000008520 organization Effects 0.000 description 25
- 230000008569 process Effects 0.000 description 16
- 238000004891 communication Methods 0.000 description 10
- 239000000284 extract Substances 0.000 description 6
- 238000010586 diagram Methods 0.000 description 4
- 230000007246 mechanism Effects 0.000 description 4
- 230000009471 action Effects 0.000 description 3
- 238000011161 development Methods 0.000 description 2
- 230000010354 integration Effects 0.000 description 2
- 230000004083 survival effect Effects 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2465—Query processing support for facilitating data mining operations in structured databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/067—Enterprise or organisation modelling
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Strategic Management (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Economics (AREA)
- Entrepreneurship & Innovation (AREA)
- General Physics & Mathematics (AREA)
- Tourism & Hospitality (AREA)
- Development Economics (AREA)
- Operations Research (AREA)
- Marketing (AREA)
- General Business, Economics & Management (AREA)
- Game Theory and Decision Science (AREA)
- Educational Administration (AREA)
- Quality & Reliability (AREA)
- Fuzzy Systems (AREA)
- Mathematical Physics (AREA)
- Probability & Statistics with Applications (AREA)
- Software Systems (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides a business intelligent model building method and a building device, comprising the following steps: at least two service data are acquired in advance; receiving at least one business intelligence BI analysis theme corresponding to-be-processed data input by a service worker; creating a model data table based on the received at least one BI analysis topic; for each BI analysis topic in the at least one BI analysis topic, extracting the to-be-processed business data corresponding to the BI analysis topic from the obtained at least two business data; loading the extracted service data to be processed into the model data table; and building a BI model according to the model data table loaded with the service data to be processed. The scheme can improve the building speed of the BI model.
Description
Technical Field
The invention relates to the technical field of network communication, in particular to a business intelligent model building method and a business intelligent model building device.
Background
With the advent of the big data age, business data plays a crucial role in the survival and development of enterprises. How to find useful information from business data of enterprises has become a major concern of each enterprise.
At present, when a Business person builds a Business Intelligence (BI) model according to Business data, the Business person needs to collect the Business data and process the collected Business data, and in the process of collecting and processing the data, the Business person needs to communicate with technicians in a complicated way.
As can be seen from the above description, the tedious interaction between the service personnel and the technician during the collection and processing of the service data consumes a lot of time, which results in slow collection and processing speed of the service data, and thus slow BI model building speed for the service personnel.
Disclosure of Invention
The embodiment of the invention provides a business intelligent model building method and a business intelligent model building device, which can improve the building speed of a BI model.
In a first aspect, an embodiment of the present invention provides a method for building a business intelligent model, including:
at least two service data are acquired in advance;
receiving at least one BI analysis subject corresponding to the data to be processed input by the service personnel;
creating a model data table based on the received at least one BI analysis topic;
for each BI analysis topic in the at least one BI analysis topic, extracting the to-be-processed business data corresponding to the BI analysis topic from the obtained at least two business data;
loading the extracted service data to be processed into the model data table;
and building a BI model according to the model data table loaded with the service data to be processed.
Preferably, the creating a model data table based on the at least one BI analysis topic comprises:
ranking each of the received at least one BI analysis topic;
generating a model data table according to the position of the sequenced BI analysis topics, wherein each BI analysis topic in the model data table corresponds to one row or one column of the model data table;
the loading the extracted service data to be processed into the model data table includes:
and aiming at each BI analysis topic in the model data table, extracting the business data to be processed corresponding to the BI analysis topic into a row or a column of the BI analysis topic corresponding to the model data table.
Preferably, after the loading the extracted to-be-processed business data into the model data table, before the analyzing and extracting to the model data table of the to-be-processed business data, further comprising:
displaying the model data table loaded with the to-be-processed business data to the business personnel;
acquiring a data summarizing mode and a chart type input by the service personnel according to the displayed model data table loaded with the service data to be processed;
and constructing a BI model according to the model data table loaded with the to-be-processed service data, wherein the BI model comprises the following steps:
summarizing the business data to be processed of different BI analysis topics in the model data table according to the acquired data summarizing mode;
and building a BI model according to the summarized service data to be processed and the obtained chart type, wherein the BI model comprises a report and/or a graph.
Preferably, before the pre-acquiring at least two service data, the method further includes:
determining at least one business system;
the pre-acquiring at least two service data includes:
for each business system, extracting at least two business data from the business system according to a preset data extraction range;
converting the data format of each service data according to a preset conversion format;
loading the business data with the converted data format into a preset data warehouse;
the extracting the to-be-processed service data corresponding to the BI analysis topic from the at least two types of acquired service data includes:
and extracting the business data to be processed corresponding to the BI analysis topic from the data warehouse.
Preferably, before the receiving at least one BI analysis topic corresponding to the to-be-processed business data input by the business personnel, the method further includes:
creating at least one sample model data table;
after receiving at least one BI analysis topic corresponding to the to-be-processed data input by the service personnel, before creating a model data table according to the received at least one BI analysis topic, the method further includes:
determining whether a model data table corresponding to the BI analysis topic exists in the created at least one sample model data table;
when there is no model data table corresponding to the BI analysis topic, performing the creation of the model data table according to the attributes in each of the sample model data tables and the received at least one BI analysis topic.
In a second aspect, an embodiment of the present invention provides a data model building apparatus, including:
an obtaining unit, configured to obtain at least two service data in advance; receiving at least one BI analysis subject corresponding to the data to be processed input by the service personnel;
the setting unit is used for creating a model data table according to the at least one BI analysis topic received by the acquisition unit; building a BI model according to the model data table loaded with the service data to be processed by the processing unit;
the processing unit is used for extracting the business data to be processed corresponding to the BI analysis topic from the at least two business data acquired by the acquisition unit aiming at each BI analysis topic in the at least one BI analysis topic; and loading the extracted service data to be processed into the model data table created by the setting unit.
Preferably, the setting unit is configured to rank each of the received at least one BI analysis topic; generating a model data table according to the position of the sequenced BI analysis topics, wherein each BI analysis topic in the model data table corresponds to one row or one column of the model data table;
the processing unit is configured to, for each BI analysis topic in the model data table, extract to-be-processed service data corresponding to the BI analysis topic into a row or a column of the BI analysis topic corresponding to the model data table.
Preferably, further comprising: a display unit;
the display unit is used for displaying the model data table loaded with the to-be-processed business data by the processing unit to the business personnel;
the acquisition unit is used for acquiring a data summarization mode and a chart type which are input by the service personnel according to the model data table loaded with the service data to be processed and displayed by the display unit;
the setting unit is used for summarizing the to-be-processed business data of different BI analysis topics in the model data table according to the data summarizing mode acquired by the acquiring unit; and building a BI model according to the summarized service data to be processed and the obtained chart type, wherein the BI model comprises a report and/or a graph.
Preferably, the obtaining unit is further configured to determine at least one service system; for each business system, extracting at least two business data from the business system according to a preset data extraction range; converting the data format of each service data according to a preset conversion format; loading the business data with the converted data format into a preset data warehouse;
the processing unit is used for extracting the business data to be processed corresponding to the BI analysis topic from the data warehouse.
Preferably, the setting unit is further configured to create at least one sample model data table;
the processing unit is further used for determining whether a model data table corresponding to the BI analysis topic exists in the created at least one sample model data table; when there is no model data table corresponding to the BI analysis topic, performing the creation of the model data table according to the attributes in each of the sample model data tables and the received at least one BI analysis topic.
In the embodiment of the invention, the service data is obtained in advance, so that the problem that the service personnel and the technical personnel consume too much time due to the complicated communication in the collection and processing process of the service data is avoided, and when the BI analysis subject corresponding to the data to be processed input by the service personnel is received, the BI model is not directly created, but a model data table is required to be created first, and then the service data corresponding to the BI analysis subject input by the service personnel is loaded into the created model data table, so that the service personnel can conveniently and clearly obtain the corresponding data information through the model data table, and the BI model required by the service personnel is convenient to build. In summary, by acquiring the service data in advance, the service personnel can acquire and process the corresponding service data without consuming too much time when building the BI model, so that the building speed of the BI model can be increased.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to these drawings without creative efforts.
FIG. 1 is a flowchart of a BI model building method provided by an embodiment of the present invention;
FIG. 2 is a flow chart of another BI model building method provided by an embodiment of the present invention;
FIG. 3 is a schematic diagram of a BI model provided in accordance with an embodiment of the present invention;
FIG. 4 is a schematic structural diagram of a BI model building apparatus provided by an embodiment of the present invention;
FIG. 5 is a schematic structural diagram of another BI model building apparatus provided by an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer and more complete, the technical solutions in the embodiments of the present invention will be described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, but not all, embodiments of the present invention, and based on the embodiments of the present invention, all other embodiments obtained by a person of ordinary skill in the art without creative efforts belong to the scope of the present invention.
As shown in fig. 1, an embodiment of the present invention provides a method for building a business intelligent model, including:
step 101: at least two service data are acquired in advance;
step 102: receiving at least one BI analysis subject corresponding to the data to be processed input by the service personnel;
step 103: creating a model data table based on the received at least one BI analysis topic;
step 104: for each BI analysis topic in the at least one BI analysis topic, extracting the to-be-processed business data corresponding to the BI analysis topic from the obtained at least two business data;
step 105: loading the extracted service data to be processed into the model data table;
step 106: and building a BI model according to the model data table loaded with the service data to be processed.
In the embodiment of the invention, the service data is obtained in advance, so that the problem that the service personnel and the technical personnel consume too much time due to the complicated communication in the collection and processing process of the service data is avoided, and when the BI analysis subject corresponding to the data to be processed input by the service personnel is received, the BI model is not directly created, but a model data table is required to be created first, and then the service data corresponding to the BI analysis subject input by the service personnel is loaded into the created model data table, so that the service personnel can conveniently and clearly obtain the corresponding data information through the model data table, and the BI model required by the service personnel is convenient to build. In summary, by acquiring the service data in advance, the service personnel can acquire and process the corresponding service data without consuming too much time when building the BI model, so that the building speed of the BI model can be increased.
In an embodiment of the present invention, the creating a model data table according to the at least one BI analysis topic includes:
ranking each of the received at least one BI analysis topic;
generating a model data table according to the position of the sequenced BI analysis topics, wherein each BI analysis topic in the model data table corresponds to one row or one column of the model data table;
the loading the extracted service data to be processed into the model data table includes:
and aiming at each BI analysis topic in the model data table, extracting the business data to be processed corresponding to the BI analysis topic into a row or a column of the BI analysis topic corresponding to the model data table.
In the embodiment of the invention, when the model data table is created, all BI analysis topics corresponding to data to be processed input by business personnel need to be sorted first, after the BI analysis topics are sorted, the model data table can be generated according to the positions and the overall structures of all the BI analysis topics, and the created model data table can enable disordered business data to be loaded into the model data table, so that the business personnel can more clearly and more efficiently process the fussy business data.
In an embodiment of the present invention, after the loading the extracted to-be-processed business data into the model data table, before the analyzing and extracting the model data table of the to-be-processed business data, further includes:
displaying the model data table loaded with the to-be-processed business data to the business personnel;
acquiring a data summarizing mode and a chart type input by the service personnel according to the displayed model data table loaded with the service data to be processed;
and constructing a BI model according to the model data table loaded with the to-be-processed service data, wherein the BI model comprises the following steps:
summarizing the business data to be processed of different BI analysis topics in the model data table according to the acquired data summarizing mode;
and building a BI model according to the summarized service data to be processed and the obtained chart type, wherein the BI model comprises a report and/or a graph.
In the embodiment of the invention, after the corresponding business data is loaded in the model data table, the model data table is displayed to business personnel, so that the business personnel can determine a summarizing mode and a format of a BI model to be built according to the displayed model data table, and the BI model required by the business personnel is convenient to build. The disordered business data is displayed to business personnel in a BI model mode, so that the business personnel can provide decision basis according to the BI model to help enterprises make intelligent business operation decisions.
In an embodiment of the present invention, before the pre-acquiring at least two service data, the method further includes:
determining at least one business system;
the pre-acquiring at least two service data includes:
for each business system, extracting at least two business data from the business system according to a preset data extraction range;
converting the data format of each service data according to a preset conversion format;
loading the business data with the converted data format into a preset data warehouse;
the extracting the to-be-processed service data corresponding to the BI analysis topic from the at least two types of acquired service data includes:
and extracting the business data to be processed corresponding to the BI analysis topic from the data warehouse.
In the embodiment of the invention, the technical personnel extract the service data from the service systems according to the data extraction ranges respectively corresponding to the service systems, and the extracted service data is loaded into the preset data warehouse through conversion and integration processing, so that the problem that the service personnel consumes excessive time due to the complicated communication with the technical personnel due to the data acquisition and processing when the service personnel builds the BI model can be avoided.
In an embodiment of the present invention, before the receiving at least one BI analysis topic corresponding to the to-be-processed service data input by the service person, the method further includes:
creating at least one sample model data table;
after receiving at least one BI analysis topic corresponding to the to-be-processed data input by the service personnel, before creating a model data table according to the received at least one BI analysis topic, the method further includes:
determining whether a model data table corresponding to the BI analysis topic exists in the created at least one sample model data table;
when there is no model data table corresponding to the BI analysis topic, performing the creation of the model data table according to the attributes in each of the sample model data tables and the received at least one BI analysis topic.
In the embodiment of the invention, a technician creates at least one sample model data table in advance, when the service personnel needs to create the model data table, the required model data table can be directly searched from the pre-created sample model data table, so that the time for the service personnel to create the model data table is saved, and when the model data table required by the service personnel does not exist in the pre-created sample model data table, the service personnel can rapidly create the required model data table according to the format and the attribute of each sample model data table, so that the excessive time consumed by the complicated communication of the service personnel due to the fact that the service personnel does not understand how to create the model data table is avoided, and the speed for building the service picture can be improved.
In order to more clearly illustrate the technical scheme and advantages of the present invention, a business person Y builds a BI model B for example by taking a BI analysis topic corresponding to business data to be processed as a quarterly income and a mechanism category corresponding to a mechanism a, a mechanism B and a mechanism c, and the method for building a BI model provided by the embodiment of the present invention is described in detail, as shown in fig. 2, and specifically includes the following steps:
step 201: and extracting corresponding service data from the service system according to a preset data extraction range.
Specifically, the business data plays a crucial role in survival and development of the enterprise, most of the business data exists in each business system of the enterprise, and the business data in the business systems are disordered and difficult to understand, so that in order to avoid the complicated communication between business personnel and technicians when the business personnel analyze the business data in the business systems according to needs, the technicians can extract corresponding business data from the business systems according to a preset data extraction range, and the potential safety problem caused by frequent access to the business systems due to the analysis needs of the business data can be avoided.
For example, the data extraction range of the predetermined business system T is 2016 all data, and the service data extracted by the technician r from the business system T in 2016 is:
the organization category of organization a is a cause unit, the income of the first quarter is 1300, the income of the second quarter is 1000, the income of the third quarter is 600 and the income of the fourth quarter is 800;
the organization category of the organization b is an individual industrial and commercial enterprise, the income in the first quarter is 600, the income in the second quarter is 400, the income in the third quarter is 800 and the income in the fourth quarter is 1200;
the institution category of institution c is the career, the first quarter revenue is 486, the second quarter revenue is 598, the third quarter revenue is 986, the fourth quarter revenue is 1358;
the birth date of the client a is 1956.12.03, the nationality is x and the ethnicity is y;
customer b's account opening date is 2016.06.25 and the product contract account is 123456.
Step 202: and processing the extracted service data, and storing the processed service data into a preset data warehouse.
Specifically, after the business data is extracted from the business system, the extracted business data needs to be converted into a uniform format, so that the difficulty of data analysis caused by non-uniform input formats is avoided.
For example, the technician r converts the service data a, the service data b, and the service data c into a preset data format s. And storing the service data a, the service data b and the service data c with the data format s into a pre-created data warehouse.
Step 203: and creating a sample model data table, and storing the created samples in a preset model warehouse.
Specifically, in order to increase the speed of business personnel for creating a BI model, a technician may create a plurality of sample model data tables in advance according to business requirements, so that when the business personnel build the BI model according to actual requirements, the business personnel may directly search a required model data table from the created sample model data tables.
For example, technician J creates sample model data table a as follows:
technician J creates sample model data table B as follows:
step 204: and receiving a BI analysis subject input by the external service person A, wherein the BI analysis subject is a quarterly income and an organization category corresponding to the organization a, the organization b and the organization c respectively.
Specifically, when building a model data table, business personnel need to determine a BI analysis topic corresponding to business data to be processed, and then create a corresponding model data table according to the determined BI analysis topic.
Step 205: and extracting the business data corresponding to the quarterly income and the organization category respectively corresponding to the organization a, the organization b and the organization c which are the main topic of BI analysis from the obtained business data.
Specifically, since the service data is obtained from the service system in advance, when the service data is analyzed according to the requirement, the service system does not need to be frequently accessed, and the complicated communication between the service personnel and the technical personnel in the process of extracting and processing the service data can be avoided.
For example, extracting, from the service data acquired in advance, service data corresponding to the quarterly income and the institution category respectively corresponding to the BI analysis topic of institution a, institution b, and institution c is:
the organization category of organization a is a cause unit, the income of the first quarter is 1300, the income of the second quarter is 1000, the income of the third quarter is 600 and the income of the fourth quarter is 800;
the organization category of the organization b is an individual industrial and commercial enterprise, the income in the first quarter is 600, the income in the second quarter is 400, the income in the third quarter is 800 and the income in the fourth quarter is 1200;
the institution category of institution c is the career, with revenue in the first quarter 486, revenue in the second quarter 598, revenue in the third quarter 986, revenue in the fourth quarter 1358.
Step 206: it is determined whether there are model data tables corresponding to quarterly earnings and institution categories corresponding to the BI analysis topics of institution a, institution b, and institution c, respectively, among the created sample model data tables.
Specifically, because a plurality of sample model data tables are created in advance, when a business requirement exists and the model data tables need to be created, the required model data tables can be directly searched from the created model data tables, so that the time for creating the model data tables can be saved.
Step 207: when there is no model data table corresponding to the quarterly income and institution category corresponding to the BI analysis topic as institution a, institution b, and institution c, respectively, a model data table is created according to the attributes in the created sample model data table.
Specifically, when there is no model data table required by a service requirement in a plurality of pre-created sample model data tables, a service person may quickly create a required model data table according to attributes (for example, formats and field names in the sample model data tables) in the plurality of created sample model data tables, without having to communicate with a technician in a complicated manner how to create the model data table, thereby saving the time of the technician and being capable of improving the speed of the service person for building a BI model.
For example, business person Y creates a model data table with BI analysis topics for quarterly income a and organization category a for organization a and quarterly income b and organization category b for organization b as follows:
step 208: and loading business data corresponding to the quarterly income and the organization category which respectively correspond to the organization a, the organization b and the organization c serving as the BI analysis subject into the model data table.
Specifically, after the required model data table is created and the required service data is extracted, the corresponding service data needs to be loaded into the model data table according to the field name of each column in the model data table, so that a service worker can build the required BI model B according to the model data table loaded with the service data.
Step 209: and displaying the model data table loaded with the business data to a business person Y, and acquiring a data summarizing mode and a chart type input by the business person Y according to the displayed model data table.
Specifically, from the model data table loaded with the business data, the business data can be more convenient to count and check by business personnel, and the business personnel can set a summary mode of the business data in the model data table and a format of a BI model to be built according to actual requirements.
For example, the model data table after loading business data, the institution quarterly income table, is shown to the business personnel as follows:
and acquiring a business person Y according to a displayed model data table-an organization quarterly income table, wherein the input data summarization mode is none, and the format of a BI model is a column diagram.
Step 210: and building a BI model B according to the model data table of the loaded business data, the obtained data summarizing mode and the chart type.
Specifically, each BI model has a corresponding format, and when a data summarization mode of service personnel data is obtained, the service data can be summarized so as to obtain a required service result, then a BI model B required by service personnel can be built according to a chart type required by the service personnel, and the built BI model B is displayed to the service personnel Y.
For example, if the data summarization mode input by the service person Y is none, the service data does not need to be summarized, and the BI model B shown in fig. 3 is created directly according to the BI model format input by the service person Y as a bar chart.
As shown in fig. 4, an embodiment of the present invention provides a BI model building apparatus, including:
an obtaining unit 401, configured to obtain at least two pieces of service data in advance; receiving at least one BI analysis subject corresponding to the data to be processed input by the service personnel;
a setting unit 402, configured to create a model data table according to the at least one BI analysis topic received by the obtaining unit 401; building a BI model according to the model data table loaded with the service data to be processed by the processing unit;
a processing unit 403, configured to, for each BI analysis topic in the at least one BI analysis topic, extract the to-be-processed service data corresponding to the BI analysis topic from the at least two service data acquired by the acquiring unit 401; and loading the extracted service data to be processed into the model data table created by the setting unit 402.
In the embodiment of the invention, the service data is acquired in advance by the acquisition unit, so that the problem that the service personnel and technicians consume too much time due to complicated communication in the process of collecting and processing the service data can be avoided, and when the BI analysis subject corresponding to the data to be processed input by the service personnel is received by the acquisition unit, the BI model is not directly created, but a model data table is created by the setting unit, and then the service data corresponding to the BI analysis subject input by the service personnel is loaded into the created model data table by the processing unit, so that the service personnel can clearly and conveniently acquire corresponding data information through the model data table, and the BI model required by the service personnel can be conveniently built. In summary, by acquiring the service data in advance, the service personnel can acquire and process the corresponding service data without consuming too much time when building the BI model, so that the building speed of the BI model can be increased.
In an embodiment of the present invention, the setting unit is configured to rank each of the at least one BI analysis topic received; generating a model data table according to the position of the sequenced BI analysis topics, wherein each BI analysis topic in the model data table corresponds to one row or one column of the model data table;
the processing unit is configured to, for each BI analysis topic in the model data table, extract to-be-processed service data corresponding to the BI analysis topic into a row or a column of the BI analysis topic corresponding to the model data table.
Based on the BI model building apparatus shown in fig. 4, in an embodiment of the present invention, as shown in fig. 5, the building apparatus further includes: a display unit 501;
the display unit 501 is configured to display the model data table loaded with the to-be-processed service data by the processing unit 403 to the service staff;
the obtaining unit 401 is configured to obtain a data summarization mode and a chart type input by the service staff according to the model data table loaded with the to-be-processed service data displayed by the displaying unit 501;
the setting unit 402 is configured to summarize the to-be-processed service data of different BI analysis topics in the model data table according to the data summarization manner acquired by the acquiring unit 401; and building a BI model according to the summarized service data to be processed and the obtained chart type, wherein the BI model comprises a report and/or a graph.
In an embodiment of the present invention, the obtaining unit is further configured to determine at least one service system; for each business system, extracting at least two business data from the business system according to a preset data extraction range; converting the data format of each service data according to a preset conversion format; loading the business data with the converted data format into a preset data warehouse;
the processing unit is used for extracting the business data to be processed corresponding to the BI analysis topic from the data warehouse.
In an embodiment of the present invention, the setting unit is further configured to create at least one sample model data table;
the processing unit is further used for determining whether a model data table corresponding to the BI analysis topic exists in the created at least one sample model data table; when there is no model data table corresponding to the BI analysis topic, performing the creation of the model data table according to the attributes in each of the sample model data tables and the received at least one BI analysis topic.
The embodiments of the invention have at least the following beneficial effects:
1. in an embodiment of the invention, by acquiring the service data in advance, the problem that excessive time is consumed due to the complicated communication between service personnel and technicians in the process of collecting and processing the service data can be avoided, and when a BI (business intelligence) analysis subject corresponding to data to be processed input by the service personnel is received, a BI model is not directly created, but a model data table is required to be created first, and then the service data corresponding to the BI analysis subject input by the service personnel is loaded into the created model data table, so that the service personnel can conveniently and clearly acquire corresponding data information through the model data table, and the BI model required by the service personnel can be conveniently built. In summary, by acquiring the service data in advance, the service personnel can acquire and process the corresponding service data without consuming too much time when building the BI model, so that the building speed of the BI model can be increased.
2. In an embodiment of the present invention, when creating the model data table, each BI analysis topic corresponding to the data to be processed input by the service personnel needs to be sorted first, and after sorting the BI analysis topics, the model data table can be generated according to the position and the overall structure of each BI analysis topic, and the created model data table can make the service personnel process the anti-locked service data more clearly and more efficiently after the disordered service data is loaded into the model data table.
3. In an embodiment of the present invention, after the corresponding service data is loaded in the model data table, the model data table is displayed to the service personnel, so that the service personnel can determine a summary mode and a format of a BI model to be built according to the displayed model data table, which is convenient for building the BI model required by the service personnel. The disordered business data is displayed to business personnel in a BI model mode, so that the business personnel can provide decision basis according to the BI model to help enterprises make intelligent business operation decisions.
4. In an embodiment of the present invention, a technician extracts service data from service systems according to data extraction ranges respectively corresponding to the service systems, and loads the extracted service data into a preset data warehouse through conversion and integration processing, so that it is possible to avoid that the service personnel consumes too much time due to the complicated communication with the technician due to data acquisition and processing when building a BI model.
5. In an embodiment of the present invention, a technician creates at least one sample model data table in advance, and when the service personnel needs to create a model data table, the technician can directly search a required model data table from the pre-created sample model data table, so as to save time for the service personnel to create the model data table.
It is noted that, herein, relational terms such as first and second, and the like may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising a" does not exclude the presence of other similar elements in a process, method, article, or apparatus that comprises the element.
Finally, it is to be noted that: the above description is only a preferred embodiment of the present invention, and is only used to illustrate the technical solutions of the present invention, and not to limit the protection scope of the present invention. Any modification, equivalent replacement, or improvement made within the spirit and principle of the present invention shall fall within the protection scope of the present invention.
Claims (2)
1. A business intelligent model building method is characterized by comprising the following steps:
at least two service data are acquired in advance;
receiving at least one BI analysis subject corresponding to the data to be processed input by the service personnel;
creating a model data table based on the received at least one BI analysis topic;
for each BI analysis topic in the at least one BI analysis topic, extracting to-be-processed business data corresponding to the BI analysis topic from the obtained at least two business data;
loading the extracted service data to be processed into the model data table;
building a BI model according to the model data table loaded with the service data to be processed;
the creating a model data table based on the received at least one BI analysis topic, comprising:
ranking each of the received at least one BI analysis topic;
generating a model data table according to the position of the sequenced BI analysis topics, wherein each BI analysis topic in the model data table corresponds to one row or one column of the model data table;
the loading the extracted service data to be processed into the model data table includes:
for each BI analysis topic in the model data table, extracting to-be-processed business data corresponding to the BI analysis topic into a row or a column of the BI analysis topic corresponding to the model data table;
after the extracted service data to be processed is loaded into the model data table, before building a BI model, the method further includes:
displaying the model data table loaded with the to-be-processed business data to the business personnel;
acquiring a data summarizing mode and a chart type input by the service personnel according to the displayed model data table loaded with the service data to be processed;
and constructing a BI model according to the model data table loaded with the to-be-processed service data, wherein the BI model comprises the following steps:
summarizing the business data to be processed of different BI analysis topics in the model data table according to the acquired data summarizing mode;
building a BI (business information model) according to the summarized service data to be processed and the obtained chart type, wherein the BI model comprises a report and/or a graph;
before the pre-acquiring of the at least two service data, further comprising:
determining at least one business system;
the pre-acquiring at least two service data includes:
for each business system, extracting at least two business data from the business system according to a preset data extraction range;
converting the data format of each service data according to a preset conversion format;
loading the business data with the converted data format into a preset data warehouse;
the extracting of the to-be-processed service data corresponding to the BI analysis topic from the at least two acquired service data includes:
extracting the business data to be processed corresponding to the BI analysis topic from the data warehouse;
before the receiving of at least one BI analysis topic corresponding to the to-be-processed business data input by the business personnel, the method further includes:
creating at least one sample model data table;
after receiving at least one BI analysis topic corresponding to the to-be-processed data input by the service personnel, before creating a model data table according to the received at least one BI analysis topic, the method further includes:
determining whether a model data table corresponding to the BI analysis topic exists in the created at least one sample model data table;
when there is no model data table corresponding to the BI analysis topic, performing the creating of the model data table according to the attributes in each of the sample model data tables and the received at least one BI analysis topic.
2. A data model building device, comprising:
an obtaining unit, configured to obtain at least two service data in advance; receiving at least one BI analysis subject corresponding to the data to be processed input by the service personnel;
the setting unit is used for creating a model data table according to the at least one BI analysis topic received by the acquisition unit; according to the model data table loaded with the service data to be processed by the processed unit, a BI model is built;
the processing unit is used for extracting the business data to be processed corresponding to the BI analysis topic from the at least two business data acquired by the acquisition unit aiming at each BI analysis topic in the at least one BI analysis topic; loading the extracted service data to be processed into the model data table created by the setting unit;
the setting unit is used for sequencing each BI analysis topic in the received at least one BI analysis topic; generating a model data table according to the position of the sequenced BI analysis topics, wherein each BI analysis topic in the model data table corresponds to one row or one column of the model data table;
the processing unit is used for extracting to-be-processed business data corresponding to the BI analysis topics to a row or a column of the BI analysis topics corresponding to the model data table aiming at each BI analysis topic in the model data table;
further comprising: a display unit;
the display unit is used for displaying the model data table loaded with the to-be-processed business data by the processing unit to the business personnel;
the acquisition unit is used for acquiring a data summarization mode and a chart type which are input by the service personnel according to the model data table loaded with the service data to be processed and displayed by the display unit;
the setting unit is used for summarizing the to-be-processed business data of different BI analysis topics in the model data table according to the data summarizing mode acquired by the acquiring unit; building a BI (business information model) according to the summarized service data to be processed and the obtained chart type, wherein the BI model comprises a report and/or a graph;
the acquiring unit is further configured to determine at least one service system; for each business system, extracting at least two business data from the business system according to a preset data extraction range; converting the data format of each service data according to a preset conversion format; loading the business data with the converted data format into a preset data warehouse;
the processing unit is used for extracting the business data to be processed corresponding to the BI analysis topic from the data warehouse;
the setting unit is further used for creating at least one sample model data table;
the processing unit is further used for determining whether a model data table corresponding to the BI analysis topic exists in the created at least one sample model data table; when there is no model data table corresponding to the BI analysis topic, performing the creating of the model data table according to the attributes in each of the sample model data tables and the received at least one BI analysis topic.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711181236.XA CN107818177B (en) | 2017-11-23 | 2017-11-23 | Business intelligent model building method and building device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711181236.XA CN107818177B (en) | 2017-11-23 | 2017-11-23 | Business intelligent model building method and building device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107818177A CN107818177A (en) | 2018-03-20 |
| CN107818177B true CN107818177B (en) | 2021-06-15 |
Family
ID=61609849
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711181236.XA Active CN107818177B (en) | 2017-11-23 | 2017-11-23 | Business intelligent model building method and building device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107818177B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114860819A (en) * | 2022-07-04 | 2022-08-05 | 广州思迈特软件有限公司 | Method, device, equipment and storage medium for constructing business intelligent system |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101075304A (en) * | 2006-05-18 | 2007-11-21 | 河北全通通信有限公司 | Method for constructing decision supporting system of telecommunication industry based on database |
| CN103853820A (en) * | 2014-02-20 | 2014-06-11 | 北京用友政务软件有限公司 | Data processing method and data processing system |
| CN106354786A (en) * | 2016-08-23 | 2017-01-25 | 冯村 | Visual analysis method and system |
| CN106598988A (en) * | 2015-10-16 | 2017-04-26 | 阿里巴巴集团控股有限公司 | Data processing method and device |
-
2017
- 2017-11-23 CN CN201711181236.XA patent/CN107818177B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101075304A (en) * | 2006-05-18 | 2007-11-21 | 河北全通通信有限公司 | Method for constructing decision supporting system of telecommunication industry based on database |
| CN103853820A (en) * | 2014-02-20 | 2014-06-11 | 北京用友政务软件有限公司 | Data processing method and data processing system |
| CN106598988A (en) * | 2015-10-16 | 2017-04-26 | 阿里巴巴集团控股有限公司 | Data processing method and device |
| CN106354786A (en) * | 2016-08-23 | 2017-01-25 | 冯村 | Visual analysis method and system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107818177A (en) | 2018-03-20 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109151078B (en) | Distributed intelligent mail analysis and filtering method, system and storage medium | |
| CN110851667B (en) | Integration analysis method and tool for large amount of data of multiple sources | |
| KR101505858B1 (en) | A templet-based online composing system for analyzing reports or views of big data by providing past templets of database tables and reference fields | |
| CN108090228B (en) | Method and device for interaction through cultural cloud platform | |
| CN113868235A (en) | Big data-based information retrieval and analysis system | |
| US20180253486A1 (en) | Aggregating Procedures for Automatic Document Analysis | |
| JP2015115024A (en) | Profile management system, information equipment, profile update method, and computer program | |
| US9996529B2 (en) | Method and system for generating dynamic themes for social data | |
| CN105512300B (en) | information filtering method and system | |
| CN113761334A (en) | Visual recommendation method, device, equipment and storage medium | |
| CN114817573A (en) | Knowledge management platform of knowledge graph | |
| KR20130037975A (en) | Method and apparatus for providing web trend analysis based on issue template extraction | |
| CN107818177B (en) | Business intelligent model building method and building device | |
| JP2010211575A (en) | Information evaluation support system | |
| CN107122464B (en) | Decision-making assisting system and method | |
| CN110874366A (en) | Data processing and query method and device | |
| Pohl et al. | Online processing of social media data for emergency management | |
| CN116089490A (en) | Data analysis method, device, terminal and storage medium | |
| KR102413961B1 (en) | Method for providing news analysis service using robotic process automation monitoring | |
| CN112230902B (en) | Software development method and system based on nailing customization | |
| CN110737749B (en) | Entrepreneurship plan evaluation method, entrepreneurship plan evaluation device, computer equipment and storage medium | |
| KR101045850B1 (en) | Device for providing digital timeline through the website | |
| CN113449077A (en) | News popularity calculation method, equipment and storage medium | |
| CN113392329A (en) | Content recommendation method and device, electronic equipment and storage medium | |
| CN113407678A (en) | Knowledge graph construction method, device and equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20210521 Address after: No. 1036, Shandong high tech Zone wave road, Ji'nan, Shandong Applicant after: INSPUR GENERAL SOFTWARE Co.,Ltd. Address before: 250100 No. 2877 Kehang Road, Sun Village Town, Jinan High-tech District, Shandong Province Applicant before: SHANDONG INSPUR GENESOFT INFORMATION TECHNOLOGY Co.,Ltd. |
|
| TA01 | Transfer of patent application right | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |