Data analysis method and system

• US 20060242035A1
• Filed: 04/20/2005
• Published: 10/26/2006
• Est. Priority Date: 04/20/2005
• Status: Abandoned Application

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Evans, Christopher, Corbett, Steven
• Application Number:
  US11/109,817
• Publication Number:
  US 20060242035A1
• Time in Patent Office: Days
• US Class Current: 705/34
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders
• CPC Class Codes: G06Q 30/04 Billing or invoicing
• CPC Class Codes: G06Q 30/06 Buying, selling or leasing transactions

Abstract

A method for automatically analysing a data set is disclosed. The data set comprises a plurality of data items together representing an aspect of the performance of an entity. Each item has a descriptor value within each of one or more categories of description data and associated performance data values. The method comprises selecting each unique descriptor value in turn and for each unique descriptor value: a) selecting every data item having said descriptor value; b) calculating a key performance indicator (KPI) value for the data items selected in step (a); and identifying any of the unique descriptor values for which the KPI value fails to meet a predetermined performance criterion.

Claims

1. A method for automatically analysing a data set, the data set comprising a plurality of data items together representing an aspect of the performance of an entity, each item having a descriptor value within each of one or more categories of description data and associated performance data values, the method comprising selecting each unique descriptor value in turn and for each unique descriptor value:

a) selecting every data item having said descriptor value;

b) calculating a key performance indicator (KPI) value for the data items selected in step (a);

and identifying any of the unique descriptor values for which the KPI value fails to meet a predetermined performance criterion.

2. A method according to claim 1, wherein the data set is stored on a database.

3. A method according to claim 1, wherein a descriptor value in a first category indicates a product type and a descriptor value in a second category indicates a retail outlet location, and the associated performance data values indicate the purchase cost and sales revenue for each product sold.

4. A method according to claim 3, wherein the KPI value represents the profit margin.

5. A method according to claim 4, wherein the profit margin is calculated by aggregating the performance data values for every data item selected in step (a) to generate a total revenue value and a total cost value for said descriptor value, and dividing the difference between the total revenue value and total cost value by the total revenue value.

6. A method according to claim 1, wherein the KPI value fails to meet the predetermined performance criterion if the KPI value falls below a threshold value.

7. A method according to claim 1, wherein the KPI value fails to meet the predetermined performance criterion if the KPI value falls outside a range of values.

8. A method according to claim 1, wherein the KPI value fails to meet the predetermined performance criterion if the KPI value falls exceeds a threshold value.

9. A method according to claim 1, wherein the unique descriptor values for which the KPI values have failed to meet the predetermined performance criterion are identified by comparing each KPI value calculated in step (b) with the predetermined performance criterion.

10. A method according to claim 1, wherein the unique descriptor values and associated KPI values for the category of description data having the lowest proportion of unique descriptor values for which the KPI value fails to meet the predetermined performance criterion are displayed to a user.

21. A computer program comprising computer program code means adapted to perform the steps of claim 1 when said program is run on a computer.

22. A computer program product comprising computer program code means adapted to perform the steps of claim 1 when said program is run on a computer.

11. A system for automatically analysing a data set, the system comprising a processor connected to a store, wherein the processor is adapted to retrieve a set of data from the store, the data set comprising a plurality of data items together representing an aspect of the performance of an entity, each item having a descriptor value within each of one or more categories of description data and associated performance data values, and to select each unique descriptor value in turn and for each unique descriptor value:

a) to select every data item with said descriptor value;

b) to calculate a key performance indicator (KPI) value for the data items selected in step (a);

and identify any of the unique descriptor values for which the KPI value fails to meet a predetermined performance criterion.

12. A system according to claim 11, wherein the store is a database on which the data set is stored.

13. A system according to claim 11, wherein a descriptor value in a first category indicates a product type and a descriptor value in a second category indicates a retail outlet location, and the associated performance data values indicate the purchase cost and sales revenue for each product sold.

14. A system according to claim 13, wherein the KPI value represents the profit margin.

15. A system according to claim 14, wherein the processor is further adapted to calculate the profit margin by aggregating the performance data values for every data item selected in step (a) to generate a total revenue value and a total cost value for said descriptor value, and to divide the difference between the total revenue value and total cost value by the total revenue value.

16. A system according to claim 11, wherein the KPI value fails to meet the predetermined performance criterion if the KPI value falls below a threshold value.

17. A system according to claim 11, wherein the KPI value fails to meet the predetermined performance criterion if the KPI value falls outside a range of values.

18. A system according to claim 11, wherein the KPI value fails to meet the predetermined performance criterion if the KPI value falls exceeds a threshold value.

19. A system according to claim 11, wherein the processor is further adapted to identify the unique descriptor values for which the KPI values have failed to meet the predetermined performance criterion by comparing each KPI value calculated in step (b) with the predetermined performance criterion.

20. A system according to claim 11, wherein the processor is further adapted to display to a user the unique descriptor values and associated KPI values for the category of description data having the lowest proportion of unique descriptor values for which the KPI value fails to meet the predetermined performance criterion.