WO2002015049A1 - Summary data visualisation system and method - Google Patents
Summary data visualisation system and method Download PDFInfo
- Publication number
- WO2002015049A1 WO2002015049A1 PCT/NZ2001/000163 NZ0100163W WO0215049A1 WO 2002015049 A1 WO2002015049 A1 WO 2002015049A1 NZ 0100163 W NZ0100163 W NZ 0100163W WO 0215049 A1 WO0215049 A1 WO 0215049A1
- Authority
- WO
- WIPO (PCT)
- Prior art keywords
- data
- representation
- displaying
- interaction
- merchant
- Prior art date
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/02—Marketing; Price estimation or determination; Fundraising
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/26—Visual data mining; Browsing structured data
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/34—Browsing; Visualisation therefor
Definitions
- the invention relates to a summary data visualisation system and method, particularly but not solely designed for use in presenting interactive drill down representations.
- analysis of data has been achieved by running a query on a set of data records stored in a database.
- the merchant or other party first creates a hypothesis, converts this hypothesis to a query, runs the query on the database, and interprets the results obtained with respect to the original hypothesis.
- the invention comprises a data visualisation system comprising: a data value memory in which is maintained an interaction database of interaction data representing interactions between customers and merchants, the interaction data associated with at least one time value;
- a retrieval device arranged to retrieve from the interaction database data representing interactions between customers and merchants and to construct a finite set of data values from the retrieved data
- a display arranged to display a first representation of the data values
- a pointing device enabling a user to select part of the first representation
- the display is further arranged to generate and display a second representation based on the part of the first representation selected by the user.
- the invention comprises A method of data visualisation comprising the steps of:
- interaction data representing interactions between customers and merchants, the interaction data associated with at least one time value
- Figure 1 shows a block diagram of a system in which one form of the invention may be implemented
- FIG. 2 shows the preferred system architecture of hardware on which the present invention may be implemented
- Figure 3 shows a block diagram of a system in which another form of the invention may be implemented
- Figure 4 is a preferred representation generated in accordance with the invention.
- Figure 5 is a flow chart of a preferred form of the invention.
- FIG. 1 illustrates a block diagram of the preferred system 10 in which one form of the present invention may be implemented.
- the system includes one or more clients 20, for example 20A, 20B, 20C, 20E and 20F, which each may comprise a personal computer or workstation described below.
- Each client 20 is interfaced to a workstation 12 as shown in Figure 1.
- Each client 20 could be connected directly to the workstation 12, could be connected through a local area network or LAN, or could be connected through the Internet.
- Clients 20A and 20B for example, are connected to a network 22, such as a local area network or LAN.
- the network 22 could be connected to a suitable network server 24 and communicate with the workstation as shown.
- Client 20C is shown connected directly to the workstation using for example a serial connection or WAP connection.
- Clients 20D, 20E and 20F are shown connected to the workstation through the Internet 26.
- Client 20D is shown as connected to the Internet 26 with a dial-up connection and clients 20E and 20F are shown connected to a network 28 such as a local area network or LAN, with the network 28 connected to a suitable network server 30.
- a network 28 such as a local area network or LAN, with the network 28 connected to a suitable network server 30.
- the preferred system 10 further comprises a data repository 40, for example a data warehouse maintained in a memory. It is envisaged that the data repository may alternatively comprise a single database, a collection of databases, or a data mart.
- the preferred data repository 40 includes data from a variety of sources.
- the data repository may include, for example, interaction data 42 representing interactions between customers and merchants as will be more particularly described below.
- the data repository may also include data from other sources for example census data 44, scan data 46 obtained from scanning bar-codes on products, data from merchant customer databases 48, data from merchant loyalty programmes 50 and/or promotion data 52 held by a merchant or other organisation.
- the personal computer or workstation preferably operates under the control of appropriate operating and application software, and has a data memory 60 connected to a server 62.
- the invention includes a retrieval device or retrieval component 62 which in one form comprises a software implemented query enabling retrieval of data from the data repository 40, and in another form comprises a memory on which the query is installed and operating.
- the data retrieved using the retrieval device 62 is processed with the server 62.
- a display generator 64 which in one form comprises a computer implemented software program generates a display of the data on a client workstation 20, as will be described below.
- a display component (not shown) could comprise a conventional display software module interfaced to the display generator 64 and operable to display data on a client 20. Preferred forms of the display generator computer program are also described below.
- FIG. 2 shows the preferred system architecture of a client 20 or workstation 12.
- the computer system 70 typically comprises a central processor 72, a main memory 74 for example RAM and an input/output controller 76.
- the computer system 70 also comprises peripherals such as a keyboard 78, a pointing device 80 for example a mouse, track ball, touch pad, or cursor key set, a display or screen device 82, a mass storage memory 84 for example a hard disk, floppy disk or optical disc, and an output device 86 for example a printer.
- the system 70 could also include a network interface card or controller 88 and/or a modem 90.
- the individual components of the system 70 could communicate through a system bus 92.
- the invention 12 is arranged to display a contoured representation of data on a screen display of a client workstation 20.
- the invention is arranged to display data representing interactions between customers and merchants.
- a merchant will operate in a commercial premises or store from which a customer purchases goods or services.
- the merchant may, for example, operate a petrol station in one or more geographic locations.
- the merchant may alternatively operate a wagering or betting service, or operate a casino or other gaming facility in which a plurality of gaming machines and stations are positioned in one or more rooms at a common venue.
- the merchant may also operate a warehouse facility, manufacturing facility, carparking premises, telecommunications network or website.
- the merchant may also offer a range of financial or insurance services.
- the merchant does not necessarily need to operate from a commercial premises or store.
- the merchant may operate from strategically placed machines, for example vending machines or amusement machines.
- the merchant may also operate a mail order catalogue service, direct market goods or services, or operate from a website or other electronic medium.
- the interaction data could be stored as a series of records in a relational database.
- Each record may include a merchant identifier used to identify a particular merchant, and where a merchant operates from more than one geographic location, the merchant identifier or some other identifier included in the record may identify the geographic location in which the interaction occurs.
- the record could also include a customer identifier.
- the merchant may, for example, issue an incentive-supported customer loyalty card which is then used by the customer during interactions with the merchant.
- the loyalty card preferably has stored on it a customer identifier and may have stored other data, for example residential address and family size of the customer. Such data is stored in loyalty programme database 50 and could be migrated to the data repository 40.
- the record could also include data such as the date and/or time at which the interaction between the customer and the merchant took place.
- the date and/or time value is an example of a time value with which each interaction is associated.
- the interaction record could include the time an interaction commenced and the time an interaction ended.
- the duration of each duration could then be calculated from the difference in the two time values to enable statistics to be displayed, as will be described below.
- the duration of the interaction could be stored in the interaction data set for ease of access, or could simply be calculated when needed.
- the time values could include for example the day of the week and/or the hour time interval of the interaction. It is also envisaged that the record could include the cash value of the transaction.
- the merchant may have installed apparatus for reading the bar-codes of products sold.
- each product may be identified by a code assigned by the merchant which is recorded at the time of sale.
- Such data is stored in a scan database 46 and could be migrated to the data repository 40.
- the record may also include a suitable goods or services identifier, for example a product or service code to identify which goods or services were involved in the interaction.
- the interaction data is migrated to the data repository 40, generally by way of daily updates or in real time. It is advantageous to cleanse, catalogue and validate the interaction data during migration of the data to the data repository and this task could be performed by either the merchant or by a third party.
- the data could be linked to other sources of data for subsequent retrieval, for example the census data 44, scan data 46, data from the merchant customer database 48, data from a merchant loyalty programme 50 and/or promotion data 52 held by the merchant.
- the data repository 40 could be maintained by a merchant or alternatively could be maintained by a third party. Updates to the data repository could be carried out by the merchant directly, or alternatively the merchant could provide batched data to a third party for updating the data. Alternatively, a third party could be entrusted with the task of collecting the interaction data and migrating the data to the data repository.
- Figure 3 illustrates a block diagram of the preferred Internet-based system 100 in which the present invention may be implemented.
- the system is similar to that of Figure 1 with the exception that the data repository 40 could be connected to the Internet 26.
- the system further comprises customer and merchant workstations. There could be one or more customers 102 for example customers 102 A, 102B and 102C, which may each operate a personal computer or workstation as described above. Each customer 102 is interfaced to the Internet 26.
- each customer 102 could be connected directly to the Internet as shown with 102C with a suitable dial-up connection or could be connected through a local area network or LAN as is the case with customers 102 A and 102B which are connected to local area network or LAN 104, connected to a network server 106, and communicate with the Internet 26 as shown.
- the system also includes one or more web servers 106, for example 106A and 106B.
- Each web server 106 is connected to the Internet 26 as shown.
- Each web server 106 preferably comprises a personal computer or workstation operating under the control of suitable software.
- Connected to web server 106 are one or more merchant computers or workstations 108, for example 108 A, 108B and 108C. Two or more merchants could be connected to the same web server as is the case with merchant 108 A and 108B both connected to web server 106A.
- merchant 108C for example, could be connected to dedicated web server 106B.
- the merchant 108 could include an individual, a company or organisation and would typically operate a website or other electronic medium through which customer 102 purchases goods or services.
- the merchant may alternatively operate an on-line casino, gambling or other gaming facility.
- the merchant could also offer transport and delivery, financial or banking services.
- Customer 102 could include an individual, a company, or an organisation. The customer could be a purchaser of goods or services from the merchant or could simply be visiting a website operated by the merchant. An interaction between a customer 102 and a merchant 108 could be initiated by either the customer or by the merchant. As the customer 102 interacts with merchant 108, the interaction generates interaction data which is collected and stored in data repository 40.
- Typical data records could include, for example, a merchant identifier.
- This merchant identifier could be used to identify a particular merchant and could comprise the universal resource locator (URL) of a website operated by the merchant, or an Internet protocol (IP) address for the merchant.
- URL universal resource locator
- IP Internet protocol
- the record could include a customer identifier.
- the customer identifier could include the IP address or other network address of the customer 102.
- the customer identifier could alternatively comprise a character string assigned to the customer by the merchant during a registration process with a facility for the customer to supply a user name and password, to initiate an interaction in the known way.
- the record could also include the universal resource locator (URL) of a web page visited by the customer 102 during an interaction.
- the record could include other information such as the date and/or time at which the interaction between the customer and the merchant took place, the cash value of any transaction if applicable, and a goods/services identifier where a transaction has taken place. It is envisaged that each new URL visited by a customer, for example each new page visited in a merchant website, generates a new interaction record. By retrieving and storing these records by date and time, it is possible to calculate the number of customers visiting a particular website and the average time spent viewing a particular web page or page cluster, as will be more particularly described below.
- the system may present data to the user based on one of a number of key performance indicators or KPIs which could include total sales, gross profit, net profit, gross margin return on inventory investment (GMROII), net margin return on inventory investment (NMROII), return on net asset (RONA), loyalty sales data, time spent viewing a particular website and/or a web page visitation percentage.
- KPIs key performance indicators or KPIs which could include total sales, gross profit, net profit, gross margin return on inventory investment (GMROII), net margin return on inventory investment (NMROII), return on net asset (RONA), loyalty sales data, time spent viewing a particular website and/or a web page visitation percentage.
- KPIs key performance indicators or KPIs which could include total sales, gross profit, net profit, gross margin return on inventory investment (GMROII), net margin return on inventory investment (NMROII), return on net asset (RONA), loyalty sales data, time spent viewing a particular website and/or a web page visitation percentage.
- GMROII gross
- Figure 4 illustrates at 200 one example of a display generated by the system where the merchant operates a website or other facility.
- the representation 200 in turn comprises a first representation 202 of data values.
- the representation 202 is preferably arranged in a grid of individual cells, each cell representing website usage data values during a pre- specified time interval.
- Representation 202 could show, for example, website usage of a particular website over a week, grouped in one hour blocks.
- Each cell or block is preferably colour-coded to represent the number of hits the site has received and it is envisaged that a suitable legend 204 relating colours to actual numbers could be displayed adjacent the representation 202.
- the system may further comprise a cursor 206, the position of which may be manipulated by a user with a suitable pointing device 80 from Figure 2. As shown in Figure 4, the user has selected the cell representing a one hour time period commencing at 10.00pm on Saturday.
- the system could further comprise a second representation 208 or 210 or combination of representations 208 and 210.
- Representation 208 could comprise a histogram or bar graph showing the number of website hits for the one hour time period commencing at 1 .00pm for each of the days Monday through Sunday.
- the histogram 208 is preferably updated to correspond with the cell selected by the user. For example, should the user select Thursday 9.00am, the histogram 208 could preferably be updated and displayed, showing the number of website hits from Monday through Sunday at 9.00am.
- the system is configured to generate and display the representation 208 automatically based on the part or cell of the representation 202 selected by the user.
- the user will simply move the cursor using a pointing device to a different position without requiring separate mouse clicks or other action.
- the representation 200 could further comprise one or more further representations for example histogram 210 showing all of the hits for a particular day. As shown in Figure 4, the user has selected the cell representing Saturday at 10.00pm with cursor 206. The histogram 210 shows the website hits for each hour on Saturday.
- each cell represents a finite set of data values.
- Each cell is displayed at a set of co-ordinates relative to the time value or time values associated with each data value. For example, the cell representing a time period on Monday commencing at 3 am is positioned to the left of the same time period commenced on Wednesday. The cell representing the time interval on Wednesday commencing at 9am is displayed below the above mentioned time period commencing at 3 am on Wednesday.
- Each of representations 208 and 210 are displayed at sets of co-ordinates relative to the time value or time values associated with the individual cell values. For example, the number of hits on a Saturday is presented in histogram 208 at substantially the same x coordinates as the cells representing website hits on Saturday. Similarly, data values for hits at 4pm in representation 210 are displayed substantially at the same y co-ordinates as the cell values of the time period commencing at 4pm for the days Monday through to Sunday. In this way, the user can be provided with a summary of operational parameters of some aspect of an application or business operation. The system may summarise several dimensions simultaneously, and present the summarised data visually.
- Figure 5 illustrates the preferred method of operation of the invention.
- data is retrieved from the data repository 40 using a suitable query.
- the retrieved data could include data representing interactions between customers and merchants, where this data is stored in the data repository 40.
- a set of data values is constructed from the retrieved data.
- This set of data values could include, for example, the number of hits experienced at a particular website over a pre-defined period.
- the set of data values could be stored in data value memory 60 to increase efficiency of the system as indicated at 304, which could comprise volatile main RAM or non-volatile mass storage of the workstation on which the invention is implemented.
- step 306 the set of data values are retrieved from the volatile or non- volatile data memory and as shown at 308, a first representation is generated and displayed on a client workstation 20.
- the cursor position is retrieved and as shown at 312, a second representation of data values is generated and displayed based on the cursor position retrieved at step 310.
- the cursor current position is retrieved at step 310 and the second representation updated based on the new cursor position. It will be appreciated that the uses and potential areas of application of the system are wide and varied. Merchants and other organisations do not need to follow the traditional approach of forming a hypothesis in advance and then verifying the hypothesis, although the representations generated by the system may be useful for verifying a particular hypothesis. The system presents data in an easily interpreted and intuitive manner which may be useful in identifying unexpected trends in the data.
Abstract
Description
Claims
Priority Applications (3)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
AU2001282720A AU2001282720A1 (en) | 2000-08-11 | 2001-08-10 | Summary data visualisation system and method |
EP01961458A EP1316031A1 (en) | 2000-08-11 | 2001-08-10 | Summary data visualisation system and method |
US10/364,659 US20030189595A1 (en) | 2001-08-10 | 2003-02-11 | Summary data visualisation system and method |
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
NZ506304 | 2000-08-11 | ||
NZ506304A NZ506304A (en) | 2000-08-11 | 2000-08-11 | Summary data visualisation system and method for interaction data |
Related Child Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US10/364,659 Continuation US20030189595A1 (en) | 2001-08-10 | 2003-02-11 | Summary data visualisation system and method |
Publications (1)
Publication Number | Publication Date |
---|---|
WO2002015049A1 true WO2002015049A1 (en) | 2002-02-21 |
Family
ID=19928039
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
PCT/NZ2001/000163 WO2002015049A1 (en) | 2000-08-11 | 2001-08-10 | Summary data visualisation system and method |
Country Status (4)
Country | Link |
---|---|
EP (1) | EP1316031A1 (en) |
AU (1) | AU2001282720A1 (en) |
NZ (1) | NZ506304A (en) |
WO (1) | WO2002015049A1 (en) |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2003073323A1 (en) * | 2002-02-27 | 2003-09-04 | Compudigm International Limited | Data visualisation system and method |
WO2008020182A1 (en) * | 2006-08-18 | 2008-02-21 | Fidessa Latent Zero Limited | Display of market information |
US8235811B2 (en) | 2007-03-23 | 2012-08-07 | Wms Gaming, Inc. | Using player information in wagering game environments |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5566291A (en) * | 1993-12-23 | 1996-10-15 | Diacom Technologies, Inc. | Method and apparatus for implementing user feedback |
US5659724A (en) * | 1992-11-06 | 1997-08-19 | Ncr | Interactive data analysis apparatus employing a knowledge base |
US5930773A (en) * | 1997-12-17 | 1999-07-27 | Avista Advantage, Inc. | Computerized resource accounting methods and systems, computerized utility management methods and systems, multi-user utility management methods and systems, and energy-consumption-based tracking methods and systems |
WO2000016226A1 (en) * | 1998-09-14 | 2000-03-23 | Foliofn, Inc. | Method and apparatus for managing taxable events within a portfolio |
-
2000
- 2000-08-11 NZ NZ506304A patent/NZ506304A/en not_active IP Right Cessation
-
2001
- 2001-08-10 WO PCT/NZ2001/000163 patent/WO2002015049A1/en not_active Application Discontinuation
- 2001-08-10 EP EP01961458A patent/EP1316031A1/en not_active Withdrawn
- 2001-08-10 AU AU2001282720A patent/AU2001282720A1/en not_active Abandoned
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5659724A (en) * | 1992-11-06 | 1997-08-19 | Ncr | Interactive data analysis apparatus employing a knowledge base |
US5566291A (en) * | 1993-12-23 | 1996-10-15 | Diacom Technologies, Inc. | Method and apparatus for implementing user feedback |
US5930773A (en) * | 1997-12-17 | 1999-07-27 | Avista Advantage, Inc. | Computerized resource accounting methods and systems, computerized utility management methods and systems, multi-user utility management methods and systems, and energy-consumption-based tracking methods and systems |
WO2000016226A1 (en) * | 1998-09-14 | 2000-03-23 | Foliofn, Inc. | Method and apparatus for managing taxable events within a portfolio |
Cited By (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2003073323A1 (en) * | 2002-02-27 | 2003-09-04 | Compudigm International Limited | Data visualisation system and method |
WO2008020182A1 (en) * | 2006-08-18 | 2008-02-21 | Fidessa Latent Zero Limited | Display of market information |
US8235811B2 (en) | 2007-03-23 | 2012-08-07 | Wms Gaming, Inc. | Using player information in wagering game environments |
US9619969B2 (en) | 2007-03-23 | 2017-04-11 | Bally Gaming, Inc. | Using player information in wagering game environments |
Also Published As
Publication number | Publication date |
---|---|
NZ506304A (en) | 2003-03-28 |
EP1316031A1 (en) | 2003-06-04 |
AU2001282720A1 (en) | 2002-02-25 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US20030107575A1 (en) | Customer activity tracking system and method | |
US8700450B2 (en) | Customer relationship management system and method | |
US7885865B2 (en) | System and method for mapping of planograms | |
US20040024770A1 (en) | Database query system and method | |
CA2488432C (en) | System and method for customer contact management | |
US20050027721A1 (en) | System and method for distributed data warehousing | |
US20040024608A1 (en) | System and method for customer contact management | |
EP1038242A1 (en) | Site-specific interest profiling system | |
US20020013782A1 (en) | Software program for internet information retrieval, analysis and presentation | |
US8620756B2 (en) | Method and apparatus for permitting stage-door access to on-line vendor information | |
US20030120641A1 (en) | Method and apparatus for dynamic database creation and interactive analysis | |
KR20060076779A (en) | Command center and interface for web based business merchandising and service | |
US20030189595A1 (en) | Summary data visualisation system and method | |
WO2002015049A1 (en) | Summary data visualisation system and method | |
CA2514075A1 (en) | System and method for distributed data warehousing | |
JP2020154939A (en) | Product promotion device | |
Verheijden | Predicting purchasing behavior throughout the clickstream | |
JP2001229272A (en) | System and method for supporting purchase data analysis, and recording medium | |
JP2001338113A (en) | Method and system for automatically analyzing net collection data | |
US20050125437A1 (en) | Data analysis system and method | |
Fried | The data ecosystem | |
WO2003012691A1 (en) | Data visualisation system and method | |
WO2003073323A1 (en) | Data visualisation system and method | |
WO2001093059A1 (en) | Interactive communication network system |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
AK | Designated states |
Kind code of ref document: A1 Designated state(s): AE AG AL AM AT AU AZ BA BB BG BR BY BZ CA CH CN CO CR CU CZ DE DK DM DZ EC EE ES FI GB GD GE GH GM HR HU ID IL IN IS JP KE KG KP KR KZ LC LK LR LS LT LU LV MA MD MG MK MN MW MX MZ NO NZ PL PT RO RU SD SE SG SI SK SL TJ TM TR TT TZ UA UG US UZ VN YU ZA ZW |
|
AL | Designated countries for regional patents |
Kind code of ref document: A1 Designated state(s): GH GM KE LS MW MZ SD SL SZ TZ UG ZW AM AZ BY KG KZ MD RU TJ TM AT BE CH CY DE DK ES FI FR GB GR IE IT LU MC NL PT SE TR BF BJ CF CG CI CM GA GN GQ GW ML MR NE SN TD TG |
|
121 | Ep: the epo has been informed by wipo that ep was designated in this application | ||
DFPE | Request for preliminary examination filed prior to expiration of 19th month from priority date (pct application filed before 20040101) | ||
WWE | Wipo information: entry into national phase |
Ref document number: 2001282720 Country of ref document: AU |
|
WWE | Wipo information: entry into national phase |
Ref document number: 2001961458 Country of ref document: EP |
|
WWE | Wipo information: entry into national phase |
Ref document number: 10364659 Country of ref document: US |
|
WWP | Wipo information: published in national office |
Ref document number: 2001961458 Country of ref document: EP |
|
REG | Reference to national code |
Ref country code: DE Ref legal event code: 8642 |
|
WWW | Wipo information: withdrawn in national office |
Ref document number: 2001961458 Country of ref document: EP |
|
NENP | Non-entry into the national phase |
Ref country code: JP |