Business support device, business support method, and business support program

Abstract

This invention provides a business support device, a business support method, and a business support program that can improve analysis efficiency by linking multiple dashboards according to the purpose of analysis to alerts (anomaly detection), and by selecting and displaying one of the linked dashboards. [Solution] A business support device comprising a control unit, which is capable of accessing an alert definition master and a dashboard definition master, wherein the control unit comprises an alert definition execution means for performing anomaly detection processing, an alert list screen display means for displaying an alert list screen which is a list of alerts detected by the alert definition execution means, and a dashboard display means for extracting a plurality of dashboards associated with an alert selected by the user via the alert list screen from the dashboard definition master, and displaying one of the extracted plurality of dashboards according to the purpose of analysis.

Description

Technical Field

[0001] The present invention relates to a business support device, a business support method, and a business support program.

Background Art

[0002] In recent years, internal control standards of companies have been revised, and accordingly, the need for control strengthening and monitoring has been increasing. In order to prevent various frauds in corporate management, it is possible to efficiently detect frauds by performing detections along with each fraud. In order to effectively confirm the detected results, it is preferable to appropriately analyze the detection results for each fraud on a dashboard which is an operation screen of a computer. In addition, in order to improve the accuracy of analysis, it is necessary to perform multi-faceted analysis using a plurality of charts. On the other hand, as the number of charts increases and the charts become complicated, the learning cost of analysts increases. Furthermore, the analysis may become insufficient and it may become impossible to make correct management decisions. There is a need to perform appropriate analysis by switching dashboards according to the analysis purpose.

[0003] Patent Document 1 describes a programmable logic controller comprising: a first execution means for executing a control program; a storage means which is a device or variable that is a memory area accessed by the first execution means in accordance with the control program; a collection means for collecting time-series data designated as a collection target from the storage means; a second execution means for executing predetermined data processing on the time-series data collected from the storage means at different timings in accordance with a data utilization program; a generation means for generating source data including source code or image data for a dashboard that displays the execution results of the data utilization program; and an output means for outputting the source data to an external computer, wherein the programmable logic controller has an editing means for editing setting data including a dashboard template and a set of templates for the data utilization program associated with the dashboard, in order to display data that is data obtained by executing the predetermined data processing on the time-series data to be collected in accordance with the data utilization program on the dashboard, and the generation means generates the source data for the dashboard based on the setting data (Claim 1), and further describes a providing means configured to provide the external computer with a setting screen for accepting the selection of one dashboard from a plurality of dashboards and the specification of time-series data to be collected by the collection means (Claim 5). [Prior art documents] [Patent Documents]

[0004] [Patent Document 1] Japanese Patent Publication No. 2021-60966 [Overview of the project] [Problems that the invention aims to solve]

[0005] Patent Document 1 facilitates the creation of a data utilization program and a dashboard to display it, but it does not allow for the selection and display of dashboards according to the purpose of analysis.

[0006] The present invention has been made in view of the above-mentioned problems, and aims to provide a business support device, a business support method, and a business support program that can improve analysis efficiency by linking multiple dashboards according to the purpose of analysis to an alert (anomaly detection), and by selecting and displaying one of the linked dashboards. [Means for solving the problem]

[0007] To solve the above-mentioned problems and achieve the objective, the business support device according to the present invention is a business support device that includes a control unit and supports analysis related to business, and is able to access an alert definition master that stores an alert definition ID, an alert definition name and an algorithm, and a dashboard definition master that stores a dashboard definition CD, a dashboard definition name, an alert definition ID and setting information for charts and graphs to be displayed on the dashboard, and the control unit is characterized by including an alert definition execution means that performs anomaly detection processing with an algorithm stored in the alert definition master, an alert list screen display means that displays an alert list screen which is a list of alerts detected by the alert definition execution means, and a dashboard display means that extracts a plurality of dashboards associated with an alert selected by the user via the alert list screen from the dashboard definition master and displays one of the extracted plurality of dashboards according to the purpose of analysis.

[0008] Furthermore, in the business support device according to the present invention, the analysis objective is the object of analysis (analysis range) and / or the user's proficiency.

[0009] Furthermore, in the business support device according to the present invention, the dashboard is equipped with radio buttons to switch to other dashboards linked to the alert selected by the user.

[0010] Furthermore, the business support device according to the present invention is able to access a user-specific initial display dashboard master that stores information including an alert definition ID, a dashboard definition CD, and a user name, and the dashboard display means refers to the user-specific initial display dashboard master from the logged-in user name and displays the dashboard of the dashboard definition CD associated with the selected alert definition ID.

[0011] Furthermore, in the business support device according to the present invention, the dashboard has an alert display area that displays alerts other than those selected by the user, and the dashboard display means displays a dashboard associated with the selected alert when the user selects an alert other than those displayed in the alert display area.

[0012] Furthermore, the business support device according to the present invention includes a user-specific initial display update means that, when a user presses the initial display setting button, identifies the data in the user-specific initial display dashboard master based on the user being used and the displayed alert definition ID, and updates it to the selected dashboard definition CD.

[0013] Furthermore, the business support method according to the present invention is a business support method to be executed by a business support device equipped with a control unit that supports analysis related to business, and is characterized in that it has access to an alert definition master that stores an alert definition ID, an alert definition name and an algorithm, and a dashboard definition master that stores a dashboard definition CD, a dashboard definition name, an alert definition ID and setting information for charts to be displayed on the dashboard, and is executed by the control unit, and includes an alert definition execution step means that performs an anomaly detection process using an algorithm stored in the alert definition master, an alert list screen display step that displays an alert list screen which is a list of alerts detected by the alert definition execution step, and a dashboard display step that extracts a plurality of dashboards associated with an alert selected by the user via the alert list screen from the dashboard definition master, and displays one of the plurality of dashboards according to the purpose of analysis.

[0014] Furthermore, the business support program according to the present invention is a business support program that is executed by a business support device equipped with a control unit that supports business analysis, and is capable of accessing an alert definition master that stores an alert definition ID, an alert definition name and an algorithm, and a dashboard definition master that stores a dashboard definition CD, a dashboard definition name, an alert definition ID and setting information for charts and graphs to be displayed on the dashboard, and is characterized in that the control unit is caused to execute an alert definition execution step that performs an anomaly detection process using an algorithm stored in the alert definition master, an alert list screen display step that displays an alert list screen which is a list of alerts detected by the alert definition execution step, and a dashboard display step that extracts a plurality of dashboards associated with an alert selected by the user via the alert list screen from the dashboard definition master and displays one of the plurality of dashboards according to the purpose of analysis. [Effects of the Invention]

[0015] The present invention has the effect of improving analysis efficiency by associating a plurality of dashboards with an alert (abnormality detection) and selectively displaying one of the associated dashboards according to the analysis purpose.

Brief Description of the Drawings

[0016] [Figure 1] FIG. 1 is a block diagram showing the configuration of the business support apparatus according to the embodiment. [Figure 2] FIG. 2 is a diagram showing an example of an alert definition master. [Figure 3] FIG. 3 is a diagram showing an example of a result message table. [Figure 4] FIG. 4 is a diagram showing an example of a determination result table. [Figure 5] FIG. 5 is a diagram showing an example of a data source definition master. [Figure 6] FIG. 6 is a diagram showing an example of a data source parameter master. [Figure 7] FIG. 7 is a diagram showing an example of a data source column master. [Figure 8] FIG. 8 is a diagram showing an example of a user-specific initial display dashboard master. [[ID=三十一]] [Figure 9] FIG. 9 is a diagram showing an example of a dashboard definition master. [Figure 10] FIG. 10 is a diagram for explaining the chart setting of the dashboard. [Figure 11] FIG. 11 is a diagram for explaining the chart setting of the dashboard.. [Figure 12A] FIG. 12A is a diagram for explaining the chart setting of the dashboard. [Figure 12B] FIG. 12B is a diagram for explaining the chart setting of the dashboard. [Figure 13A] FIG. 13A is a diagram for explaining the chart setting of the dashboard. [Figure 13B] FIG. 13B is a diagram for explaining the chart setting of the dashboard. [Figure 14A]Figure 14A is a diagram illustrating the settings for the dashboard charts. [Figure 14B] Figure 14B is a diagram illustrating the settings for the dashboard charts. [Figure 15] Figure 15 shows an example of the alert list confirmation screen. [Figure 16] Figure 16 shows an example of a dashboard. [Figure 17] Figure 17 shows an example of a dashboard. [Figure 18] Figure 18 shows an example of a dashboard. [Figure 19] Figure 19 shows an example of a dashboard. [Figure 20] Figure 20 shows an example of a dashboard. [Figure 21] Figure 21 is a diagram illustrating the acquisition of data for charts and graphs displayed on the dashboard. [Figure 22] Figure 22 illustrates how to draw charts and graphs to be displayed on the dashboard. [Figure 23] Figure 23 shows an example of a dashboard. [Figure 24] Figure 24 illustrates the updating of the user-specific initial display dashboard master. [Modes for carrying out the invention]

[0017] The following describes in detail, with reference to the drawings, a business support device, a business support method, and a business support program that represent embodiments of the present invention. However, the present invention is not limited to these embodiments.

[0018] [1. Structure] Referring to Figure 1, an example of the configuration of the business support device 100 according to the embodiment will be described. Figure 1 is a block diagram showing the configuration of the business support device 100 according to the embodiment.

[0019] The business support device 100 comprises a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each part of the business support device 100 is connected to communicate via any communication path.

[0020] The communication interface unit 104 connects the business support device 100 to the network 300 via communication devices such as routers and wired or wireless communication lines such as dedicated lines, enabling communication between them. The communication interface unit 104 has the function of communicating data with other devices via communication lines. Here, the network 300 has the function of connecting the business support device 100 and the server 200 so that they can communicate with each other, and is, for example, the internet or a LAN (Local Area Network).

[0021] The input / output interface unit 108 is connected to an input device 400 and an output device 500. The output device 500 can be a monitor (including a home television), a speaker, or a printer. The input device 400 can be a keyboard, a mouse, a microphone, or a monitor that works in conjunction with the mouse to provide pointing device functionality. In the following, the output device 500 may be referred to as the monitor 500, and the input device 400 as the keyboard 400 or mouse 400. Also, the display of information on the monitor 500 and the user's operation of the input device 400 may be referred to as "user operation via UI".

[0022] The memory unit 106 stores various databases, tables, and files. The memory unit 106 also stores computer programs that work in cooperation with the OS (Operating System) to give instructions to the CPU (Central Processing Unit) to perform various processes. As the memory unit 106, for example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, and optical disks can be used.

[0023] The storage unit 106 stores, for example, an alert definition master 106a, a result message table 106b, a judgment result table 106c, a data source setting master 106d, a data source parameter master 106e, a data source column master 106f, a user-specific initial display dashboard master 106g, a dashboard definition master 106h, business data 106i, and the like.

[0024] The alert definition master 106a stores information indicating each algorithm used for anomaly detection. As shown in Figure 2, the alert definition master 106a stores the alert definition name, algorithm, and judgment result table name associated with each alert definition ID. Here, the alert definition ID is an ID that uniquely manages the alert definition, and the alert definition name manages the name of the alert definition.

[0025] The results message table 106b manages the specific content to be displayed when anomaly detection results for each alert definition are shown as messages. As shown in an example in Figure 3, the results message table 106b stores the message ID, alert definition ID, message, execution date, etc. Here, the message ID is an ID that uniquely manages the message, and the alert definition ID is the definition ID for which the alert was executed. The message is the message information displayed on the analysis screen, and the execution date is the date and time the alert was executed.

[0026] The judgment result table 106c is a table that holds the anomaly detection results for each alert definition. Figure 4 shows examples of judgment result table 106c-1 for the alert definition name "Project Scarce Cost Occurrence Alert" and judgment result table 106c-2 for the alert definition name "Alert Definition 2". The Project Scarce Cost Judgment Result Table stores the alert execution history detail ID, line number, judgment result, project name, cost account, amount, cluster name, construction period, work type, etc., while the Alert Definition 2 Judgment Result Table stores the alert execution history detail ID, line number, judgment result, accounting year and month, person in charge name, and sales cancellation amount. The judgment result is the anomaly judgment result obtained by executing the algorithm of the Project Scarce Cost Occurrence Alert or Alert Definition 2, and is entered categorized as "abnormal" or "normal". The contents of the columns that make up the judgment result differ for each alert definition.

[0027] The data source configuration master 106d stores the data source definition name and the stored procedure name. Figure 5 shows an example of the data source configuration master 106d. The data source definition name manages the name of the data source definition and is also used to make the data source definition unique for each dashboard definition CD, which will be described later. The stored procedure name manages the stored procedure used in the data source definition.

[0028] The data source parameter master 106e stores the data source definition name, parameter name, parameter type, and fixed value. Figure 6 shows an example of the data source parameter master 106e. The parameter name is used to manage the name of the parameter, and the parameter type is used to manage the type for which the parameter value is set. The fixed value is used when the parameter type is a fixed value.

[0029] The data source column master 106f stores the data source definition name and the data source column names. Figure 7 shows an example of the data source column master 106f. The data source column names manage the column names of the acquired results.

[0030] The user-specific initial display dashboard master 106g stores the alert definition ID, dashboard definition CD, and user name. Figure 8 shows an example of the user-specific initial display dashboard master 106g. The alert definition ID in the user-specific initial display dashboard master 106g is the alert definition ID linked to the dashboard definition described later. The dashboard definition CD manages the CD that uniquely identifies the dashboard definition. The user name is a column that uniquely identifies the user.

[0031] Dashboard definition master 106h stores the dashboard definition CD, dashboard definition name, alert definition ID, and dashboard settings. Figure 9 shows an example of dashboard definition master 106h. Dashboard definition name manages the name of the dashboard definition. Settings manage the settings of the dashboard definition in JSON format. For example, dashboard chart settings include explanatory text, a graph of projects with high project costs by expense category, and a list of incurred cost details.

[0032] The dashboard definition master 106h stores multiple dashboard definitions linked to each alert definition. In the dashboard definition master 106h shown in Figure 9, three dashboards, dashboard definition CDs "DB1", "DB2", and "DB3", are linked to alert definition ID "Alert001", two dashboards, dashboard definition CDs "DB4" and "DB5", are linked to alert definition ID "Alert002", two dashboards, dashboard definition CDs "DB6" and "DB7", and two dashboards, dashboard definition CDs "DB8" and "DB9", are linked to alert definition ID "Alert004".

[0033] Business data 106i stores various business data to be analyzed.

[0034] Functionally, the control unit 102 includes an alert definition execution unit 102a, a result data generation unit 102b, an alert list screen display unit 102c, a dashboard display unit 102d, and the like.

[0035] The alert definition execution unit 102a executes the anomaly detection algorithm stored in the alert definition master 106a.

[0036] The result data generation unit 102b generates a judgment result table 106c showing the anomaly detection results based on the algorithm execution results (anomaly detection results) by the alert definition execution unit 102a. The result data generation unit 102b also stores the details of the judgment result table 106c that are judged as "abnormal" along with the message (alert) in the result message table 106b.

[0037] The alert list screen display unit 102c displays the alert list screen MA, which is a list of alerts detected by the anomaly detection process of the alert definition execution unit 102a. Figure 15 shows an example of the alert list confirmation screen MA. The alert list screen display unit 102c displays the messages and execution dates of the result message table 106b for each message.

[0038] The dashboard display unit 102d extracts multiple dashboards associated with the message (alert) selected by the user via the alert list screen MA from the dashboard definition master 106h, and displays one of the extracted dashboards according to the purpose of analysis. If alert definition ID "Alert001" "Construction: Construction A Cost Account: Miscellaneous Expenses Detected" or "Construction: Construction C Cost Account: Miscellaneous Expenses Detected" is selected on the alert list screen MA, the dashboard display unit 102d displays one of the dashboard definition IDs "DB1", "DB2", or "DB3". If alert definition ID "Alert002" "Abnormal data detected" is selected on the alert list screen MA, the dashboard display unit 102d displays dashboard definition ID "DB4" or "DB5". If alert definition ID "Alert003" "Abnormal data detected" is selected on the alert list screen MA, the dashboard display unit 102d displays dashboard definition ID "DB6" or "DB7". If the alert definition ID "Alert004" for "Abnormal data detected" is selected in the alert list screen MA, the dashboard definition ID "DB8" or "DB9" will be displayed.

[0039] [2. Processing] A specific example of the processing of the business support device 100 in this embodiment will be described with reference to Figures 2 to 24.

[0040] The alert definition execution unit 102a executes the anomaly detection algorithm stored in the alert definition master 106a shown in Figure 2. The result data generation unit 102b generates result data indicating the anomaly detection result based on the algorithm execution result (anomaly detection result) by the alert definition execution unit 102a. The result data generation unit 102b then stores the detection data in the judgment result table 106c (see Figure 4) corresponding to the algorithm executed by the alert definition execution unit 102a.

[0041] Furthermore, the result data generation unit 102b stores the abnormality detection results obtained from the judgment result table 106c in the result message table 106b, along with the templates obtained from the result message template master table. For example, the method for obtaining templates from the result message template master table can be found in Japanese Patent Application Publication No. 2023-64481.

[0042] When the alert definition execution unit 102a performs an anomaly detection procedure, and the result data generation unit 102b generates the judgment result table 106c and stores the anomaly detection result in the result message table 106b, the alert list screen display unit 102c displays the alert list screen MA.

[0043] The alert list confirmation screen MA shown in Figure 15 displays a list of alerts that were determined to be abnormal during the anomaly detection process performed at the beginning of the month. The alert list confirmation screen MA displays the alert definition name along with the message for alerts detected on April 1, May 1, June 1, July 1, August 1, September 1, and October 1, 2023.

[0044] When a user selects one of the alerts displayed on the alert list confirmation screen MA, the dashboard display unit 102d extracts multiple dashboards associated with the selected alert from the dashboard definition master 106h, and displays one of the extracted dashboards according to the purpose of analysis.

[0045] For example, if a user selects the top alert displayed on the alert list confirmation screen MA in Figure 15, "Project Scarce Cost Incurrence Alert: Construction: Construction A, Cost Account: Miscellaneous Expenses Detected," the alert definition ID "Alert001" for "Project Scarce Cost Incurrence Alert" is retrieved from the alert definition master 106a, and the dashboard associated with alert definition ID "Alert001" is retrieved from the dashboard definition master 106h. In the dashboard definition master 106h, the dashboard definition CDs associated with alert definition ID "Alert001" are "DB1," "DB2," and "DB3," and the dashboard display unit 102d displays a dashboard from among these according to the purpose of analysis. Note that in the dashboard definition master 106h in Figure 9, dashboard definition CD "DB1" is the dashboard definition name "Irregularity Confirmation of Target Construction (for Education)," dashboard definition CD "DB2" is the dashboard definition name "Irregularity Confirmation of Target Construction," and dashboard definition CD "DB3" is the dashboard definition name "Analysis Results of All Construction / Cluster Confirmation."

[0046] Figure 16 shows Dashboard MB-1 with Dashboard Definition CD "DB1" and Dashboard Definition Name "Irregularity Check for Target Construction (Educational)", Figure 17 shows Dashboard MB-2 with Dashboard Definition CD "DB2" and Dashboard Definition Name "Irregularity Check for Target Construction", and Figure 18 shows Dashboard MB-3 with Dashboard Definition CD "DB3" and Dashboard Definition Name "Analysis Results and Cluster Confirmation for All Construction".

[0047] Dashboard MB-1 in Figure 16 is a dashboard for users whose analysis targets are limited and who have low proficiency in dashboard analysis. It has the same diagram and table structure as Dashboard MB-2 in Figure 17, which has the same analysis target as Dashboard Definition CD "DB2" and the dashboard definition name "Irregularity Check for Target Projects," but explanatory text has been added. Dashboard MB-3 in Figure 18, which has the same analysis target as Dashboard Definition CD "DB3" and the dashboard definition name "Analysis Results and Cluster Confirmation for All Projects," displays three graphs and two tables because the analysis target is all projects: "Graph of Projects with High Cost Amounts by Expense Item," "Graph of Cost Amounts by Cluster," "List of Project Classification Indicators for Specific Clusters," "Table of Amount Ratios by Cost Account for Specific Clusters," and "Graph of Correlation between Contract Amount and Work Type." This displays more diagrams and tables than Dashboard MB-1 and Dashboard MB-2, which have one graph and one table.

[0048] One method for selecting and displaying dashboards according to the purpose of analysis is to select the display based on the analysis target, for example, whether to display a dashboard limited to the analysis of a specific construction project or a dashboard for analysis of all construction projects. Furthermore, the dashboard can also be selected based on the skill level of the user performing the analysis. While dashboards displaying multiple charts and graphs enable detailed analysis, their complexity increases the learning cost for the analyst, potentially leading to insufficient analysis and incorrect decision-making if used by an inexperienced user. The user-specific initial display dashboard master 106g stores dashboard definition CDs corresponding to the analysis target or each user's skill level. The dashboard display unit 102d then refers to the user-specific initial display dashboard master 106g and displays the dashboard of the dashboard definition CD associated with the alert definition ID selected from the logged-in username. In the dashboards "DB1," "DB2," and "DB3" associated with the aforementioned alert definition ID "Alert001," "DB1" and "DB2" are dashboards limited to the analysis of a specific construction project, while "DB3" is a dashboard covering all construction projects.

[0049] For example, if User A selects the top alert displayed on the alert list confirmation screen MA in Figure 15, "Project Scarce Cost Alert: Construction: Construction A, Cost Account: Miscellaneous Expenses Detected," the alert definition ID for "Project Scarce Cost Alert" is "Alert001" (see Figure 2). In the user-specific initial display dashboard master 106g in Figure 8, if the alert definition ID is "Alert001" and the username is "User A," the dashboard definition CD is "DB1," so the dashboard display unit 102d displays dashboard MB-1 in Figure 15, which has dashboard definition CD "DB1." Among the dashboard definition CDs "DB1," "DB2," and "DB3" associated with alert definition ID "Alert001," "DB1" and "DB2" are dashboards limited to the analysis of specific construction projects, while "DB3" is a dashboard that covers all construction projects. Furthermore, "DB1" is an educational dashboard that displays explanatory text and is for users with low proficiency, while "DB2" is a dashboard for users who are proficient in analysis. The user-specific initial display dashboard master 106g should store dashboard definition CDs that take into account the user's analysis target and proficiency level.

[0050] On the other hand, each dashboard MB-1 to MB-3 has a radio button b1, and next to radio button b1 is the dashboard definition name of the currently displayed dashboard. Users can perform analysis on the displayed dashboard, and by selecting radio button b1, they can also switch to other dashboards associated with the alert they have selected. For example, when the radio button "Confirm fraudulent activity in target construction" is pressed on dashboard MB-1, the dashboard display unit 102d switches the display to dashboard MB-2.

[0051] Figure 23 shows an example of a dashboard. Dashboard MB-6 shown in Figure 23 is a modified version of dashboard "DB1" associated with alert definition ID "Alert001", and has an initial display setting button b2. When a user presses the initial display setting button b2, the system identifies the user's initial display dashboard master 106g data based on the user and the displayed alert definition ID, and updates it to the selected dashboard definition CD. For example, if user B selects "Project scarce cost alert Construction: Construction A Cost account: Miscellaneous expenses detected" on the alert list confirmation screen MA, the dashboard display unit 102d will display dashboard "DB3" which covers all construction projects, by referencing the user's initial display dashboard master 106g shown in Figure 8. When user B selects "For checking fraudulent activities in the target construction (for educational purposes)" using radio button b1, the display switches to dashboard MB-1. Then, when user B presses the initial display setting button b2, as shown in Figure 24, the user-specific initial display dashboard master 106g updates the dashboard definition CD for user B's initial display to "DB1".

[0052] Furthermore, Dashboard MB-1 to Dashboard MB-3 have an alert display area r1 that displays other alerts not selected by the user. The alert display area b1 has a scroll bar r2, and by scrolling the scroll bar r2, all alerts displayed on the alert list confirmation screen MA can be displayed in the alert display area b1. If the user selects another alert displayed in the alert display area b1, the dashboard display unit 102d displays the dashboard associated with the selected alert.

[0053] For example, in the alert display area b1 of dashboard MB-1 shown in Figure 15, two alerts are displayed: "Project Scarce Cost Alert: Construction: Construction A, Cost Account: Miscellaneous Expenses Detected" and "Alert Definition 2: Abnormal Data Detected". When the user clicks and selects "Alert Definition 2: Abnormal Data Detected", the dashboard display unit 102d displays dashboards MB-4 and MB-5 (see Figures 19 and 20) corresponding to dashboard definition CD "DB4" or "DB5" associated with "Alert Definition 2: Abnormal Data Detected" (Alert Definition ID "Alert002"). In dashboards MB-4 and MB-5, radio button b1 will be one of two dashboard definition names, "Confirmation of Fraudulent Activity by Target Person" and "Confirmation of Fraudulent Activity by Target Person (with Initial Display Style Setting)", associated with dashboard definition CD "DB4" and "DB5" associated with alert definition ID "Alert002", and the displayed charts will also be those stored in the settings of dashboard definition CD "DB4" and "DB5".

[0054] Next, we will briefly explain the chart and text settings in the dashboard. Figure 10 is a diagram illustrating the chart settings of dashboard MB-1 shown in Figure 16. The contents of the settings displayed in Figure 10 are stored in the settings column of the dashboard definition master 106h. The contents of the settings in Figure 10 do not directly store the messages to be displayed on the dashboard; the dashboard display unit 102d obtains the messages to be displayed on the dashboard by referring to the judgment result supplementary information table and the judgment result table (not shown). For example, the setting item header for the explanatory text settings in Figure 10 states "{Himoku} Amount incurred\r\n {Kingaku}", but by referring to the judgment result supplementary information table and the judgment result table, it obtains "Miscellaneous expenses" corresponding to {Himoku}. {Upper}, {KoujiName}, etc. in Figure 10 are obtained in the same way. Note that in Figures 11 to 14B, the contents of the obtained messages are displayed for ease of understanding. For details on obtaining messages to be displayed on the dashboard, please refer to Japanese Patent Publication No. 2022-170223. Dashboard MB-1 is for "Irregularity Verification of Target Construction Projects (for Educational Use)," and its chart settings include "Explanatory Text," "Setting of Construction Project Graphs with High Cost Amounts by Expense Category," and "Setting of Incurred Cost Details List." Although the charts are the same as Dashboard MB-2 in Figure 11, for educational purposes, "Explanatory Text" is set, and within the "Setting of Construction Project Graphs with High Cost Amounts by Expense Category" and "Setting of Incurred Cost Details List," explanatory text is displayed in the header and details. Note that "¥r¥n" in the text information means "to insert a line break" when drawing.

[0055] In the "Settings for the project graph with the highest cost per expense item," the chart type is set to "Clustered Bar Chart," the data source definition name is set to "Project Cost Amount Data," and other information such as legend information, X-axis information, Y-axis information, and judgment result style information are also set. In the "Settings for the Cost Details List," the data source definition name is set to "Project Cost Details List Data," and column information is also set. The dashboard display unit 102d draws charts based on the set information. The column information defined here is obtained from the "Project Cost Details List Data" in the data source column 106f master.

[0056] Figures 12A and 12B illustrate the chart settings for Dashboard MB-3 shown in Figure 18. Dashboard MB-3 is for "checking for fraud in all construction projects," and its chart settings include "setting a graph for projects with high expenditure amounts by expense item," "setting a graph for cost accounting amounts by cluster," "setting a list of project classification indicators for specific clusters," "setting a table of cost percentages for each cost account for specific clusters," and "setting a graph of the correlation between contract amount and work type." Dashboard MB-3 in Figures 12A and 12B uses more charts than Dashboards MB-1 and MB-2 because it is for analyzing the results of all construction projects and checking clusters.

[0057] In the "Cluster-Specific Cost Accounting Amount Graph Settings," the chart type is set to "Stacked Bar Graph," the data source definition name is set to "Cluster Account Data," and other information such as legend information, X-axis information, Y-axis information, and judgment result style information is also set. In the "Specific Cluster Construction Classification Indicator List Settings," the data source definition name is set to "Construction Cost Details Cluster Information Data," and column information is set. In the "Specific Cluster Cost Account Amount Ratio Table Settings," the data source definition name is set to "Construction Cost Details Ratio Data," and column information is set. In the "Contract Amount and Work Type Correlation Graph Settings," the chart type is set to "Scatter Plot," the data source definition name is set to "Cluster Account Data," and other information such as legend information, X-axis information, Y-axis information, and judgment result style information is also set. The dashboard display unit 102d draws charts based on the set information. In the "Incurred Cost Details List Settings," the data source definition name is set to "Construction Cost Details List Data," and column information is also set. The column information specified here is obtained from the "Construction Cost Details List Data" in the data source column 106f master.

[0058] Here, we will briefly explain how to obtain and draw chart data in the "Cluster-Specific Cost Accounting Graph Settings" of Dashboard MB-3. To obtain the data source for the chart, the stored procedure name, parameter name, and parameter type are identified by referring to the data source setting master 106d and data source parameter master 106e from the data source definition name "Cluster Account Data". In the data source setting master 106d and data source parameter master 106e in Figures 5 and 6, the stored procedure name for "Cluster Account Data" is "Cluster Account Stored Procedure", the parameter names are "p_Alert Execution History Detail ID" and "p_Row Number", and the parameter types are "Alert Execution History Detail ID" and "Row Number". The parameter values ​​are determined from the alert execution history detail ID and row number of the project scarce cost occurrence alert judgment result table 106c-1 (dashboard definition CD "MB3" has alert definition ID "Alert001" and alert definition "Project Scarce Cost Occurrence Alert").

[0059] Figure 21 illustrates the acquisition of data for charts and graphs displayed in the dashboard definition CD "DB3". Within the identified stored procedure "Cluster Account-Specific Stored Procedure", the project scarce cost occurrence alert judgment result table 106c-1 and business data 106i are referenced, and the record in the project scarce cost occurrence alert judgment result table 106c-1 is identified based on the parameter value, and abnormal data is acquired. From the identified judgment result, the judgment result is abnormal for data with the account category being miscellaneous expenses.

[0060] Figure 22 illustrates the drawing of charts displayed in the dashboard definition CD "DB3". As described in "Settings for the Cluster-Specific Cost Amount Graph", the "Cluster-Specific Cost Amount" chart is a stacked bar graph with the X-axis representing "Cluster (Cluster 1, Cluster 2, Cluster 3, Cluster 4)", the Y-axis representing "Amount", and the legend representing "Account (Materials, Personnel, Outsourcing, Miscellaneous, Other)". The Y-axis "Amount" of the stacked bar graph is the sum of the account amounts for each cluster from the data source. In the judgment result style information settings, legends with abnormal judgment results are displayed in "red (black in Figure 22)".

[0061] Figures 13A and 13B illustrate the chart settings for Dashboard MB-4 shown in Figure 19, and Figures 14A and 14B illustrate the chart settings for Dashboard MB-5 shown in Figure 20. Dashboards MB-4 and MB-5 are displayed by the chart settings of Dashboard Definition CDs "DB4" and "DB5" associated with Alert Definition ID "Alert002". Dashboard MB-4 has the dashboard definition name "Fraud Check for Target Personnel", and Dashboard MB-5 has the dashboard definition name "Fraud Check for Target Personnel (Initial Display Style Setting Enabled)". The chart settings for Dashboards MB-4 and MB-5 specify "Explanatory Text Settings", "Sales Cancellation Amount Trend Graph Settings", and "Sales Item Change History List Settings". In the chart settings of Figures 14A and 14B, the initial display style setting is enabled, and the fields that reflect the style in the initial display x-axis information and initial display legend information are set to "True", and the style settings for the target color and the transparency of the excluding are configured. In the initial display of x-axis information, the color of the target (which is abnormal in the judgment result) is displayed as "gray," and the transparency of the non-target (which is normal in the judgment result) in the initial display legend information is set to "50%" to emphasize that March 2023 for person in charge 1 is abnormal.

[0062] If a user configures the chart settings with an initial display style as shown in Figures 14A and 14B, the user's initial display dashboard master 106g will be set to "DB5" as the dashboard definition CD for that user. If the user who made the configuration selects alert definition ID "Alert002" on the alert list screen MA, the dashboard with dashboard definition CD "DB5" will be displayed.

[0063] In the business support device 100 according to this embodiment, multiple dashboards can be linked to alerts (anomaly detections), and analysis efficiency can be improved by selecting and displaying one of the linked dashboards according to the purpose of analysis.

[0064] [3. Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving operational efficiency and promoting appropriate management decisions by companies, thereby contributing to SDG Goals 8 and 9.

[0065] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and digital processes, thereby contributing to SDGs Goals 12, 13, and 15.

[0066] Furthermore, this embodiment can contribute to strengthening control and governance, thereby enabling contributions to SDG Goal 16.

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

[0068] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically by known methods.

[0069] Furthermore, the processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions for each process, screen examples, and database configuration shown in this specification and in the drawings may be changed at will unless otherwise specified.

[0070] Furthermore, with respect to the business support device 100, each component shown in the diagram is a functional concept and does not necessarily need to be physically configured as shown.

[0071] For example, the processing functions of the business support device 100, particularly those performed by the control unit, may be implemented in whole or in part by a CPU and a program interpreted and executed by the CPU, or they may be implemented as wired logic hardware. The program is recorded on a non-temporary computer-readable recording medium containing programmed instructions for the information processing system to execute the processing described in this embodiment, and is mechanically read by the business support device 100 as needed. That is, a storage unit such as ROM or HDD (Hard Disk Drive) contains a computer program that works in cooperation with the OS to give instructions to the CPU and perform various processing tasks. This computer program is executed by being loaded into RAM and works in cooperation with the CPU to constitute the control unit.

[0072] Furthermore, this computer program may be stored on an application program server connected to the business support device 100 via any network, and it is possible to download all or part of it as needed.

[0073] Furthermore, the program for executing the processing described in this embodiment may be stored on a non-temporary computer-readable recording medium, or it may be configured as a program product. Here, "recording medium" includes any "portable physical medium" such as memory cards, USB (Universal Serial Bus) memory, SD (Secure Digital) cards, flexible disks, magneto-optical disks, ROMs, EPROMs (Erasable Programmable Read Only Memory), EEPROMs (Registered Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROMs (Compact Disk Read Only Memory), MOs (Magneto-Optical disks), DVDs (Digital Versatile Disks), and Blu-ray (Registered Trademark) Discs.

[0074] Furthermore, "program" refers to a data processing method described in any language or writing method, regardless of its format, such as source code or binary code. Note that "program" is not necessarily limited to a single, monolithic structure; it also includes distributed structures consisting of multiple modules or libraries, and those that work in cooperation with other programs, such as an operating system, to achieve their functions. Regarding the specific configuration and reading procedures for reading the recording medium in each system shown in the embodiments, as well as the installation procedures after reading, well-known configurations and procedures can be used.

[0075] The various databases stored in the memory unit include memory systems such as RAM and ROM, fixed disk systems such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files used for various processes and website provision.

[0076] Furthermore, the business support device 100 may be configured as an information processing system such as a known personal computer or workstation, or as an information processing system to which any peripheral system is connected. Alternatively, the business support device 100 may be implemented by implementing software (including programs or data, etc.) that realizes the processing described in this embodiment on the system.

[0077] Furthermore, the specific forms of system distribution and integration are not limited to those shown in the diagram, and all or part of it can be configured by functionally or physically distributing and integrating it in any unit according to various additions or functional loads. In other words, the embodiments described above may be implemented in any combination, or the embodiments may be implemented selectively. [Industrial applicability]

[0078] While this invention is applicable to all industries, it is particularly useful for users in the construction, real estate, and chemical industries who have implemented accounting and accounts receivable / payable systems. [Explanation of Symbols]

[0079] 100 Business support equipment 102 Control Unit 102a Alert Definition Execution Unit 102b Result Data Generation Unit 102c Alert List Screen Display Unit 102d Dashboard Display Unit 104 Communication Interface Section 106 Storage section 106a Alert Definition Master 106b Result message table 106c Judgment Result Table 106d Data Source Configuration Master 106e Data Source Parameter Master 106f Data Source Column Master 106g User-Specific Initial Display Dashboard Master 106h Dashboard Definition Master 108 Input / Output Interface Section 200 servers 300 Networks 400 Input Devices 500 Output Device

Claims

1. A business support device equipped with a control unit that assists in business-related analysis, An alert definition master that stores the alert definition ID, alert definition name, and algorithm, A dashboard definition master that stores the dashboard definition CD, dashboard definition name, alert definition ID, and settings information for the charts and graphs to be displayed on the dashboard, Accessible, The control unit, An alert definition execution means that performs anomaly detection processing using an algorithm stored in the alert definition master, An alert list screen display means displays an alert list screen which is a list of alerts detected by the alert definition execution means, A dashboard display means extracts multiple dashboards from the dashboard definition master that are associated with an alert selected by the user via the alert list screen, and displays one of the extracted multiple dashboards according to the purpose of analysis. A business support device characterized by being equipped with the following features.

2. The purpose of the aforementioned analysis is to determine the subject of analysis (scope of analysis) and / or the user's proficiency. The business support device according to claim 1.

3. The dashboard includes radio buttons to switch to other dashboards associated with the alert selected by the user. The business support device according to claim 1.

4. A user-specific initial display dashboard master that stores information including alert definition ID, dashboard definition CD, and username. Accessible, The dashboard display means refers to the user-specific initial display dashboard master from the logged-in username and displays the dashboard of the dashboard definition CD associated with the selected alert definition ID. The business support device according to claim 1.

5. The dashboard has an alert display area that displays alerts other than those selected by the user, The dashboard display means, when the user selects another alert displayed in the alert display area, displays the dashboard associated with the selected alert. The business support device according to claim 1.

6. The aforementioned dashboard has an initial display setting button, When a user presses the initial display setting button, the system includes a user-specific initial display update means that identifies the data in the user-specific initial display dashboard master based on the user being used and the displayed alert definition ID, and updates it to the selected dashboard definition CD. The business support device according to claim 1.

7. A business support method to be executed by a business support device equipped with a control unit that supports analysis related to business operations, An alert definition master that stores the alert definition ID, alert definition name, and algorithm, A dashboard definition master that stores the dashboard definition CD, dashboard definition name, alert definition ID, and settings information for the charts and graphs to be displayed on the dashboard, Accessible, To be executed by the control unit, An alert definition execution step which performs an anomaly detection process using an algorithm stored in the alert definition master, An alert list screen display step displays an alert list screen, which is a list of alerts detected by the alert definition execution step, A dashboard display step which extracts multiple dashboards associated with an alert selected by the user via the alert list screen from the dashboard definition master, and displays one of the extracted multiple dashboards according to the purpose of analysis, A business support method characterized by including the following.

8. A business support program to be executed by a business support device equipped with a control unit that assists in business analysis, An alert definition master that stores the alert definition ID, alert definition name, and algorithm, A dashboard definition master that stores the dashboard definition CD, dashboard definition name, alert definition ID, and settings information for the charts and graphs to be displayed on the dashboard, Accessible, The control unit, An alert definition execution step which performs an anomaly detection process using an algorithm stored in the alert definition master, An alert list screen display step displays an alert list screen, which is a list of alerts detected by the alert definition execution step, A dashboard display step which extracts multiple dashboards associated with an alert selected by the user via the alert list screen from the dashboard definition master, and displays one of the extracted multiple dashboards according to the purpose of analysis, A business support program characterized by its ability to execute certain actions.

Images