DATA EXPLORATION TOOL INCLUDING GUIDED NAVIGATION AND RECOMMENDED INSIGHTS

• US 20100175019A1
• Filed: 01/05/2009
• Published: 07/08/2010
• Est. Priority Date: 01/05/2009
• Status: Abandoned Application

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Kamon, Kfir, Varshavsky, Roy, Karidi, Ron, Sitton, Daniel
• Application Number:
  US12/348,502
• Publication Number:
  US 20100175019A1
• Time in Patent Office: Days
• US Class Current: 715/781
• CPC Class Codes: G06F 16/24578 using ranking
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: G06F 3/0481 based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance
• CPC Class Codes: G06Q 10/00 Administration; Management

Abstract

An ad hoc business data exploration tool is disclosed, which provides guided access to the vast amount of data within a multidimensional database. The tool provides guided access by suggesting insights which may be of particular interest to the user based on a scoring of the insights and user feedback on desirable/undesirable insights. The present system works in conjunction with custom algorithms, as well as a conventional multidimensional database.

Claims

1. A method of presenting business intelligence information, comprising the steps of:

(a) receiving input identifying a measure a user would like more information on;

(b) ranking a plurality of stored insights for the measure identified in said step (a) with respect to which insights appear to be of most interest to the user; and

(c) displaying a dashboard including one or more of the insights to the user that were ranked the highest in said step (b).

2. The method recited in claim 1, wherein said step (b) of ranking a plurality of stored insights comprises the step of receiving user feedback on an insight displayed to the user.

3. The method recited in claim 1, wherein said step (b) of ranking a plurality of stored insights comprises the step of applying heuristic rules to the plurality of stored insights to determine the ranking of insights.

4. The method recited in claim 1, further comprising the step of displaying on the dashboard of said step (c) the measure identified in said step (a) and dimensions used in defining the measure identified in said step (a).

5. The method recited in claim 4, further comprising the step of displaying on the dashboard of said step (c) a sibling relations window including information relating to siblings of the dimensions used in defining the measure identified in said step (a).

6. The method recited in claim 5, further comprising the steps of receiving input on a sibling identified from the sibling relations window, and displaying a second dashboard alongside the first dashboard displayed in said step (c), the second dashboard including more detail information on the sibling identified from the sibling relations window.

7. The method recited in claim 1, further comprising the step of displaying on the dashboard of said step (c) one or more fixed windows and one or more variable windows, the fixed windows displaying fixed insights relating to the measure identified in said step (a), the variable windows displaying the highest ranked insights of said step (c).

8. The method recited in claim 7, further comprising the step of displaying dimensions in the one or more fixed and variable windows, the dimensions being dimensions used in defining the measure identified in said step (a), or siblings or descendants of dimensions used in defining the measure identified in said step (a).

9. The method recited in claim 8, further comprising the steps of identifying when a user has positioned a screen cursor to hover over one of the dimensions displayed in the one or more fixed and variable windows, and displaying a pop-up window on the dashboard of said step (c), the pop-up winding including additional insights into the dimension over which the screen cursor is hovering.

10. The method recited in claim 8, further comprising the steps of identifying when a user has selected one of the dimensions displayed in the one or more fixed and variable windows, and displaying a second dashboard below the first dashboard displayed in said step (c), the second dashboard including more detail information on a descendant of the dimension selected from the one or more fixed and variable windows.

11. A method of presenting business intelligence information, comprising the steps of:

(a) displaying a first dashboard including one or more business intelligence measures from a multidimensional database, and dimensions used to define the measures;

(b) displaying on the first dashboard one or more siblings of the dimensions displayed as part of said step (a);

(c) displaying one or more insights on the first dashboard, the one or more insights selected as being of greatest interest to the user, the one or more insights including one or more additional dimensions relating to the measures and/or dimensions displayed as part of said step (a);

(d) receiving input identifying a sibling displayed in said step (b) or a dimension displayed as part of said steps (a) or (c); and

(e) displaying a second dashboard upon identifying the sibling or dimension in said step (d), the second dashboard including one or more insights relating to the sibling or dimension identified in said step (d).

12. The method of claim 11, further comprising a plurality of additional dashboards, each additional dashboard displayed upon selecting a sibling or other dimension from a displayed dashboard, the additional dashboard including more insights relating to the selected sibling or other dimension, the plurality of displayed dashboards together comprising a relational map of business intelligence.

13. The method of claim 11, wherein the second dashboard is opened to the side of the first dashboard if a sibling is identified in said step (d).

14. The method of claim 11, wherein the second dashboard is opened below the first dashboard if the dimension identified in said step (d) is not a sibling dimension.

15. The method of claim 11, further comprising the step of ranking a plurality of stored insights based on which insights would be of greatest interest to the user, the highest ranked insights being displayed to the user in said step (c).

16. The method recited in claim 15, wherein said step of ranking a plurality of stored insights comprises the step of receiving user feedback on an insight displayed to the user.

17. The method recited in claim 15, wherein said step of ranking a plurality of stored insights comprises the step of applying heuristic rules to the plurality of stored insights to determine the ranking of insights.

18. A computer-readable storage medium having computer-executable instructions for programming a processor to perform a method of presenting business intelligence information, the method comprising the steps of:

(a) generating and storing a plurality of business logic algorithms;

(b) receiving input identifying a business intelligence measure from a database;

(c) generating a plurality of insights relating to the measure identified in said step (b);

(d) ranking the insights generated in said step (c) according to which insights would be of greatest interest to the user, the step of ranking using heuristic rules and/or user feedback; and

(e) displaying a first dashboard including the measure identified in said step (a), dimensions from the database used to define the measure identified in said step (a), and the highest ranked insights.

19. The computer-readable storage medium recited in claim 18, the method further comprising the step of displaying one or more additional dashboards including insights into sibling dimensions and/or descendant dimensions.

20. The computer-readable storage medium recited in claim 19, the method further comprising the step of displaying one or more additional dashboards including insights into sibling dimensions to the side of the first dashboard, and displaying one or more additional dashboards including insights into descendant dimensions below the first dashboard.