JP2003167880A - Statistical information totalizer - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To advance area analyzing work by displaying data existing in another system such as a sales amount and a share of a designated store together with map information by designating the store on a map. <P>SOLUTION: On the indicated store, a display file is made by acquiring the data possessed by the other system such as a POS system. Data desired to be displayed together with the map information is indicated by this display file, and is displayed on a designated area on the map to support analytical work. <P>COPYRIGHT: (C)2003,JPO

Description

Description: BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a technique for handling map information and various kinds of statistical information on the map. The present invention
In particular, it is used for information processing technology called trade area analysis and area analysis.
Information obtained by summing up various types of statistical information is displayed, and is used for an information processing apparatus and an information processing method for predicting the number of customers expected for a store, the purchase amount, etc., and analyzing stores and areas. 2. Description of the Related Art Map information is provided on a display device of an information processing apparatus, comprising map information, the number of inhabitants, population structure, store information, and statistical data of various public institutions such as schools and stores. 2. Description of the Related Art There is known an area information system which indicates a store or a candidate store on the map and sets a trade area of the store based on the statistical data, analyzes the trade area, and supports sales activities. . [0003] An example of the configuration of the area information system will be described with reference to FIG. The configuration shown in FIG. 6 includes an information processing apparatus 1 that performs an area analysis process, and various databases 2 to 6 that store data for the analysis process. The database includes a map information database 2, a database 3 for storing basic statistical information I, a database 4 for storing basic statistical information II, a market information database 5 for storing market information on product categories, and information such as store addresses. Store database 6 to be accumulated
And [0004] The map information database 2 stores, for example, road maps and map information provided by map information providers. As the basic statistical information, basic statistical information I provided by a public institution and basic statistical information II which is information of a public institution are accumulated. The basic statistical information I is information such as a national census, a basic resident register, commercial statistics, national census office statistics, and link data. For example, information on the population, the number of households, the age structure, the household structure, This is information on industrial shipment statistics. The information of the basic statistical information I is divided into cities, municipalities, towns and towns, and the map is divided into meshes and stored as data for each of the divided sections. The sections of this mesh are configured in units of 500 m, 1 km, 2 km, 4 km, etc., and are stored as information for each section.
It is stored in the database 3 in a usable form. The basic statistical information I is provided by the Geospatial Information Authority of Japan, and when performing information processing, various publicly provided data are purchased and used. The basic statistical information II is the basic statistical information I
Are stored in the database 4, for example, information such as the location of supermarkets and schools, addresses, the number of students, and information on nearby transportation means, such as the number of passengers at stations. The market information is information on a market size for each product category and population of a product category target, and information provided by a market research company or the like is used. The information in the store database 6 is information such as a store address and a telephone number, and is the basis of information plotted and displayed on a map. Each time a new store is opened, the information in the store database 6 is updated. Using the area information system shown in FIG. 1, a certain area is designated and map information is displayed on a display means.
An example will be described in which a store to be analyzed is indicated on a map, stores in a designated area are displayed on a display means, and area analysis is performed using an area information system for performing area analysis. [0007] It is assumed that map information of a certain district is designated and displayed on the display means, and the business area of a certain store in this district is analyzed. First, when a store to be analyzed is specified, the position of the store is displayed. With this store as the center, a circle centered on the store as a trade area is drawn for analysis. As a trade area analysis, for the area in the drawn circle, for example, the population, the number of households, the market size is represented by coloration in mesh units, or the population of the age that is the target of the product is represented in coloration by mesh unit, Analyze the characteristics of the business area of the target store. In addition, specify the products to be handled for the specified store, and calculate the sales amount, market share, etc. for each product, etc., and grasp the situation in the area where the store is to be analyzed. Can be. Further, competing stores are also displayed, and statistical data is aggregated and analyzed for a trade area to be analyzed, and problems of individual stores and problems of expanding a store group in an area can be extracted to provide sales support. . [0008] This analysis can be performed not only with mesh data but also on a town block basis. The trade area can be set not only by a circle but also by a curve or an ellipse. It is also possible to specify by a polygon using a straight line, or to set by administrative unit. [0009] By the way, when analyzing the sales, share, etc. of other stores, it is important that the data is also displayed on the map displayed on the display means. It is convenient for proceeding. However, the data to be aggregated is not only the basic statistical information described above, but also various data such as the total sales amount of the store to be analyzed, the sales amount for each product, the total share, the share of the product group, the share for each product, etc. Is desirably displayed. In proceeding with the analysis work, there is a demand for displaying only the desired data in accordance with the instruction of the operator for each of the stores to be analyzed in the analysis data. [0010] However, even if data such as the sales amount for each product, the share of the store, or the data of stores near the same chain store is to be handled in the same way, if they are the same chain store, for example, they will It is provided as POS data collected by the POS system, and the area information system itself does not have the POS data. Also, sales information for each product is originally given as POS data, and is not stored as data to be displayed at the time of trade area analysis by the area information system itself. Also, data on the scheduled delivery date and delivery destination of the product are managed by the delivery management system. As described above, in the area information system, statistics such as sales amount of stores managed by other systems, sales information in units of merchandise, shares, destinations of merchandise, etc., are compiled into statistical data. In an area information system to be performed, it is desired that the area analysis can be further performed by displaying the total result together with the display of the total result. The present invention has been made in such a background. When analyzing a trade area or a sales of a store, the data collected by another system is aggregated together with the aggregation of mesh-like statistical data. It is an object of the present invention to provide a device capable of supporting an analysis work by an area analysis worker (operator) by displaying the display. It is another object of the present invention to provide a device capable of editing and displaying data stored in another system so that the data can be easily displayed on a statistical data totaling device. [0013] The area information system comprises:
It has statistical data sectioned in a mesh form together with the map information, and performs a totaling operation on the data of the set trade area. In addition, the POS system collects sales information of stores as immediate data. Further, the sales management system has data on chain stores performing the same sales plan, and the delivery management system has data on the delivery date and delivery destination of a new product. If you want to display these data of other systems when you are doing business area analysis work using the area information system,
As search information, data held by another system is designated and downloaded from the other system. The downloaded data is edited in a table format by the display file creating means. The display file creation means is an application of spreadsheet software. The display file creation means counts the acquired data and indicates the data to be displayed. For example, if you specify a store and indicate the data to be collected, such as sales information of the store, sales information of each product, etc., the total sales amount of the products of the store, the sales amount by category of products, the share, etc. Is obtained from the POS system, and the display file creation means performs totalizing and editing of the data, and instructs which data is displayed together with the map information in the table. The display instruction in the display file allows the operator to easily instruct the presence / absence of display and the color instruction by clicking while displaying the table. Then, in accordance with a display instruction of the display table, the data totaled for the designated store is displayed as a numerical value in the form of a rectangular table near the store. While viewing the displayed numerical values and the like, the operator proceeds with the area analysis work by giving similar instructions to other stores. That is, a first aspect of the present invention is a storage means for storing map information and statistical data corresponding to the map information, a display means for displaying the map information, and a display means for specifying the map information on the displayed map information. Calculating means for totalizing the statistical data for the stores, wherein the statistical data for each section divided into a mesh on the map is stored, and the calculating means is configured to focus on a designated point on the map. Creation of a display file for displaying data created by another device in a statistical information totaling device including means for totalizing statistical data in an area surrounded by a figure drawn by a curve or a straight line predetermined as a point Means for editing the data specified by the operator and obtained from the other device into a table format and outputting the data to the display means. And features. A second aspect of the present invention is a program for operating an information processing apparatus as the above-described statistical information totalizing apparatus by installing the information processing apparatus on a general-purpose information processing apparatus such as a personal computer.
The program is provided via a storage medium storing a program or a communication line. Embodiments of the present invention will be described below with reference to the drawings. The store information search device used in the embodiment of the present invention has the configuration shown in FIG. 1, and the area information system shown in FIG. 6 is connected to another system via LAN 8. The POS system 9, the sales management system 10, the delivery management system 11, and the like are connected as other systems, and the information processing apparatus 1 can access data of another system and obtains data of the other system. It is possible to download. That is, the information processing apparatus 1 includes an information processing apparatus 1 for performing an area analysis process and various databases 2 to 6 storing data for the analysis process. The database includes a map information database 2, a database 3 for storing basic statistical information I, a database 4 for storing basic statistical information II, a market information database 5 for storing market information on product categories, and information such as store addresses. And a store database 6 to be stored. The information processing apparatus 1 is connected to a display device for displaying map information and other information to an operator, and an input means such as a keyboard for an operator (analysis operator) to perform an operation input. The trade area analysis can be performed while displaying the map information on the device. Here, a feature of the present embodiment is that the information processing apparatus 1 includes a display file creation unit that acquires data in another system and edits the data into a format to be displayed on a display unit. The creation means is capable of editing data specified by the operator and acquired from the other system into a table format and passing the edited data to the display means. Here, the display file creating means 12
Data is acquired from another system such as the POS system 9, the sales management system 10, the delivery management system 11, and edited in a table format so as to be displayed together with the map information on the display means of the information processing apparatus 1, and displayed. The data from the other system edited by the instruction is displayed in a table format or a circular graph. Next, referring to FIGS. 2 and 3, a description will be given of the operation of acquiring data on the sales amount, share, and year-on-year ratio of a specific product from the POS system 9 for a specific store and displaying the data together with map information. FIG. 2 is a flowchart showing the display operation of the aggregated data, and FIG. 3 schematically shows the operation. First, the operator specifies a store to be subjected to area analysis on the map information displayed on the display means.
Alternatively, a store to be analyzed is input by inputting a store code such as a store name or a store number for the store to be subjected to the area analysis (S11, S12). At this time, the radius (or diameter) of the trade area to be set as the area analysis is input to set the trade area to be analyzed, and an instruction is made to aggregate statistical data such as basic statistical information I included in the set trade area. be able to. The store code may be any identification information that can identify the store, such as a store name and a store number. The trade area to be set has a radius (or diameter) of 500 m, 1 km, 1.5 km, and 2 km as the section length or half section length of the mesh.
Etc., or set arbitrarily. The calculation means of the information processing device 1 sets a trade area with a specified radius (diameter) centering on the specified store, and performs a calculation operation of statistical data. When the operator wants to display the data in the POS system and the sales amount, share, and year-on-year data of the desired product at the designated store together with the map information, the operator instructs retrieval and acquisition of the desired data (S13). . By inputting a store code in accordance with this instruction, data such as the sales amount, the share, and the year-on-year ratio of the store in the POS system 9 is acquired (S14). This search is based on the store code used in the area information system, the code indicating the mesh section, the administrative code where the store is located, etc.
Searching can be performed using codes used in the databases 2 to 6 of the area information system. Then, the data of the desired store is acquired from another system, for example, the POS system 9, and downloaded. The downloaded data is edited by the display file creation means and data to be displayed on the display means is specified (S15). The acquired data is edited by the display file creation unit 12. The display file creator 12 edits the acquired data in a table format, temporarily converts the designated data into a table format, performs an aggregation operation, and designates the data to be displayed on the created table. Indicates the data to be displayed together with the map information. Then, the designated data on the table is displayed as the data of the store near the store on the map information (S16). Then, the operator further proceeds with the trade area analysis work while watching this display. FIG. 4 shows an example of a table created by the display file creating means. The table in FIG. 4 (a) is a summary of the product categories, such as disposable diapers, clothing detergents, residential detergents, etc., the sales amount, the market share, and the year-on-year change for the stores A, B, and C. It is. Of these, data of only the disposable diapers for the store A is extracted from the table of FIG. 4B, and FIG. 4C is created for each product category. Here, as shown in FIGS. 4B and 4C, the presence or absence of display in the table,
A column for specifying a display color is provided for each data, and by clicking this column, the presence / absence of display and the display color are specified. When displaying near a store, a rectangular window is provided near the store because the store position is recognized on the map information.
The data items to be displayed and the numerical values are displayed in this window. The displayed result is shown in FIG. As shown in FIG. 5, two items and their numerical values are displayed near the designated store on a map. A numerical value represented by a ratio such as a share can also be represented by a circular graph. Note that the display data can be specified before the totaling. In this case, a totaling item is described, and a specification column for display is specified on a table in which the totalized numerical value is blank, and a totaling instruction may be given later. When it is desired to display common data for a plurality of stores at the same time, the display may be specified on a table in which the data of the plurality of stores are totalized as shown in FIG. Further, this display is possible not only for the store, but also for the administrative boundary and the mesh. The present embodiment can also be realized as a program that functions as the above-described statistical information processing apparatus by installing it in a general-purpose information processing apparatus such as a personal computer. This program can be provided via a storage medium storing the program or a communication network. As described above, according to the present invention, when a trade area is set and an area analysis is performed, information on goods and services handled by the store is simultaneously displayed near the store to be analyzed. Therefore, the analysis worker can efficiently proceed with the analysis work.

BRIEF DESCRIPTION OF THE DRAWINGS FIG. 1 is a diagram showing a configuration of an area information system according to an embodiment of the present invention. FIG. 2 is a flowchart showing a display operation of total data according to the present invention. FIG. 3 is a diagram illustrating an operation of the present invention. FIG. 4 illustrates an example of a display table. FIG. 5 illustrates a display example. FIG. 6 is a diagram showing a configuration example of an area information system. [Description of Signs] 1 Information processing devices 2 to 6 Database 8 LAN 9 POS system 10 Sales management system 11 Delivery management system 12 Display file creation means

Claims (1)

Claims 1. A storage means for storing map information and statistical data corresponding to the map information, a display means for displaying the map information, and a store designated on the displayed map information. Calculating means for summing up the statistical data, wherein the statistical data for each section divided into a mesh on the map is stored, and the calculating means sets a designated point on the map as a center point in advance. In a statistical information totaling device including a unit for totalizing statistical data in an area surrounded by a predetermined curve or a figure drawn with a straight line, a display file creating unit for displaying data created by another device is provided. , The display file creation means,
A statistical information totalizing device comprising means for editing data designated by an operator and obtained from the other device in a table format and outputting the edited data to the display means.