JP2023133851A - Data processing system and data processing method - Google Patents

Abstract

To process data of information systems of companies for visualization, thereby quickly obtaining business information of other companies in the same industry.SOLUTION: A data processing system includes: a server 2 which collects data of companies from information systems of the companies, processes the data into internal data which can be browsed only by each of the companies and public data which can be browsed by all companies, and distributes the internal data and the public data to the companies; and data transmission means 12 which transmits data from the information systems of the companies to the server 2; storage means 14 which stores the internal data and the public data distributed from the server 2; and data visualization means 15 which visualizes the internal data and the public data stored in the storage means.SELECTED DRAWING: Figure 1

Description

The present invention relates to a data processing system and a data processing method that process and visualize data from information systems of various companies.

In recent years, a method called business intelligence (hereinafter referred to as ``BI''), which collects, stores, and analyzes in-house data accumulated from business systems and uses it for management decision-making, has been attracting attention. There is. As a form of BI system, software called a dashboard is provided. Dashboards have the main function of collecting various data surrounding a company from internal systems and databases, performing aggregation calculations, and processing and displaying them in charts and graphs (for example, Patent Document 1 reference.).

For example, in the automobile sales industry, the above-mentioned BI system is used to collect and collect visitor information such as the number of customers and customer service at each dealership, sales information such as the number of units sold and sales format, and management information such as profit information. By accumulating, analyzing, and visualizing information, it becomes possible to understand the business situation and use it for decision-making.

Patent No. 6218720

By using a BI system as described above, it is possible to visualize the business status of one's own company, but it is not easy to know the business status of other companies in the automobile sales industry. Therefore, it is difficult to grasp what strengths and weaknesses a company's business situation has in the same industry. As a result, there is a situation in which sales promotion activities such as various measures and campaigns do not lead to clear results.

Therefore, the present invention aims to make it possible to immediately grasp management information of other companies in the same industry by processing and visualizing the data of each company's information system.

The data processing system of the present invention collects each company's data from each company's information system, processes it into in-house data that can be viewed only by the company, and company-wide data that can be viewed by all companies, and sends the in-house data to each company. and a server for distributing company-wide data, a data transmission means for transmitting data from each company's information system to the server, a storage means for storing company-use data and company-wide data distributed from the server, and data stored in the storage means. The system includes data visualization means for visualizing in-house data and company-wide data, respectively.

In addition, another data processing system of the present invention collects each company's data from each company's information system, processes it into in-house data that can only be viewed by each company, and company-wide data that can be viewed by all companies, and a server for distributing in-house data and company-wide data to a computer; data transmission means for transmitting data from each company's information system to the server; storage means for storing in-house data and company-wide data distributed from the server; It includes a program for functioning as a data visualization means for visualizing the in-house data and the company-wide data stored in the storage means.

In addition, the data processing method of the present invention includes transmitting each company's data from each company's information system to a server, and the server collects the data, and each company has in-house data that can be viewed only by the company and data that can be viewed by the entire company. Processing the data into company-wide data and distributing the company-use data and company-wide data to each company; Each company's computer storing the company-use data and company-wide data distributed from the server in a storage means; The present invention is characterized in that it includes visualizing each of the in-house data and the company-wide data stored in the storage means.

According to these inventions, each company's data stored in each company's information system is sent to a server and collected, and each company processes it into in-house data that can only be viewed by the company and company-wide data that can be viewed by the entire company. The data is then distributed to each company, and each company's computer can visualize not only its own data but also the company-wide data.

According to the present invention, each company's computer collects data from each company's information system using a server and processes it into company-use data that can be viewed only by the company and company-wide data that can be viewed by the entire company. Not only data but also company-wide data can be visualized, making it possible to instantly grasp management information of other companies in the same industry.

1 is a configuration diagram of a data processing system in an embodiment of the present invention. FIG. 3 is a flowchart of data processing by the data processing system according to the embodiment of the present invention. FIG. 3 is a diagram showing an example of in-house data visualized by a data visualization means. FIG. 3 is a diagram showing an example of company-wide data visualized by a data visualization means.

FIG. 1 is a configuration diagram of a data processing system according to an embodiment of the present invention.
In FIG. 1, a data processing system according to an embodiment of the present invention is connected to computers 1A, 1B, and 1C located in companies A, B, and C through a network. server 2. The computers 1A, 1B, and 1C are each provided with an information system 10 that stores data from each company, and a BI system 11 that stores and analyzes data from each company. The server 2 collects each company's data from the information systems 10 of companies A, B, and C, processes the data into in-house data that can only be viewed by each company, and company-wide data that can be viewed by all companies. It has the function of distributing in-house data and company-wide data to.

The information system 10 and BI system 11 that operate on the computers 1A, 1B, and 1C, respectively, may be in any form, such as an on-premises form, a cloud form, or a hybrid form of on-premises and cloud. The same applies to server 2. Although FIG. 1 shows the detailed configuration of only the computer 1A of company A, the computers 1B and 1C of companies B and C have similar configurations.

The data accumulated in the information system 10 of each company is management information such as visitor information, sales information, and profit information of each company. For example, in the automobile sales industry, this includes data related to management such as visitor information such as the number of customers visiting each dealership and customer service, sales information such as the number of units sold and sales format, and profit information. These data are generally confidential information that each company handles only within its own information system 10, and is information that is not shared with other companies.

The computers 1A, 1B, and 1C are provided with data transmitting means 12 for transmitting data accumulated in the information systems 10 of each company to the server 2. The data transmitting means 12 is configured by, for example, an RPA (Robotic Process Automation) program running on the computers 1A, 1B, and 1C. The data transmitting means 12 outputs the data of each company accumulated in the information system 10 of each company as, for example, CSV (Comma Separated Value) data, and transmits it to the server 2 . The data transmitting means 12 can also be configured to periodically output data and transmit it to the server 2 by operating a timer.

Further, the computers 1A, 1B, and 1C are provided with processed data receiving means 13 for receiving processed data transmitted from the server 2, as will be described later. The processed data receiving means 13 is configured by, for example, an RPA (Robotic Process Automation) program that operates on the computers 1A, 1B, and 1C. The processed data receiving means 13 receives the processed data transmitted from the server 2 and stores it in the storage means 14 of the BI system 11. The processed data receiving means 13 can also be configured to periodically receive processed data from the server 2 by operating a timer and store it in the storage means 14.

The BI system 11 includes data visualization means 15 and the like that visualize processed data stored in the storage means 14. The details will be described later, but the processed data includes in-house data that can be viewed only by each company such as Company A, Company B, and Company C, and company-wide data that can be viewed by all companies such as Company A, Company B, and Company C. Contains data for use.

The data visualization means 15 analyzes the in-house data and the company-wide data stored in the storage means 14 and visualizes them as various charts, diagrams, etc. As the storage means 14 and the data visualization means 15, for example, a program such as MotionBoard Cloud (registered trademark) by WingArc 1st Co., Ltd. can be used. By executing such programs, the computers 1A, 1B, and 1C function as storage means 14 and data visualization means 15.

The server 2 includes a data receiving means 20 that receives the data of each company transmitted by the data transmitting means 12, a storage means 21 that stores the received data of each company, and each company can view the received data of each company only for itself. a data processing means 22 that processes in-house data and company-wide data that can be viewed by the entire company; and processed data that transmits the in-house data and company-wide data processed by the data processing means 22 to the computers 1A, 1B, and 1C of each company. and a transmitting means 23.

Upon receiving the data of each company transmitted by the data transmitting means 12, the data receiving means 20 stores it in the storage means 21. As mentioned above, the data of each company stored in the storage means 21 is generally confidential information and is strictly managed so as not to be leaked to other companies.

The data processing means 22 processes the data of each company stored in the storage means 21 into in-house data that can be viewed only by each company, and company-wide data that can be viewed by the entire company. Company-wide data is data that is shared throughout the company and can be viewed by the entire company in order to compare with other companies in the same industry and to obtain examples of success and failure. As mentioned above, each company's data is confidential information, but the data processing means 22 uses data of each company that may be shared with other companies (data that is permitted to be shared with other companies) for company-wide use. Data. In-house data is data that each company has accumulated in its own information system 10, and does not include data of other companies.

The processed data transmitting means 23 transmits the in-house data and the company-wide data processed by the data processing means 22 to the computers 1A, 1B, and 1C of each company. The processed data transmitting means 23 transmits company data and company-wide data to the computers 1A, 1B, and 1C as, for example, CSV data. At this time, the processed data transmitting means 23 includes only in-house data for company A that can be viewed only by the company, that is, data sent from the information system 10 of company A. Send in-house data that will be used. This in-house data of company A does not include any data transmitted from the information systems 10 of other companies such as company B and company C.

The data receiving means 20, the data processing means 22, the processed data transmitting means 23, etc. are configured by, for example, an RPA (Robotic Process Automation) program that operates on the computers 1A, 1B, and 1C.

Next, a data processing method using the data processing system having the above configuration will be explained. FIG. 2 is a flow diagram of data processing by the data processing system in this embodiment.

First, the information systems 10 of Company A, Company B, and Company C contain visitor information such as the number of store visitors and customer service conditions, sales information such as the number of units sold and sales format, and management information such as profit information. Data from each company is entered and accumulated on a daily basis. As shown in FIG. 2, in the computers 1A, 1B, and 1C of companies A, B, and C, the data transmission means 12 automatically transmits the data of each company stored in the respective information systems 10. Transmit to the server (S100).

When the data receiving means 20 of the server 2 receives the data of each company transmitted by the data transmitting means 12, it stores it in the storage means 21 (S101). The data processing means 22 processes the data of each company stored in the storage means 21 into in-house data that can be viewed only by each company and company-wide data that can be viewed by the entire company (S102). The processed data transmitting means 23 transmits the in-house data and the company-wide data processed by the data processing means 22 to the computers 1A, 1B, and 1C of each company (S103).

The processed data receiving means 13 of the computers 1A, 1B, and 1C of each company receives the company data and the company-wide data transmitted from the server 2, and stores them in the storage means 14 of the BI system 11 of each company (S104). In each company, the data visualization means 15 can analyze the in-house data and the company-wide data stored in the storage means 14 and visualize them as various charts, diagrams, etc. (S105).

3 shows an example of in-house data visualized by the data visualization means 15, and FIG. 4 shows an example of company-wide data visualized by the data visualization means 15. As shown in FIG. 3, the data visualization means 15 visualizes company data consisting only of data stored in the company's information system 10, and as shown in FIG. Visualize Company C's company-wide data. Using this visualized company-wide data, each company can instantly grasp the management information of other companies in the same industry.

In the above embodiment, the processed data transmitting means 23 transmits company data and company-wide data to the computers 1A, 1B, 1C of each company on which the BI system 11 of each company operates, , 1C has been described, but if the BI system 11 operates on a system different from the computers 1A, 1B, and 1C, for example in a cloud format, data is sent to the BI system 11 on the cloud. It is also possible to have a configuration in which:

The data processing system and data processing method of the present invention are useful as a system and method for processing and visualizing data in each company's information system, and are particularly useful as a system and method that can instantly grasp management information of other companies in the same industry. This is suitable as a method.

1A, 1B, 1C Computer 2 Server 10 Information system 11 BI system 12 Data transmission means 13 Processed data reception means 14 Storage means 15 Data visualization means 20 Data reception means 21 Storage means 22 Data processing means 23 Processed data transmission means

Claims (3)

Each company's data is collected from each company's information system, and each company processes it into in-house data that can only be viewed by the company and company-wide data that can be viewed by all companies, and then sends the in-house data and the company-wide data to each company. A server that delivers
data transmitting means for transmitting the data from the information systems of the companies to the server;
storage means for storing the in-house data and the company-wide data distributed from the server;
A data processing system including data visualization means for visualizing the in-house data and the company-wide data stored in the storage means. Each company's data is collected from each company's information system, and each company processes it into in-house data that can only be viewed by the company and company-wide data that can be viewed by all companies, and then sends the in-house data and the company-wide data to each company. A server that delivers
A computer is connected to a data transmitting means for transmitting the data from the information system of each company to the server, a storage means for storing the in-house data and the company-wide data distributed from the server, and the data stored in the storage means. A data processing system including a program for functioning as a data visualization means for visualizing in-house data and the company-wide data. Sending each company's data from each company's information system to the server,
The server collects the data, processes it into in-house data that can be viewed only by each company, and company-wide data that can be viewed by all companies, and distributes the in-house data and the company-wide data to each company. thing,
the computer of each company stores the company data and the company-wide data distributed from the server in a storage means;
A data processing method comprising: computers of each company respectively visualizing the company data and the company-wide data stored in the storage means.

Images