Apparatus and method of automated data procesesing and visual reports generating through sharing excel spreadsheets and database

Abstract

A data processing and visual report generation device is disclosed, comprising: a communication module that communicates with a user terminal; and a processor that performs a data processing and visualization process, wherein the processor stores first data in the form of an Excel spreadsheet received from the user terminal in a database server to construct a database, analyzes the data characteristics of the first data, searches for second data among the data stored in the database that can be mutually processed with the first data based on the data characteristics of the first data, processes the first data and the second data into third data according to a preset calculation format, and generates a report including at least one visual element for the third data.

Description

Technology Field

[0001] The present disclosure relates to a data processing and visualization system. More specifically, the present disclosure relates to an apparatus and method for automated data processing and visual report generation through the integration of an Excel spreadsheet and a database. Background Technology

[0002] Spreadsheets such as Excel are representative software for processing data; they are widely used and easier for users to handle than other programs, and Excel is extensively used as office software.

[0003] In particular, Excel handles data as tables, providing features that allow for more intuitive handling; therefore, a large amount of data is often managed and processed using spreadsheets such as Excel.

[0004] Due to the convenience of Excel as described above, many technologies have been proposed for converting database data into Excel or converting Excel data into databases for storage, and many have also been commercialized.

[0005] In other words, database data is converted into Excel to perform tasks using the easy-to-handle Excel format; consequently, as work progresses, the volume of data becomes massive, requiring the use of multiple sheets and workbooks.

[0006] Although spreadsheet programs such as Excel provide various features to facilitate the convenience of users processing vast amounts of data, they are not intuitive and have limited functional integration, which limits their ability to improve work efficiency. Prior art literature

[0007] Korean Registered Patent 10-2507637 (2022.08.28) The problem to be solved

[0008] The embodiment disclosed in this disclosure is intended to store data in the form of an Excel spreadsheet entered by a user in a database, automatically process calculations according to an optimal calculation format, and provide a report including at least one visual element regarding the processed data.

[0009] The problems that this disclosure aims to solve are not limited to those mentioned above, and other unmentioned problems will be clearly understood by a person skilled in the art from the description below. means of solving the problem

[0010] An apparatus according to the present disclosure for achieving the aforementioned technical objectives comprises: a communication module that communicates with a user terminal; and a processor that performs data processing and visualization processes. The processor can construct a database by storing first data in the form of an Excel spreadsheet received from the user terminal in a database server, analyze data characteristics of the first data, search for second data among the data stored in the database that can be mutually processed with the first data based on the data characteristics of the first data, process the first data and the second data into third data according to a pre-set calculation format, and generate a report including at least one visual element for the third data.

[0011] In addition, the processor can identify a calculation format that is repeatedly processed according to the data characteristics in the form of an Excel spreadsheet stored in the database, set it as an automatic calculation format according to the data characteristics, and process the first data and the second data into the third data according to the automatic calculation format corresponding to the data characteristics of the first data.

[0012] In addition, the processor may provide a user interface to the user terminal for selecting at least one operation value in each category of input data, output data, data preprocessing, and data integration.

[0013] In addition, the processor can combine operation values ​​selected through the user interface to set a user-defined operation format, and process the first data and the second data into the third data according to the user-defined operation format.

[0014] In addition, the processor can identify a computational format that can be performed between the first data and the second data, set it as a recommended computational format, and process the first data and the second data into the third data according to the recommended computational format.

[0015] In addition, when multiple second data are searched, the processor may provide the multiple searched second data to the user terminal so that the second data to be operated on with the first data among the multiple searched second data can be selected.

[0016] In addition, the processor can process the first data and the second data selected through the user terminal into the third data according to any one of an automatic calculation format, a user-specified calculation format, and a recommended calculation format.

[0017] In addition, the processor can analyze the data features including at least one of the scale, category value, and text of the data.

[0018] In addition, it may further include a debugging module that detects and debugs errors occurring in the data processing or visualization process of the above processor.

[0019] Additionally, the method according to the present disclosure may be performed by a device comprising a processor that performs a data processing and visualization process, and may include: a step of constructing a database by storing first data in the form of an Excel spreadsheet received from a user terminal in a database server; a step of analyzing the data characteristics of the first data; a step of searching for second data that can be mutually operated with the first data among the data stored in the database based on the data characteristics of the first data; a step of processing the first data and the second data into third data according to a pre-set operation format; and a step of generating a report including at least one visual element for the third data.

[0020] In addition to this, a computer program stored on a computer-readable recording medium for executing the present disclosure may be further provided.

[0021] In addition, a computer-readable recording medium for recording a computer program for executing a method for implementing the present disclosure may be further provided. Effects of the invention

[0023] According to the aforementioned means for solving the problem of the present disclosure, by storing data in the form of an Excel spreadsheet entered by a user in a database, performing automatic calculation processing according to an optimal calculation format, and further generating and providing a report including the calculated data, the efficiency of data processing can be maximized and work efficiency can be increased, which is an advantageous effect.

[0024] The effects of the present disclosure are not limited to those mentioned above, and other unmentioned effects will be clearly understood by a person skilled in the art from the description below. Brief explanation of the drawing

[0025] FIG. 1 is a schematic diagram of a data processing and visual report generation system according to one embodiment of the present disclosure. FIG. 2 is a control block diagram of a data processing and visual report generation device according to one embodiment of the present disclosure. FIGS. 3 to 6 are flowcharts of a method for data processing and visual report generation according to one embodiment of the present disclosure. FIGS. 7 and FIGS. 8 are examples of screens output from a user terminal according to one embodiment of the present disclosure. Specific details for implementing the invention

[0026] Throughout this disclosure, the same reference numerals denote the same components. This disclosure does not describe all elements of the embodiments, and general content in the art to which this disclosure pertains or content that overlaps between embodiments is omitted. The terms 'part, module, component, block' as used in the specification may be implemented in software or hardware, and depending on the embodiments, a plurality of 'parts, modules, components, blocks' may be implemented as a single component, or a single 'part, module, component, block' may include a plurality of components.

[0027] Throughout the specification, when a part is described as being "connected" to another part, this includes not only cases where they are directly connected but also cases where they are indirectly connected, and indirect connections include connections made via a wireless communication network.

[0028] Furthermore, when it is stated that a part "includes" a certain component, this means that, unless specifically stated otherwise, it does not exclude other components but may include additional components.

[0029] Throughout the specification, when it is stated that a component is located "on" another component, this includes not only cases where a component is in contact with another component, but also cases where another component exists between the two components.

[0030] The terms first, second, etc. are used to distinguish one component from another, and the components are not limited by the aforementioned terms.

[0031] Singular expressions include plural expressions unless there is an obvious exception in the context.

[0032] In each step, identification codes are used for convenience of explanation and do not describe the order of the steps; the steps may be performed differently from the specified order unless a specific order is clearly indicated in the context.

[0033] The operating principles and embodiments of the present disclosure will be described below with reference to the attached drawings.

[0034] In this specification, the term "device according to the present disclosure" includes all various devices capable of performing computational processing and providing results to a user. For example, the device according to the present disclosure may include all of a computer, a server device, and a portable terminal, or may be in the form of any one of these.

[0035] Here, the computer may include, for example, a notebook, desktop, laptop, tablet PC, slate PC, etc. equipped with a web browser.

[0036] The above server device is a server that processes information by communicating with an external device, and may include an application server, a computing server, a database server, a file server, a game server, a mail server, a proxy server, and a web server.

[0037] The above portable terminal may include, for example, all types of handheld-based wireless communication devices such as PCS (Personal Communication System), GSM (Global System for Mobile communications), PDC (Personal Digital Cellular), PHS (Personal Handyphone System), PDA (Personal Digital Assistant), IMT (International Mobile Telecommunication)-2000, CDMA (Code Division Multiple Access)-2000, W-CDMA (W-Code Division Multiple Access), WiBro (Wireless Broadband Internet) terminals, smartphones, etc., as well as wearable devices such as watches, rings, bracelets, anklets, necklaces, glasses, contact lenses, or head-mounted devices (HMDs).

[0038] Functions related to artificial intelligence according to the present disclosure are operated through a processor and memory. The processor may be composed of one or more processors. In this case, the one or more processors may be general-purpose processors such as CPUs, APs, and DSPs (Digital Signal Processors), graphics-dedicated processors such as GPUs and VPUs (Vision Processing Units), or artificial intelligence-dedicated processors such as NPUs. The one or more processors control the processing of input data according to predefined operation rules or artificial intelligence models stored in memory. Alternatively, if the one or more processors are artificial intelligence-dedicated processors, the artificial intelligence-dedicated processors may be designed with a hardware structure specialized for processing a specific artificial intelligence model.

[0040] FIG. 1 is a schematic diagram of a data processing and visual report generation system according to one embodiment of the present disclosure.

[0041] Referring to FIG. 1, a data processing and visual report generation system (10) according to one embodiment of the present disclosure may include a data processing and visual report generation device (100), a user terminal (200), and a database server (300).

[0042] The data processing and visual report generation device (100) can provide a data processing and visual report generation service according to the present invention.

[0043] The data processing and visual report generation service can store data in the form of an Excel spreadsheet in a database, analyze the data in the form of an Excel spreadsheet to perform calculations according to an optimal calculation format, and generate and provide a report containing at least one visual element for the processed data in the form of an Excel spreadsheet.

[0044] Data in the form of an Excel spreadsheet is data created in Microsoft's program Excel, which can be displayed in a table format separated by rows and columns, and allows data to be processed in each cell.

[0045] The data processing and visual report generation device (100) may be a self-contained server or a cloud server for providing data processing and visual report generation services according to the present invention, or it may be a peer-to-peer (P2P) set of distributed nodes.

[0046] The data processing and visual report generation device (100) can send data to an external device or receive data from an external device using a network.

[0047] The user terminal (200) can be connected to the data processing and visual report generation device (100) via a network and can receive the data processing and visual report generation service according to the present invention from the data processing and visual report generation device (100).

[0048] For example, a user terminal (200) may access a website or install an application to receive a service according to the present invention. The user terminal (200) may exchange data through the website or the application.

[0049] For example, the user terminal (200) may be a terminal held by a corporate manager.

[0050] For example, the user terminal (200) can access a site provided by the data processing and visual report generation device (100) to input data in the form of an Excel spreadsheet, receive a recommendation for an optimal calculation format from the data processing and visual report generation device (100), receive a recommendation for at least one piece of data in the form of an Excel spreadsheet capable of calculation, receive a user interface for generating a calculation format, or receive a report containing the processed data in the form of an Excel spreadsheet.

[0051] The database server (300) can be connected to the data processing and visual report generation device (100) via a network and can receive and store data in the form of an Excel spreadsheet from the data processing and visual report generation device (100).

[0052] The database server (300) is a conventional database (DB) for storing data, is equipped with a DBMS for managing data, and can perform operations such as storing, deleting, and searching data through a query.

[0053] For example, the database server (300) is a commercial database and can perform data query services using general query functions for processing datasets.

[0054] The data processing and visual report generation system (10) according to one embodiment of the present invention has the advantageous effect of maximizing the efficiency of data processing and increasing work efficiency by storing data in the form of an Excel spreadsheet input by a user in a database, performing automatic calculation processing according to an optimal calculation format, and further generating and providing a report including the calculated data.

[0056] FIG. 2 is a control block diagram of a data processing and visual report generation device according to one embodiment of the present disclosure.

[0057] Referring to FIG. 2, a data processing and visual report generation device (100) according to one embodiment of the present disclosure may include a processor (110), a communication module (120), a memory (130), and a debugging module (140).

[0058] The components illustrated in FIG. 2 are not essential for implementing the data processing and visual report generating device (100) according to the present disclosure, so the data processing and visual report generating device (100) described in this specification may have more or fewer components than the components listed above.

[0059] The processor (110) can perform data processing and visualization processes according to the present invention.

[0060] The processor (110) may be implemented with a memory that stores data for an algorithm or a program that reproduces the algorithm for controlling the operation of components within the device, and at least one processor (not shown) that performs the aforementioned operation using the data stored in the memory. In this case, the memory and the processor may each be implemented as separate chips. Alternatively, the memory and the processor may be implemented as a single chip.

[0061] In addition, the processor (110) can control one or a combination of the components described above in order to implement various embodiments according to the present disclosure described in FIGS. 2 to 8 below on the device.

[0062] The processor (110) can build a database by storing first data in the form of an Excel spreadsheet received from a user terminal through a communication module (120) in a database server, analyze the data characteristics of the first data, search for second data that can be mutually operated with the first data among the data stored in the database based on the data characteristics of the first data, process the first data and the second data into third data according to a pre-set operation format, and generate a report including at least one visual element for the third data.

[0063] In addition, the processor (110) can identify a calculation format that is repeatedly processed according to the data characteristics in the form of an Excel spreadsheet stored in the database, set it as an automatic calculation format according to the data characteristics, and process the first data and the second data into the third data according to the automatic calculation format corresponding to the data characteristics of the first data.

[0064] Additionally, the processor (110) may provide a user interface to the user terminal that provides a manipulation function for selecting at least one operation value in each category of input data, output data, data preprocessing, and data integration, so that it is displayed on the screen of the user terminal, or, if the user interface is installed on the user terminal, control the user interface to be displayed on the screen of the user terminal so that the at least one operation value can be selected through the user interface.

[0065] Additionally, the processor (110) can combine operation values ​​selected through the user interface to set a user-defined operation format, and process the first data and the second data into the third data according to the user-defined operation format.

[0066] Additionally, the processor (110) can identify a computational format that can be computed between the first data and the second data and set it as a recommended computational format, and can process the first data and the second data into the third data according to the recommended computational format.

[0067] Additionally, the processor (110) may provide the searched plurality of second data to the user terminal so that, when a plurality of the second data are searched, the second data to be processed with the first data among the searched plurality of second data can be selected.

[0068] Additionally, the processor (110) can process the first data and the second data selected through the user terminal into the third data according to any one of an automatic calculation format, a user-specified calculation format, and a recommended calculation format.

[0069] Additionally, the processor (110) can analyze the data features including at least one of the scale, category value, and text of the data.

[0070] The communication module (120) may include one or more components that enable communication with an external device, and may include, for example, at least one of a wired communication module, a wireless communication module, a short-range communication module, and a location information module.

[0071] The wired communication module may include various wired communication modules such as a Local Area Network (LAN) module, a Wide Area Network (WAN) module, or a Value Added Network (VAN) module, as well as various cable communication modules such as USB (Universal Serial Bus), HDMI (High Definition Multimedia Interface), DVI (Digital Visual Interface), RS-232 (recommended standard 232), power line communication, or POTS (plain old telephone service).

[0072] In addition to Wi-Fi modules and WiBro (Wireless broadband) modules, the wireless communication module may include wireless communication modules that support various wireless communication methods such as GSM (global System for Mobile Communication), CDMA (Code Division Multiple Access), WCDMA (Wideband Code Division Multiple Access), UMTS (universal mobile telecommunications system), TDMA (Time Division Multiple Access), LTE (Long Term Evolution), 4G, 5G, and 6G.

[0073] The wireless communication module may include a wireless communication interface comprising an antenna and a transmitter that transmit a mobile communication signal. Additionally, the wireless communication module may further include a signal conversion module that modulates a digital control signal output from the processor (110) through the wireless communication interface into an analog wireless signal under the control of the processor (110).

[0074] A short-range communication module is for short-range communication and can support short-range communication by using at least one of Bluetooth™, RFID (Radio Frequency Identification), Infrared Data Association (IrDA), UWB (Ultra Wideband), ZigBee, NFC (Near Field Communication), Wi-Fi (Wireless-Fidelity), Wi-Fi Direct, and Wireless USB (Wireless Universal Serial Bus) technologies.

[0075] The location information module is a module for obtaining the location (or current location) of the device according to the present disclosure, and representative examples thereof include a Global Positioning System (GPS) module or a Wireless Fidelity (WiFi) module. For example, if a GPS module is utilized, the location of the device can be obtained using signals sent from GPS satellites. As another example, if a Wi-Fi module is utilized, the location of the device can be obtained based on information from a Wireless Access Point (AP) that transmits or receives wireless signals from the Wi-Fi module. If necessary, the location information module may perform any of the functions of other modules of the communication unit to obtain data regarding the location of the device, either substituted or additionally. The location information module is a module used to obtain the location (or current location) of the device, and is not limited to a module that directly calculates or obtains the location of the device.

[0076] The memory (130) can store data supporting various functions of the device and programs for the operation of the processor (110), and can store input / output data, and can store a number of application programs (or applications) running on the device, data for the operation of the device, and instructions. At least some of these application programs can be downloaded from an external server via wireless communication.

[0077] Such memory (130) may include at least one type of storage medium among flash memory type, hard disk type, SSD type (Solid State Disk type), SSD type (Silicon Disk Drive type), multimedia card micro type, card type memory (e.g., SD or XD memory, etc.), RAM (random access memory; RAM), SRAM (static random access memory), ROM (read-only memory; ROM), EEPROM (electrically erasable programmable read-only memory), PROM (programmable read-only memory), magnetic memory, magnetic disk, and optical disk. Additionally, the memory (130) may be a database that is separated from the device but connected via wired or wireless connection.

[0078] The debugging module (140) can detect and debug errors occurring in the data processing or visualization process performed by the processor (110).

[0079] For example, the debugging module (140) is equipped with a debugging program to collect error information occurring in the processor (110), and when an error occurs, it corrects the error or transmits it to the developer system via a service such as SMS, thereby enabling the developer to analyze the error and achieve process stabilization.

[0080] At least one component may be added or removed in response to the performance of the components shown in FIG. 2. Additionally, it will be readily understood by those skilled in the art that the relative positions of the components may be changed in response to the performance or structure of the system.

[0081] Meanwhile, each component illustrated in Figure 2 refers to a software and / or hardware component such as a Field Programmable Gate Array (FPGA) and an Application Specific Integrated Circuit (ASIC).

[0083] FIG. 3 is a flowchart of a method for data processing and visual report generation according to one embodiment of the present disclosure.

[0084] Referring to FIG. 3, a method for data processing and visual report generation according to one embodiment of the present disclosure may include the steps of: a processor (110) storing first data in the form of an Excel spreadsheet in a database server (300) to build a database (S10); analyzing data characteristics of the first data (S20); searching for second data that can be mutually operated with the first data in the database based on the data characteristics of the first data (S30); processing the first data and the second data into third data (S40); and generating a report including at least one visual element for the third data (S50).

[0085] The step (S10) of the processor (110) storing the first data in the form of an Excel spreadsheet in the database server (300) to build a database may be a step in which the processor (110) receives the first data in the form of an Excel spreadsheet from the user terminal (200) through the communication module (120) and stores the received first data in the database server (300) to build a database.

[0086] The step (S10) of the processor (110) storing the first data in the form of an Excel spreadsheet in the database server (300) to build a database may include the step of structuring the first data.

[0087] For example, the processor (110) can process error parts such as unique, blank, type, and blank appearing in the first data so that the first data can be databased.

[0088] The processor (110) can build a database by standardizing the first data and storing it in the database server (300).

[0089] The step (S20) in which the processor (110) analyzes the data features of the first data may be a step in which the processor (110) analyzes the data features including at least one of the scale, category value, and text of the first data stored in the database server (300).

[0090] The data scale is a range of cells within the sheet where values ​​are recorded, and may include, for example, the cell where recording started and the cell where recording ended.

[0091] Category values ​​are information classified based on various business processes of an enterprise, and categories having the same nature can be classified into a single category value; for example, a category value may include at least one of finance, human resource management, manufacturing, supply chain, service, and procurement. These category values ​​may be set differently for each enterprise.

[0092] The text is text that is read out of a cell and may be a specific text set in the system (10), for example, the specific text may be text that can identify a category value and may include at least one of a branch, card, incentive, and employee.

[0093] For example, the processor (110) can extract data features including at least one of a data scale, a category value, and text from the first data, and store the first data and the extracted data features in a database server (300) by matching them.

[0094] The step (S30) in which the processor (110) searches for second data that can be mutually operated with the first data in a database based on the data characteristics of the first data may be a step of searching for data in the database that has the same characteristics as at least one of the scale, category value, and text of the first data as second data.

[0095] A detailed explanation regarding this will be provided later with reference to Fig. 4.

[0096] The step (S40) in which the processor (110) processes the first data and the second data into the third data may be a step of processing the first data and the second data into the third data according to any one of an automatic calculation format, a user-defined calculation format, and a recommended calculation format.

[0097] Automatic calculation formats can be calculation formats that are processed repeatedly based on data characteristics.

[0098] A custom operation form can be an operation form created directly by the user through the user interface.

[0099] The recommended operation format may be an operation format capable of performing operations between the first data and the second data.

[0100] A detailed explanation regarding this will be provided later with reference to FIGS. 5 to 9.

[0101] The step (S50) of the processor (110) generating a report including at least one visual element for the third data may be a step of generating a report including at least one visual element among a graph, a table, and a picture representing the third data.

[0102] For example, the processor (110) can receive a report format from a user terminal (200) through a communication module (120). The report format may be specified to include at least one category according to user specifications, and may be, for example, an insight report or a report in the form of an Excel format.

[0103] The processor (110) can transmit the generated report to the user terminal (200) through the communication module (120).

[0105] Figure 4 is a detailed flowchart of step S30 shown in Figure 3.

[0106] Referring to FIG. 4, the step (S30) of the processor (110) searching for second data that can be mutually operated with the first data in a database based on the data characteristics of the first data may include the step (S31) of transmitting the second data to a user terminal (200) through a communication module (120), and the step (S32) of receiving a selection of the second data to be operated with the first data through the user terminal (200).

[0107] The processor (110) can retrieve at least one second data having data characteristics similar to the data characteristics of the first data in the database.

[0108] For example, the processor (110) can use a fingerprint method to search for at least one second data having data features similar to the data features of the first data in a database. In one embodiment, the fingerprint method can measure the similarity between two data by measuring the distance using Eucldean distance, Minkowski distance, or Mahalanobis distance. In another embodiment, the fingerprint method can measure the similarity between two data by measuring the coefficient using Cosine Similarity, Simple Matching Coefficient, or Jaccard Coefficient.

[0109] For example, the processor (110) can search for multiple second data in a database. The minimum number of second data searches can be pre-set to multiple in the system. In one embodiment, the minimum number of second data searches can be set according to the frequency of occurrence of category values ​​included in the data characteristics of the first data, the importance score set in the system, etc. For example, the higher the frequency of occurrence or the importance score, the higher the minimum number of second data searches can be set to increase the accuracy of computation processing between data. In addition, the processor (110) may relax the similarity measurement score or apply additional data characteristic variables until the second data according to the minimum number of searches is found.

[0110] The processor (110) can search for second data according to the minimum number of searches in the database and transmit the searched multiple second data to the user terminal (200) through the communication module (120).

[0111] The processor (110) can receive a selection from the user through the user terminal (200) of at least one second data to be processed with the first data among a plurality of second data.

[0113] Figures 5 to 7 are detailed flowcharts of step S40 shown in Figure 3.

[0114] Referring to FIG. 5, the step (S40) in which the processor (110) processes the first data and the second data into the third data may include the step of identifying a processing format that is repeatedly processed according to data characteristics (S411), the step of setting an automatic processing format according to data characteristics (S412), the step of identifying an automatic processing format corresponding to the data characteristics of the first data (S413), and the step of processing the first data and the second data into the third data according to the identified automatic processing format (S414).

[0115] For example, the processor (110) can set an operation to calculate the sum between data as an automatic operation format for the data feature when the text among the data features includes the text "monthly". When the first data is input and the data feature of the first data includes the text "monthly", the processor (110) can process the first data and the second data according to the automatic operation format to calculate the sum between the first data and the second data.

[0116] Referring to FIG. 6, the step (S40) in which the processor (110) processes the first data and the second data into the third data may further include the step (S421) of providing a user interface for generating a calculation form to a user terminal (200), the step (S422) of setting a user-specified calculation form by combining calculation values ​​selected through the user interface, and the step (S423) of processing the first data and the second data into the third data according to the user-specified calculation form.

[0117] For example, the processor (110) can receive each category of operation value of an operation format by providing a user interface for selecting at least one operation value in each category of input data, output data, data preprocessing, and data integration.

[0118] Referring to FIG. 7, the step (S40) of processing the first data and the second data into the third data may include the step of identifying a computational format that can be computed between the first data and the second data (S431), the step of setting the identified computational format as a recommended computational format (S432), the step of transmitting the recommended computational format to a user terminal (200) (S433), the step of receiving a selection of the recommended computational format through the user terminal (200) (S434), and the step of processing the first data and the second data into the third data according to the selected recommended computational format (S435).

[0120] FIGS. 7 and FIGS. 8 are examples of screens output from a user terminal according to one embodiment of the present disclosure.

[0121] Referring to FIG. 7, the user terminal (200) can output a screen for selecting the second data (D2) to be processed with the first data.

[0122] The processor (110) can search for multiple second data (D2) in a database and provide them to a user terminal (200), and can receive a selection of the second data (D2) to be processed from the user through an output screen such as FIG. 7.

[0123] The processor (110) can process the selected second data (D2) into third data (D3) according to any one of the automatic calculation format, user-defined calculation format, and recommended calculation format.

[0124] Referring to FIG. 8, the user terminal (200) can output a user interface for generating a user-specified operation format.

[0125] A user interface for creating a custom operation format may include a first category (C1) for selecting input data, a second category (C2) for selecting an output data type, a third category (C3) for selecting a data preprocessing method, and a fourth category (C4) for selecting a data integration method.

[0126] The first category (C1) can select the operation values ​​of the first data and the second data as input data to be processed.

[0127] The second category (C2) can select an operation value in the form of output data, such as the form of data values ​​for each row cell of the third data, the form of data values ​​for each column cell, etc.

[0128] The third category (C3) can select operation values ​​such as cleaning, masking, and replacement as a preprocessing method for the first data and the second data.

[0129] The fourth category (C4) is a method of integrating the first data and the second data, and can select operation values ​​such as join, union, select, pivot, and filter.

[0130] The processor (110) can receive operation values ​​for each of the first category (C1) to the fourth category (C4) through a user interface such as FIG. 8, and can create a custom operation form by combining the selected operation values.

[0131] This type of user interface has the advantageous effect of modularizing the data processing method, enabling users to manage and process data even without programming knowledge.

[0133] Meanwhile, the disclosed embodiments may be implemented in the form of a recording medium that stores instructions executable by a computer. The instructions may be stored in the form of program code and, when executed by a processor, may generate a program module to perform the operation of the disclosed embodiments. The recording medium may be implemented as a computer-readable recording medium.

[0134] Computer-readable recording media include all types of recording media that store instructions that can be decoded by a computer. Examples include ROM (Read Only Memory), RAM (Random Access Memory), magnetic tape, magnetic disk, flash memory, optical data storage devices, etc.

[0135] As described above, the disclosed embodiments have been explained with reference to the attached drawings. Those skilled in the art will understand that the present disclosure may be practiced in forms different from the disclosed embodiments without changing the technical spirit or essential features of the present disclosure. The disclosed embodiments are illustrative and should not be interpreted restrictively. Explanation of the symbols

[0137] 10: Data Processing and Visual Report Generation System 100: Data processing and visual report generation device 200: User terminal 300: Database Server

Claims

Claim 1 A data processing and visual report generation device comprising: a communication module that communicates with a user terminal; and a processor that performs data processing and visualization processes, wherein the processor stores first data in the form of an Excel spreadsheet received from the user terminal in a database server to build a database, analyzes the data characteristics of the first data, searches for second data among the data stored in the database that can be mutually processed with the first data based on the data characteristics of the first data, processes the first data and the second data into third data according to a pre-set calculation format, and generates a report including at least one visual element for the third data, wherein if the data characteristics of the first data include specific text capable of identifying a category value classified according to a business process, the specific operation between the data is set as an automatic calculation format for the data characteristics of the first data, and processes the first data and the second data into the third data according to the automatic calculation format. Claim 2 A data processing and visual report generation device according to claim 1, wherein the processor identifies a calculation format that is repeatedly processed according to data characteristics in the form of an Excel spreadsheet stored in the database, sets it as an automatic calculation format according to data characteristics, and processes the first data and the second data into the third data according to the automatic calculation format corresponding to the data characteristics of the first data. Claim 3 A data processing and visual report generation device according to claim 1, wherein the processor provides a user interface to the user terminal for selecting at least one operation value in each category of input data, output data, data preprocessing, and data integration. Claim 4 A data processing and visual report generation device according to paragraph 3, wherein the processor combines operation values ​​selected through the user interface to set a user-defined operation format, and processes the first data and the second data into the third data according to the user-defined operation format. Claim 5 A data processing and visual report generation device according to claim 1, wherein the processor identifies an operable operation format between the first data and the second data and sets it as a recommended operation format, and processes the first data and the second data into the third data according to the recommended operation format. Claim 6 A data processing and visual report generation device according to claim 1, wherein the processor provides the searched plurality of second data to the user terminal so that, when a plurality of the second data are searched, the second data to be processed with the first data among the searched plurality of second data can be selected, wherein the minimum number of searched second data is pre-set to a plurality based on the data characteristics of the first data, and the second data is searched based on a similarity measurement between the data stored in the database and the first data, and the score for the similarity measurement is adjusted to be relaxed until the number of searched second data equal to the minimum number of searched second data is searched. Claim 7 In claim 6, the processor is a data processing and visual report generation device that processes the first data and the second data selected through the user terminal into the third data according to any one of an automatic calculation format, a user-specified calculation format, and a recommended calculation format. Claim 8 In claim 1, the processor is a data processing and visual report generation device that analyzes data features including at least one of a scale, category value, and text of the data. Claim 9 A data processing and visual report generation device according to claim 1, further comprising a debugging module that detects and debugs errors occurring in the data processing or visualization process of the processor. Claim 10 A method for data processing and visualization generation, comprising a device including a processor that performs data processing and visualization processes, the method comprising: a step of constructing a database by storing first data in the form of an Excel spreadsheet received from a user terminal in a database server; a step of analyzing data characteristics of the first data; a step of searching for second data among the data stored in the database that is capable of mutual operation with the first data based on the data characteristics of the first data; a step of processing the first data and the second data into third data according to a pre-set operation format; and a step of generating a report including at least one visual element for the third data; wherein the step of processing operations comprises, if the data characteristics of the first data include specific text capable of identifying category values ​​classified according to a business process, a step of setting a specific operation between data as an automatic operation format for the data characteristics of the first data; and a step of processing the first data and the second data into the third data according to the automatic operation format.

Images