JP7079660B2 - Analytical work support device, analytical work support method and analytical work support program - Google Patents

Description

The present invention relates to an analysis work support device, an analysis work support method, and an analysis work support program that support the analysis work of business information (for example, business data such as sales data) performed in a company.

Examples of conventional digital dashboards that support the analysis work of business information performed in a company include Patent Documents 1, 2, and 3. Then, in the conventional digital dashboard, it was possible to dig into the details of the data of the set KPI (Key Performance Indicator). For example, for sales, targets, and achievement rates set as KPIs, these numerical values (sales amount, target amount, and achievement rate (= (sales amount ÷ target amount) x 100)) for each business establishment can be used at a specific business establishment. It was possible to delve into the figures for each department.

Japanese Unexamined Patent Publication No. 2010-237900 Japanese Unexamined Patent Publication No. 2012-059074 International Publication No. 2016/080413

Here, it is considered important not only to delve into the above-mentioned digging but also to switch the set KPI to another one in order to realize an appropriate analysis of business information. For example, in addition to delving into the above-mentioned figures for each department, it is also possible to switch the sales, targets and achievement rates set as KPIs to other KPIs such as sales amount, purchase amount, labor cost and gross profit amount. It is considered to be important for realizing appropriate analysis of information. However, the conventional digital dashboard was not built based on the idea of switching KPIs, so in order to do the same thing as this switching with the conventional digital dashboard, set a new KPI after switching. There was no choice but to launch (start) a new digital dashboard by setting new numerical extraction conditions. And this work was complicated for the operator.

In addition, in order to realize an appropriate analysis of business information, an appropriate flow of analysis (for example, what kind of cut or KPI value should be confirmed after confirming a certain KPI value? It is important to make a judgment (such as), but since this judgment requires specialized knowledge, the number of people who can engage in analytical work was limited.

The present invention has been made in view of the above-mentioned problems, and is an analysis work support device and an analysis work that can realize appropriate analysis of business information while reducing complexity and preventing personalization. The purpose is to provide support methods and analytical work support programs.

In order to solve the above-mentioned problems and achieve the object, the analysis work support device according to the present invention is an analysis work support device provided with a control unit, and the control unit includes (1) analysis identification information and business. The business information specific information associated with the set analysis identification information is acquired from the first information including multiple pairs of the business information specific information for specifying the information, and based on the acquired business information specific information. The first acquisition process to acquire business information, (2) analysis identification information, item identification information set in business information, display identification information for identifying the display of item identification information, and non-item identification information The first to acquire the set analysis identification information and the item identification information associated with the display identification information from the second information including a plurality of pairs of one of the non-display identification information for identifying the display. (Ii) Acquisition processing, (3) Criteria analysis identification information that is analysis identification information corresponding to a certain analysis in an analysis flow composed of multiple analyzes, and item identification information set in business information. The display area of the value when the value related to the information is displayed on the screen can be specified, and the next analysis identification information which is the analysis identification information corresponding to the analysis performed after the certain analysis. The first acquisition means for executing the third acquisition process of acquiring the item identification information associated with the same standard analysis identification information as the set analysis identification information from the third information including the set, in any order, and the above-mentioned. The value related to the item identification information acquired in the second acquisition process and the acquired item identification information stored in the business information acquired in the first acquisition process are displayed and acquired in the third acquisition process. A generation means for generating an analysis screen in which the display area of the value related to the item identification information can be specified, a display execution means for displaying the analysis screen generated by the generation means on the display unit, and a state in which the display can be specified. When the display area is designated, (1) the process of acquiring the next analysis identification information associated with the same standard analysis identification information as the set analysis identification information from the third information, and (2). Analysis screen of values set as extraction conditions when acquiring analysis identification information, business information used for the next analysis, and item identification information set as extraction conditions when acquiring business information used for the next analysis. The item identification information and the display area identification information associated with the set analysis identification information are acquired from the fourth information including a plurality of sets of the display area identification information for specifying the display area in the above, and the acquired information is obtained. Display area specific information A second acquisition means that executes a process of acquiring a value based on the above in any order, an update means that updates the set analysis identification information to the next analysis identification information acquired by the second acquisition means, and the above. It is characterized by comprising a setting means for setting the item identification information acquired by the second acquisition means and the extraction condition defined by the value as the extraction condition when acquiring the business information in the first acquisition process. ..

In the analysis business support device according to the present invention, when a plurality of secondary analysis identification information is acquired from the third information, the second acquisition means obtains any one of the acquired plurality of secondary analysis identification information. It is characterized in that a selection screen for selection is generated, the generated selection screen is displayed on the display unit, and when the next analysis identification information is selected, the selected next analysis identification information is acquired. ..

In the analysis business support device according to the present invention, when the item identification information cannot be acquired in the third acquisition process, the generation means is stored in the business information acquired in the first acquisition process. (Ii) To generate an analysis screen in which the value related to the item identification information acquired in the acquisition process and the acquired item identification information are displayed, and the display area of the value related to the item identification information cannot be specified. It is characterized by.

In the analysis work support device according to the present invention, the generation means generates an analysis screen in which the set analysis identification information and the extraction conditions used in the first acquisition process are further displayed. It is a feature.

The analysis work support method according to the present invention is an analysis work support method executed by an information processing apparatus provided with a control unit, and specifies (1) analysis identification information and business information executed by the control unit. The business information specific information associated with the set analysis identification information is acquired from the first information including multiple pairs of the business information specific information for the purpose, and the business information is acquired based on the acquired business information specific information. First acquisition processing to be performed, (2) Identification of analysis identification information, item identification information set in business information, display identification information for identifying the display of item identification information, and non-display of item identification information. The second acquisition process for acquiring the item identification information associated with the set analysis identification information and display identification information from the second information including a plurality of pairs of one of the hidden identification information for the purpose. , (3) The standard analysis identification information, which is the analysis identification information corresponding to a certain analysis in the analysis flow composed of a plurality of analyzes, and the value related to the item identification information among the item identification information set in the business information. A set including a set of a state in which the display area of the value when displayed on the screen can be specified and the next analysis identification information which is the analysis identification information corresponding to the analysis to be performed next to the certain analysis. The first acquisition step of executing the third acquisition process of acquiring the item identification information associated with the same standard analysis identification information as the set analysis identification information from the three information in any order, and the first acquisition process. The value related to the item identification information acquired in the second acquisition process and the acquired item identification information stored in the business information acquired in the above are displayed, and the item identification information acquired in the third acquisition process is displayed. A generation step that generates an analysis screen in which the value display area can be specified, a display execution step that displays the analysis screen generated in the generation step on the display unit, and a display that can be specified. When the area is specified, (1) the process of acquiring the next analysis identification information associated with the same standard analysis identification information as the set analysis identification information from the third information, and (2) the analysis identification information. , The display area on the analysis screen of the item identification information set as the extraction condition when acquiring the business information used for the next analysis and the value set as the extraction condition when acquiring the business information used for the next analysis. Item identification information and display area identification information associated with the set analysis identification information are acquired from the fourth information including a plurality of sets of the display area identification information for identification, and the acquired display area identification is specified. A process of acquiring a value based on the information, a second acquisition step of executing in an arbitrary order, and a process of updating the set analysis identification information to the next analysis identification information acquired in the second acquisition step. Update to execute the process of setting the extraction condition defined by the item identification information and the value acquired in the second acquisition step as the extraction condition when acquiring the business information in the first acquisition process, in any order. It is characterized by including a setting step.

The analysis work support program according to the present invention is an analysis work support program for causing an information processing apparatus provided with a control unit to execute, and (1) analysis identification information and business information to be executed by the control unit. Business information specific information associated with the set analysis identification information is acquired from the first information including multiple pairs of business information specific information for identification, and business information is based on the acquired business information specific information. The first acquisition process to acquire, (2) the analysis identification information, the item identification information set in the business information, the display identification information for identifying the display of the item identification information, and the non-display of the item identification information. Second acquisition to acquire the item identification information associated with the set analysis identification information and display identification information from the second information including a plurality of pairs of one of the hidden identification information for identification. Processing, (3) Standard analysis identification information that is analysis identification information corresponding to a certain analysis in an analysis flow composed of multiple analyzes, and item identification information among the item identification information set in business information. A set of a set that enables the display area of the value to be specified when the value is displayed on the screen and the next analysis identification information that is the analysis identification information corresponding to the analysis to be performed next to the certain analysis. The first acquisition step of executing the third acquisition process of acquiring the item identification information associated with the same standard analysis identification information as the set analysis identification information from the included third information in any order, and the first acquisition step. The value related to the item identification information acquired in the second acquisition process and the acquired item identification information stored in the business information acquired in the acquisition process are displayed, and the item identification acquired in the third acquisition process is displayed. A generation step that generates an analysis screen in which the display area of the value related to information can be specified, a display execution step that displays the analysis screen generated in the generation step on the display unit, and a state that can be specified. When the display area is specified, (1) the process of acquiring the next analysis identification information associated with the same standard analysis identification information as the set analysis identification information from the third information, and (2) analysis identification. Display on the analysis screen of the information, the item identification information set as the extraction condition when acquiring the business information used for the next analysis, and the value set as the extraction condition when acquiring the business information used for the next analysis. From the fourth information including a plurality of sets of the display area identification information for specifying the area, the item identification information and the display area identification information associated with the set analysis identification information are acquired. A second acquisition step of executing a process of acquiring a value based on the acquired display area specific information and an arbitrary order, and a next analysis identification information acquired of the set analysis identification information in the second acquisition step. The process of updating to and the process of setting the extraction condition defined by the item identification information and the value acquired in the second acquisition step as the extraction condition when acquiring the business information in the first acquisition process are optional. It is characterized by including an update / setting step to be executed in the order of.

The present invention has an effect that it is possible to realize appropriate analysis of business information while reducing complexity and preventing personalization.

FIG. 1 is a block diagram showing an example of the configuration of the analysis work support device. FIG. 2 is a diagram showing an example of a header definition master. FIG. 3 is a diagram showing an example of an output item definition master. FIG. 4 is a diagram showing an example of the extraction condition definition master. FIG. 5 is a diagram showing an example of the transition object definition master. FIG. 6 is a diagram showing an example of a transition target extraction condition definition master. FIG. 7 is a flowchart showing an example of analysis work support processing. FIG. 8 is a diagram showing an example of an analysis screen relating to the comparison of sales targets by business establishment. FIG. 9 is a diagram showing an example of an analysis screen regarding the income and expenditure results by department. FIG. 10 is a diagram showing an example of a definition selection screen. FIG. 11 is a diagram showing an example of the transition of the analysis screen realized in the present embodiment.

Embodiments of the present invention will be described in detail with reference to the drawings. The present invention is not limited to the present embodiment.

[1. Constitution]
An example of the configuration of the analysis work support device according to the present embodiment including the present invention will be described with reference to FIGS. 1 to 6. FIG. 1 is a block diagram showing an example of the configuration of the analysis work support device.

The analysis work support device 100 is constructed based on a commercially available desktop personal computer. The analysis work support device 100 is not limited to a device constructed based on a stationary information processing device such as a desktop personal computer, but is not limited to a commercially available notebook personal computer, a PDA (Personal Digital Assistants), a smartphone, and the like. It may be constructed based on a portable information processing device such as a tablet-type personal computer.

The analysis work support device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each part of the analysis work support device 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 connects the analysis business support device 100 to the network 300 so as to be communicable via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with another device via a communication line.

The network 300 has a function of connecting the analysis work support device 100 and the database 200 so as to be able to communicate with each other, and is, for example, the Internet, a LAN (Local Area Network), or the like.

The database 200 stores various business information (business data) such as sales / target data and income / expenditure actual data.

Here, the sales / target data is a table in which "business establishment code", "business establishment name", "department name", "sales", "target", "achievement rate", etc. are set as column names. , Business establishment code, business establishment name, department name, sales amount, target sales amount and achievement rate (= "sales amount ÷ target sales amount" x 100) and the like.

In addition, the income and expenditure record data is a table in which "business establishment name", "department name", "sales amount", "purchase amount", "personnel cost", "gross profit amount", etc. are set as column names. It includes a plurality of records including the business establishment name, department name, sales amount, purchase amount, labor cost, gross profit amount, and the like.

In this way, a plurality of item identification information (column names) are set in the business information, and values related to each item identification information are stored. In the present embodiment, sales / target data and income / expenditure actual data are given as examples of business information stored in the database 200, but the business information stored in the database 200 is not limited to these.

An input device 112 and an output device 114 (corresponding to the display unit of the present invention) are connected to the input / output interface unit 108. As the output device 114, a speaker or a printer can be used in addition to a monitor (including a home television). In addition to the keyboard, mouse, and microphone, the input device 112 can use a monitor that realizes a pointing device function in cooperation with the mouse. In the following, the output device 114 may be referred to as a monitor 114, and the input device 112 may be referred to as a keyboard 112 or a mouse 112.

Various databases, tables, files, and the like are stored in the storage unit 106. In the storage unit 106, a computer program for giving an instruction to a CPU (Central Processing Unit) in cooperation with an OS (Operating System) to perform various processes is recorded. As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) / ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, or the like can be used.

The storage unit 106 includes a header definition master 106a (including the first information of the present invention), an output item definition master 106b (including the second information of the present invention), an extraction condition definition master 106c, and a transition target definition master 106d (the present invention). (Including the third information of the present invention) and the transition target extraction condition definition master 106e (including the fourth information of the present invention) are stored.

FIG. 2 is a diagram showing an example of the header definition master 106a. The header definition master 106a is a table in which a "dashboard name" and a "data acquisition source" are set as column names, and includes a plurality of records including the following information of a1 and a2.
(A1) Analysis identification information for identifying the analysis to be performed, which is displayed in the header area of the analysis screen as the name of the analysis screen (digital dashboard) (for example, "comparison with sales targets by business establishment", "balance record by department", etc. )
(A2) Business information specific information for specifying business information to be displayed in the detail area of the analysis screen (for example, the name assigned to the business information (for example, "sales / target data" or "balance record data") or business. Information storage location (for example, sales / target data directory, balance record data directory, etc.)

FIG. 3 is a diagram showing an example of the output item definition master 106b. The output item definition master 106b is a table in which "dashboard name", "column item", and "display classification" are set as column names, and includes a plurality of records including the following information b1 to b3.
(B1) Analysis identification information (b2) Item identification information set in business information (for example, column name set in sales / target data, column name set in income / expenditure actual data, etc.)
(B3) Display identification information for identifying the display of item identification information on the analysis screen (for example, display category name "display") and non-display identification information for identifying non-display of item identification information on the analysis screen. One of (for example, display category name "hidden")

FIG. 4 is a diagram showing an example of the extraction condition definition master 106c. The extraction condition definition master 106c is a table in which "dashboard name" and "extraction condition item" are set as column names, and includes a plurality of records including the following information of c1 and c2.
(C1) Analysis identification information (c2) Item identification information set as extraction conditions when acquiring business information

FIG. 5 is a diagram showing an example of the transition object definition master 106d. The transition target definition master 106d is a table in which "dashboard name", "transition column item", and "transition destination dashboard name" are set as column names, and includes records including the following d1 to d3 information. It's a waste. The transition destination can be set by digging into any number of layers. Specifically, it is possible to make a transition from the analysis screen related to the "departmental balance record" set as the transition destination to the analysis screen of the next transition destination.
(D1) Criteria analysis identification information which is analysis identification information corresponding to a certain analysis in an analysis flow composed of a plurality of analyzes (d2) Among the item identification information set in the business information, the value related to the item identification information is set. A state in which the display area of the value when displayed on the screen can be specified (d3) Next analysis identification information which is analysis identification information corresponding to the analysis performed next to the certain analysis.

FIG. 6 is a diagram showing an example of the transition target extraction condition definition master 106e. The transition target extraction condition definition master 106e is a table in which "dashboard name", "transition column item", "transition extraction condition item" and "delivery item" are set as column names, and is the following e1 to e4. It contains records that contain information. The following e4 information can be passed as an extraction condition in the next analysis as long as it is a value stored in the acquired business information even if the value is not displayed on the screen. Specifically, the following analysis is performed on the "business establishment code" which is the value related to the column name "column item" in the record in which the value related to the column name "display classification" is "hidden" in the output item definition master 106b. It can be passed as an extraction condition in.
(E1) Analysis identification information (e2) Of the item identification information set in the business information, the one that makes it possible to specify the display area of the value when the value related to the item identification information is displayed on the screen (e3). ) Item identification information set as an extraction condition when acquiring the business information used for the next analysis (e4) In the analysis screen of the value set as the extraction condition when acquiring the business information used for the next analysis. Display area identification information for specifying the display area

The control unit 102 is a CPU or the like that comprehensively controls the analysis work support device 100. The control unit 102 has an internal memory for storing a control program such as an OS, a program that defines various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Run.

The control unit 102 functionally includes a first acquisition unit 102a, a generation unit 102b, a display execution unit 102c, a second acquisition unit 102d, an update unit 102e, and a setting unit 102f.

The first acquisition unit 102a executes the following processes 11 to 13 in any order.
(11) Business information specific information associated with the set analysis identification information (hereinafter referred to as "setting analysis identification information") is acquired from the header definition master 106a, and a database is obtained based on the acquired business information specific information. First acquisition process to acquire business information from 200 (Specifically, the value related to the column name "dashboard name" is the same as the setting analysis identification information. Processing to acquire business information from database 200 based on the acquired value)
(12) Second acquisition process for acquiring the setting analysis identification information and the item identification information associated with the display identification information from the output item definition master 106b (specifically, the value related to the column name "dashboard name" is the setting analysis identification. Processing to acquire the value related to the column name "column item" in the record that is the same as the information and the value related to the column name "display category" is "display")
(13) Third acquisition process for acquiring item identification information associated with the same criteria analysis identification information as the setting analysis identification information from the transition object definition master 106d (specifically, the value related to the column name "dashboard name" is set. Processing to acquire the value related to the column name "transition column item" in the same record as the analysis identification information)

The first acquisition unit 102a sets the acquired business information specific information and the extraction conditions (one or more combinations of the item identification information and the value related to the item identification information) set by the setting unit 102f in the first acquisition process. Based on this, business information may be acquired from the database 200. Specifically, business information may be acquired from the database 200 based on the acquired value related to the column name “data acquisition source” and the extraction conditions set by the setting unit 102f.

Further, in the first acquisition process, the first acquisition unit 102a acquires the item identification information associated with the setting analysis identification information from the extraction condition definition master 106c, and from the acquired item identification information and the value related to the item identification information. Business information may be acquired from the database 200 based on the extraction conditions and the acquired business information specific information. Specifically, the value related to the column name "dashboard name" is the same as the setting analysis identification information. The value related to the column name "extraction condition item" in the record is acquired, and the value related to the acquired column name "extraction condition item" is obtained. Business information may be acquired from the database 200 based on the extraction condition consisting of the values related to the column name "extraction condition item" and the acquired values related to the column name "data acquisition source".

The generation unit 102b is a detail area in which the item identification information acquired in the second acquisition process and the value related to the acquired item identification information stored in the business information acquired in the first acquisition process are displayed in a table format. Therefore, an analysis screen including the item in which the display area of the value related to the item identification information acquired in the third acquisition process can be specified is generated.

If the item identification information cannot be acquired in the third acquisition process, the generation unit 102b has acquired the item identification information stored in the item identification information acquired in the second acquisition process and the business information acquired in the first acquisition process. An analysis screen may be generated including a detail area in which the value related to the item identification information is displayed in a table format and the display area of the value related to the item identification information cannot be specified.

Further, the generation unit 102b may generate an analysis screen further including a header area in which the setting analysis identification information is displayed and an extraction condition area in which the extraction conditions used in the first acquisition process are displayed.

The display execution unit 102c causes the monitor 114 to display the analysis screen generated by the generation unit 102b. The analysis screen of the transition destination may be further displayed on the monitor 114 while the analysis screen before the transition is displayed on the monitor 114. As a result, the operator can check both the analysis screens before and after the transition side by side in the monitor 114.

When the display area in the analysis screen in the specifiable state is designated by the operator, the second acquisition unit 102d executes the following processes 21 and 22 in any order.
(21) Processing to acquire the next analysis identification information associated with the same standard analysis identification information as the setting analysis identification information from the transition object definition master 106d (specifically, the value related to the column name "dashboard name" is the setting analysis identification. Process to get the value related to the column name "Transition destination dashboard name" in the same record as the information)
(22) A process of acquiring the item identification information and the display area specific information associated with the setting analysis identification information from the transition target extraction condition definition master 106e and acquiring the value from the analysis screen based on the acquired display area specific information (22). Specifically, the value related to the column name "dashboard name" is the same as the setting analysis identification information. The value related to the column name "transition extraction condition item" and the value related to the column name "passing item" in the record are acquired and acquired. Processing to acquire the value from the analysis screen based on the value related to the column name "passing item")

When a plurality of next analysis identification information is acquired from the transition target definition master 106d, the second acquisition unit 102d displays a definition selection screen for selecting any one of the acquired plurality of next analysis identification information. The generated definition selection screen may be displayed on the monitor 114, and when one next analysis identification information is selected by the operator, the selected next analysis identification information may be acquired. That is, it may be determined that the selected next analysis identification information is acquired from the transition object definition master 106d.

The update unit 102e updates the setting analysis identification information with the next analysis identification information (acquired in the process of 21) obtained by the second acquisition unit 102d.

The setting unit 102f sets the extraction condition defined by the item identification information and the value (acquired in the process of 22 above) acquired by the second acquisition unit 102d, and the extraction condition when the business information is acquired in the first acquisition process. Set as.

The execution order of the update unit 102e and the setting unit 102f may be arbitrary.

[2. process]
An example of the analysis work support process executed by the analysis work support device 100 will be described with reference to FIGS. 7 to 11. FIG. 7 is a flowchart showing an example of analysis work support processing.

In this description, in the situation where the menu screen (not shown) for allowing the operator to specify the desired analysis (corresponding to the first analysis in the analysis flow) is displayed in advance on the monitor 114, the operator "by business establishment". By specifying "Sales target comparison", it is assumed that the specified "Sales target comparison by business establishment" is set as the setting analysis identification information. Further, in this description, it is premised that this analysis work support process is executed on 1/1/2018.

[Step SA1: Acquisition of business information, etc.]
First, the first acquisition unit 102a executes the following processes A11 to A13 in any order.
(A11) From the header definition master 106a, the value of the column name "data acquisition source" in the record in which the value of the column name "dashboard name" is the same as the setting analysis identification information ("comparison with sales target by business establishment") is acquired. Also, from the extraction condition definition master 106c, the value of the column name "extraction condition item" in the record in which the value of the column name "dashboard name" is the same as the setting analysis identification information ("comparison with sales target by business establishment") is acquired. Then, based on these acquired values and the execution date (2018/1/1) of this analysis business support process, business information is acquired from the database 200 (here, the acquired column name "data acquisition source"". The value of is "sales / target data", the value of the acquired column name "extraction condition item" is "base date", and the acquired business information is the sales / target data as of January 1, 2018. do).
(A12) From the output item definition master 106b, the value of the column name "dashboard name" is the same as the setting analysis identification information ("comparison with sales target by business establishment"), and the value of the column name "display category" is "display". Acquire the value of the column name "column item" in the record that is (Here, the value of the acquired column name "column item" is "business establishment name", "sales", "target" and "achievement rate". ").
(A13) From the transition object definition master 106d, the value of the column name "transition column item" in the record in which the value of the column name "dashboard name" is the same as the setting analysis identification information ("comparison with sales target by business establishment") is acquired. (Here, it is assumed that the value of the acquired column name "transition column item" is "business establishment name").

[Step SA2: Generation of analysis screen]
Next, the generation unit 102b generates the analysis screen MA shown in FIG. Specifically, the generation unit 102b stores (1) the "business establishment name", "sales", "target" and "achievement rate" acquired in the processing of A12 and the sales / target data acquired in the processing of A11. The acquired "business establishment name", "sales", "target" and "achievement rate" values are displayed in a table format in the detail area MA1 and the acquired "business establishment" is processed by A13. The display area MA12 of the value of "name" is in a state that can be specified, (2) the header area MA2 in which the setting analysis identification information ("comparison with sales targets by business establishment") is displayed, and (3). An analysis screen MA including the extraction condition area MA3 displaying the extraction conditions (“base date” and “2018/1/1”) used in the process of A11 is generated.

[Step SA3: Display of analysis screen]
Next, the display execution unit 102c causes the monitor 114 to display the analysis screen MA generated in step SA2.

By executing the processes from step SA1 to step SA3, the analysis screen MA (see FIG. 8) corresponding to the initial analysis (comparison with the sales target by business establishment) in the analysis flow is displayed on the monitor 114. If there is no display area that can be specified in the detail area MA1, the analysis work support process ends here.

[Step SA4: Acquisition of next analysis identification information, etc.]
When, for example, "Tokyo" displayed in the display area MA12 is specified by the operator (see FIG. 9), the second acquisition unit 102d executes the following processes of A41 and A42 in an arbitrary order.
(A41) From the transition object definition master 106d, the value of the column name "dashboard name" is the value of the column name "transition destination dashboard name" in the same record as the setting analysis identification information ("comparison with sales target by business establishment"). (Here, it is assumed that the acquired column name "transition destination dashboard name" has two values, "balance by department" and "comparison with sales target by department").
Then, since multiple values related to the column name "transition destination dashboard name" were acquired, the definition selection for selecting one of the acquired "balance sheet by department" and "comparison with sales target by department". A screen MC (see FIG. 10) is generated, and the generated definition selection screen MC is displayed on the monitor 114. As shown in FIG. 10, the definition selection screen MC includes a list area MC1, a selection button MC2, and a header area MC3.
Then, for example, when the operator selects "balance record by department", the selected "balance record by department" is acquired.
(A42) From the transition target extraction condition definition master 106e, the column name "transition extraction condition item" in the record in which the value of the column name "dashboard name" is the same as the setting analysis identification information ("comparison with sales target by establishment") Acquire the value of the value and the column name "passing item", and acquire the value from the analysis screen MA based on the acquired value of the column name "passing item" (here, the acquired column name "transition extraction condition item"". The values of are "base date" and "business establishment name", and the values of the acquired column name "delivery item" are "base date of extraction condition" and "business establishment name on the screen", from the analysis screen MA. The acquired values are "2018/1/1" and "Tokyo").

[Step SA5: Update of setting analysis identification information, etc.]
Next, the update unit 102e updates the setting analysis identification information (“comparison with sales targets by business establishment”) to the “departmental income and expenditure results” acquired by the processing of A41, and the setting unit 102f updates the setting unit 102f by the processing of A42. The extraction conditions defined by the acquired "base date" and "2018/1/1" and "business establishment name" and "Tokyo" are set as the extraction conditions when business information is acquired in the process of step SA1. The execution order of the update process and the setting process may be arbitrary.

By executing the processes of step SA4 and step SA5, the preparations for the next analysis (balance sheet by department) in the analysis flow are ready.

Then, after step SA5 is executed, the process of step SA1 is executed again in order. Specifically, after step SA5 is executed, in the process of step SA1, the first acquisition unit 102a executes the following processes A11'to A13'in any order, and in the process of step SA2, the generation unit 102b is as follows. In the process of step SA3, the display execution unit 102c executes the process of A31 below.

(A11') From the header definition master 106a, acquire the value of the column name "data acquisition source" in the record in which the value of the column name "dashboard name" is the same as the setting analysis identification information ("balance record by department"). The acquired value (here, the acquired value is assumed to be "balance record data") and the extraction conditions set in step SA5 ("base date" and "2018/1/1" and "business establishment name" and Business information is acquired from the database 200 based on "Tokyo") (here, it is assumed that the acquired business information is the balance record data of the Tokyo office as of January 1, 2018).
(A12') From the output item definition master 106b, the value of the column name "dashboard name" is the same as the setting analysis identification information ("balance record by department"), and the value of the column name "display category" is "display". Get the value of the column name "column item" in a certain record (here, the obtained value is "department name", "sales amount", "purchase amount", "labor cost" and "gross profit amount" There is).
(A13') From the transition object definition master 106d, the value of the column name "transition column item" in the record in which the value of the column name "dashboard name" is the same as the setting analysis identification information ("balance record by department") is acquired. (Here, it is assumed that the value of the column name "transition column item" could not be obtained).

(A21) The analysis screen MB shown in FIG. 9 is generated. Specifically, (1) "department name", "sales amount", "purchase amount", "personnel cost" and "gross profit amount" acquired in the processing of A12'and the balance acquired in the processing of A11'. Detail area MB1 in which the acquired "department name", "sales amount", "purchase amount", "personnel cost" and "gross profit amount" values stored in the actual data are displayed in a table format. (Since the value of the column name "transition column item" could not be acquired in the processing of A13', there is no display area that can be specified in the detail area MB1) and (2) Setting analysis identification information ("Balance record by department") The header area MB2 in which is displayed and the extraction conditions (“base date” and “2018/1/1” and “business establishment name” and “Tokyo”) used in the processing of (3) A11 ′ are displayed. An analysis screen MB including the extraction condition region MB3 is generated.

(A31) The generated analysis screen MB is displayed on the monitor 114.

By the above processing, for example, the analysis flow as shown in FIG. 11 can be realized while reducing the complexity and preventing personalization. Specifically, the analysis business support device 100 is provided with a display area that can be specified by an operator that functions as a trigger for performing the next analysis as an analysis screen corresponding to the first analysis related to the sales target comparison by business establishment. When the operator specifies the display area of the business establishment name "Tokyo" that can be specified, for example, an analysis screen corresponding to the next analysis related to the balance of accounts by department is generated and monitored. Since the display is displayed on the 114, the operator can perform an appropriate analysis of the business information only by designating a desired display area that can be specified and without being aware of the analysis flow. Of course, the analysis business support device 100 can perform the same as before, for example, from the analysis related to the sales target comparison by business establishment to the analysis related to the sales target comparison by department.

[3. Other embodiments]
In addition to the above-described embodiments, the present invention may be implemented in various different embodiments within the scope of the technical idea described in the claims.

For example, of each of the processes described in the embodiments, all or part of the processes described as being automatically performed may be manually performed, or all of the processes described as being performed manually. Alternatively, a part can be automatically performed by a known method.

In addition, processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions for each processing, screen examples, and database configurations shown in this specification and drawings are not specified unless otherwise specified. Can be changed arbitrarily.

Further, with respect to the analysis work support device 100, each component shown in the figure is a functional concept and does not necessarily have to be physically configured as shown in the figure.

For example, with respect to the processing functions included in the analysis work support device 100, particularly each processing function performed by the control unit, all or any part thereof is realized by the CPU and a program interpreted and executed by the CPU. It may be realized as hardware by wired logic. The program is recorded on a non-temporary computer-readable recording medium including programmed instructions for causing the information processing apparatus to execute the processing described in the present embodiment, and supports analysis work as necessary. It is read mechanically by the device 100. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or an HDD (Hard Disk Drive). This computer program is executed by being loaded into RAM, and constitutes a control unit in cooperation with a CPU.

Further, this computer program may be stored in an application program server connected to the analysis business support device 100 via an arbitrary network, and all or part of the computer program may be downloaded as needed. Is.

Further, the program for executing the process described in the present embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the "recording medium" includes a memory card, a USB (Universal Serial Bus) memory, an SD (Secure Digital) card, a flexible disk, a magneto-optical disk, a ROM, an EPROM (Erasable Programmable Read Only Memory), and an EEPROM (registration). Trademarks) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magnet-Optical Disc), MO (Magnet-Optical Disc), DVD (Digital), DVD (Digital) It shall include any "portable physical medium".

Further, the "program" is a data processing method described in any language or description method, regardless of the format such as source code or binary code. The "program" is not necessarily limited to a single program, but is distributed as multiple modules or libraries, or cooperates with a separate program represented by the OS to achieve its function. Including things. It should be noted that well-known configurations and procedures can be used for specific configurations and reading procedures for reading the recording medium in each apparatus shown in the embodiment, installation procedures after reading, and the like.

Various databases and the like stored in the storage unit are memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and storage means such as optical disks, and are used for various processes and website provision. Stores programs, tables, databases, files for web pages, etc.

Further, the analysis work support device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which an arbitrary peripheral device is connected. Further, the analysis work support device 100 may be realized by mounting software (including a program or data) that realizes the processing described in the present embodiment on the device.

Furthermore, the specific form of distribution / integration of the device is not limited to that shown in the figure, and all or part of the device may be functionally or physically in any unit according to various additions or functional loads. It can be distributed and integrated. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

The present invention is particularly useful in the analysis business of business information (for example, business data such as sales data) in a company.

100 Analytical work support device 102 Control unit
102a First acquisition department
102b generator
102c Display execution unit
102d Second acquisition department
102e update section
102f Setting unit 104 Communication interface unit 106 Storage unit
106a Header definition master
106b Output item definition master
106c Extraction condition definition master
106d Transition object definition master
106e Transition target extraction condition definition master 108 Input / output interface unit 112 Input device 114 Output device 200 Database 300 Network

Claims (6)

It is an analysis work support device equipped with a control unit.
The control unit
(1) Obtain the business information specific information associated with the set analysis identification information from the first information including a plurality of sets of the analysis identification information and the business information identification information for specifying the business information, and the relevant information. First acquisition process to acquire business information based on acquired business information specific information, (2) analysis identification information, item identification information set in business information, and display of item identification information From the second information including a plurality of pairs of one of the display identification information and the non-display identification information for identifying the non-display of the item identification information to the set analysis identification information and display identification information. It is set in the second acquisition process to acquire the item identification information to be linked, (3) the standard analysis identification information which is the analysis identification information corresponding to a certain analysis in the analysis flow composed of multiple analyzes, and the business information. Among the item identification information, the one that makes the display area of the value when the value related to the item identification information is displayed on the screen can be specified, and the analysis identification information corresponding to the analysis to be performed next to the certain analysis. From the third information including the set of the next analysis identification information, the third acquisition process of acquiring the item identification information associated with the same standard analysis identification information as the set analysis identification information, is performed in any order. The first acquisition method to be executed and
The value related to the item identification information acquired in the second acquisition process and the acquired item identification information stored in the business information acquired in the first acquisition process are displayed, and are acquired in the third acquisition process. A generation means for generating an analysis screen in which the display area of the value related to the item identification information can be specified, and
A display execution means for displaying the analysis screen generated by the generation means on the display unit,
When the display area in the specifiable state is specified, (1) the process of acquiring the next analysis identification information associated with the same standard analysis identification information as the set analysis identification information from the third information. And (2) the item identification information to be set as the extraction condition when acquiring the analysis identification information and the business information to be used for the next analysis, and the item identification information to be set as the extraction condition when acquiring the business information to be used for the next analysis. The item identification information and the display area identification information associated with the set analysis identification information are acquired from the fourth information including a plurality of sets of the display area identification information for specifying the display area on the analysis screen of the value to be performed. Then, the process of acquiring the value based on the acquired display area specific information, and the second acquisition means for executing in any order,
An update means for updating the set analysis identification information to the next analysis identification information acquired by the second acquisition means, and an update means.
Setting means for setting the extraction condition defined by the item identification information and the value acquired by the second acquisition means as the extraction condition when acquiring the business information in the first acquisition process.
To prepare for
Analytical work support device featuring. When a plurality of secondary analysis identification information is acquired from the third information, the second acquisition means generates a selection screen for selecting any one of the acquired plurality of secondary analysis identification information. When the generated selection screen is displayed on the display unit and the next analysis identification information is selected, the selected next analysis identification information is acquired.
The analysis business support device according to claim 1. When the item identification information cannot be acquired in the third acquisition process, the generation means is a value related to the item identification information acquired in the second acquisition process, which is stored in the business information acquired in the first acquisition process. And the acquired item identification information are displayed, and the analysis screen in which the display area of the value related to the item identification information cannot be specified is generated.
The analysis business support device according to claim 1 or 2. The generation means generates an analysis screen in which the set analysis identification information and the extraction conditions used in the first acquisition process are further displayed.
The analysis work support device according to any one of claims 1 to 3, wherein the analysis work support device is characterized. It is an analysis work support method executed by an information processing device equipped with a control unit.
Executed by the control unit,
(1) Obtain the business information specific information associated with the set analysis identification information from the first information including a plurality of sets of the analysis identification information and the business information identification information for specifying the business information, and the relevant information. First acquisition process to acquire business information based on acquired business information specific information, (2) analysis identification information, item identification information set in business information, and display of item identification information From the second information including a plurality of pairs of one of the display identification information and the non-display identification information for identifying the non-display of the item identification information to the set analysis identification information and display identification information. It is set in the second acquisition process to acquire the item identification information to be linked, (3) the standard analysis identification information which is the analysis identification information corresponding to a certain analysis in the analysis flow composed of multiple analyzes, and the business information. Among the item identification information, the one that makes the display area of the value when the value related to the item identification information is displayed on the screen can be specified, and the analysis identification information corresponding to the analysis to be performed next to the certain analysis. From the third information including the set of the next analysis identification information, the third acquisition process of acquiring the item identification information associated with the same standard analysis identification information as the set analysis identification information, is performed in any order. The first acquisition step to perform and
The value related to the item identification information acquired in the second acquisition process and the acquired item identification information stored in the business information acquired in the first acquisition process are displayed, and are acquired in the third acquisition process. A generation step to generate an analysis screen in which the display area of the value related to the item identification information can be specified, and
A display execution step for displaying the analysis screen generated in the generation step on the display unit, and
When the display area in the specifiable state is specified, (1) the process of acquiring the next analysis identification information associated with the same standard analysis identification information as the set analysis identification information from the third information. And (2) the item identification information to be set as the extraction condition when acquiring the analysis identification information and the business information to be used for the next analysis, and the item identification information to be set as the extraction condition when acquiring the business information to be used for the next analysis. The item identification information and the display area identification information associated with the set analysis identification information are acquired from the fourth information including a plurality of sets of the display area identification information for specifying the display area on the analysis screen of the value to be performed. Then, the process of acquiring the value based on the acquired display area specific information, the second acquisition step of executing in any order, and the second acquisition step.
The process of updating the set analysis identification information to the next analysis identification information acquired in the second acquisition step, and the extraction conditions defined by the item identification information and the value acquired in the second acquisition step are the first. (1) A process to set as an extraction condition when acquiring business information in the acquisition process, an update / setting step to execute in any order, and an update / setting step.
To include,
Analytical work support method characterized by. It is an analysis work support program to be executed by an information processing device equipped with a control unit.
To make the control unit execute
(1) Obtain the business information specific information associated with the set analysis identification information from the first information including a plurality of sets of the analysis identification information and the business information identification information for specifying the business information, and the relevant information. First acquisition process to acquire business information based on acquired business information specific information, (2) analysis identification information, item identification information set in business information, and display of item identification information From the second information including a plurality of pairs of one of the display identification information and the non-display identification information for identifying the non-display of the item identification information to the set analysis identification information and display identification information. It is set in the second acquisition process to acquire the item identification information to be linked, (3) the standard analysis identification information which is the analysis identification information corresponding to a certain analysis in the analysis flow composed of multiple analyzes, and the business information. Among the item identification information, the one that makes the display area of the value when the value related to the item identification information is displayed on the screen can be specified, and the analysis identification information corresponding to the analysis to be performed next to the certain analysis. From the third information including the set of the next analysis identification information, the third acquisition process of acquiring the item identification information associated with the same standard analysis identification information as the set analysis identification information, is performed in any order. The first acquisition step to perform and
The value related to the item identification information acquired in the second acquisition process and the acquired item identification information stored in the business information acquired in the first acquisition process are displayed, and are acquired in the third acquisition process. A generation step to generate an analysis screen in which the display area of the value related to the item identification information can be specified, and
A display execution step for displaying the analysis screen generated in the generation step on the display unit, and
When the display area in the specifiable state is specified, (1) the process of acquiring the next analysis identification information associated with the same standard analysis identification information as the set analysis identification information from the third information. And (2) the item identification information to be set as the extraction condition when acquiring the analysis identification information and the business information to be used for the next analysis, and the item identification information to be set as the extraction condition when acquiring the business information to be used for the next analysis. The item identification information and the display area identification information associated with the set analysis identification information are acquired from the fourth information including a plurality of sets of the display area identification information for specifying the display area on the analysis screen of the value to be performed. Then, the process of acquiring the value based on the acquired display area specific information, the second acquisition step of executing in any order, and the second acquisition step.
The process of updating the set analysis identification information to the next analysis identification information acquired in the second acquisition step, and the extraction conditions defined by the item identification information and the value acquired in the second acquisition step are the first. (1) A process to set as an extraction condition when acquiring business information in the acquisition process, an update / setting step to execute in any order, and an update / setting step.
To include,
An analysis work support program featuring.

Images