System and method for deriving and visualizing business intelligence data

• US 20060085434A1
• Filed: 09/30/2004
• Published: 04/20/2006
• Est. Priority Date: 09/30/2004
• Status: Abandoned Application

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Zhang, Benyu, Li, Ying, Mah, Teresa
• Application Number:
  US10/953,183
• Publication Number:
  US 20060085434A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/958 Organisation or management of web site content, e.g. publishing, maintaining pages or automatic linking
• CPC Class Codes: G06F 2216/03 Data mining

Abstract

A system and method are provided for deriving business intelligence (BI) data and exploring the derived data. The system may include a business intelligence engine and a business intelligence visualizer. The BI engine may be responsible for deriving or discovering fact summary data. The fact summary data may include aggregated or trend data in addition to the dimension or measure data. The BI engine may include components for determining fact summary data such as “What'"'"'s Hot” and “What'"'"'s Not Hot”. The components of the BI engine may include an algorithm for automatically generating “hotness scores” for members of dimensions or combinations of dimensions. The BI visualizer provides a chart node tree display for user exploration.

Claims

1. A business intelligence visualization system for presenting business intelligence data to a user, the visualization system comprising:

a node tree structure generation mechanism for generating a node as a portion of a tree for displaying data; and

a drilling component for allowing user selection of at least one additional node for generation by the node tree structure generation mechanism.

2. The system of claim 1, further comprising summary components for providing a fact summary within a user display.

3. The system of claim 2, wherein each node is represented by a chart and the summary components provide for user selection of chart type.

4. The system of claim 2, wherein the summary component provides multiple view windows, wherein each view window represents a single selected measure.

5. The system of claim 1, wherein the drilling component creates an edge between a previously existing node and a new node.

6. The system of claim 5, further comprising a user controlled edge adjustment mechanism for allowing the user to alter an edge appearance.

7. The system of claim 1, further comprising a user controlled node adjustment mechanism for allowing the user to alter node appearance.

8. The system of claim 7, wherein the node adjustment mechanism allows the user to change a node size.

9. A business intelligence system for deriving and displaying business intelligence data, the system comprising:

a business intelligence engine for analyzing information from a database, the business intelligence engine comprising,

a change calculation mechanism for calculating a measure of change between a member value or function of a member value during a previous time period and a member value or function of a member value in a current time period,

a relevance calculation mechanism for calculating a member value percentage within a category, and

a hot value calculation module for calculating whether a member has a hot status based upon the relevance calculation and the change calculation for that member; and

a business intelligence visualizer for creating a graphic display for conveying at least one of change, relevance, and hot item status.

10. The system of claim 9, further comprising a normalization module for normalizing the change calculation and the relevance calculation.

11. The system of claim 10, wherein the hot value calculation module applies a first weight to a change calculation and a second weight to the relevance calculation and sums the calculations with applied weights to find a hot item score.

12. The system of claim 9, further comprising a reverse hot value calculation module for determining least hot items.

13. The system of claim 12, wherein the reverse hot value calculation module applies a first inverse weight to the change calculation and a second inverse weight to the relevance calculation and sums the weighted calculations to reach a least hot item score.

14. The system of claim 9, wherein the visualizer comprises summary components and exploratory components.

15. The system of claim 14, wherein the summary components provide multiple view windows, each view window representing a user-selected measure.

16. The system of claim 14, wherein the exploratory components comprise a node tree structure generation mechanism for generating a node as a portion of a tree for displaying data.

17. The system of claim 16, further comprising a drilling component for allowing user selection of at least one additional node for generation by the node tree structure generation mechanism.

18. The system of claim 17, wherein the drilling component creates an edge between a previously existing node and a new node.

19. The system of claim 18, further comprising a user controlled edge adjustment mechanism for allowing the user to alter an edge appearance.

20. The system of claim 17, further comprising a user controlled node adjustment mechanism for allowing the user to alter node appearance.

21. A method for deriving and presenting business intelligence data with information extracted from a database, the method comprising:

determining a measure of change between a member value during a previous time period and a member value in a current time period;

assessing relevance by calculating a member value percentage within a category;

and

ranking hot items for display based on a combination of relevance and change.

22. The method of claim 21, further comprising creating a graphic display for conveying at least one of change, relevance, and hot item status.

23. The method of claim 21, further comprising implementing a normalization module for normalizing the change calculation and the relevance calculation.

24. The method of claim 21, further comprising applying a first weight to the change calculation and a second weight to the relevance calculation and summing the calculations with applied weights to find a hot item score.

25. The method of claim 21, further comprising providing a reverse hot value calculation module for determining least hot items.

26. The method of claim 25, further comprising implementing the reverse hot value calculation module to apply a first inverse weight to the change calculation and a second inverse weight to the relevance calculation and summing the weighted calculations to reach a least hot item score.

27. A computer readable medium storing computer executable instructions for performing the method of claim 21.

28. The method of claim 22, further comprising providing a visualizer for creating a graphic display, the visualizer including summary components and exploratory components.

29. The method of claim 28, further comprising implementing the summary components to provide multiple view windows, each view window representing a user-selected measure.

30. The method of claim 29, further comprising providing a node tree structure generation mechanism as an exploratory component for generating a node as a portion of a tree for displaying data.

31. The method of claim 30, further comprising providing a drilling component for allowing user selection of at least one additional node for generation by the node tree structure generation mechanism.

32. The method of claim 31, further comprising creating an edge between a previously existing node and a new node.

33. The method of claim 31, further comprising providing a user controlled edge adjustment mechanism for allowing the user to alter an edge appearance.

34. The method of claim 31, further comprising providing a user controlled node adjustment mechanism for allowing the user to alter node appearance.

35. A method for organizing and displaying business intelligence data, the method comprising:

implementing a node tree structure generation mechanism for generating a node as a portion of a tree for displaying data; and

providing a drilling component for allowing user selection of at least one additional node for generation by the node tree structure generation mechanism.

36. The method of claim 35, further comprising providing summary components for providing a fact summary within a user display.

37. The method of claim 36, further comprising representing each node by a chart and the providing for user for user selection of chart type.

38. The method of claim 36, further comprising providing multiple view windows, each view window representing a single selected measure.

39. The method of claim 35, further comprising creating an edge between a previously existing node and a new node.

40. The method of claim 39, further comprising a providing user controlled edge adjustment mechanism for allowing the user to alter an edge appearance.

41. The method of claim 35, further comprising providing a user controlled node adjustment mechanism for allowing the user to alter node appearance.

42. The method of claim 41, further comprising providing the node adjustment mechanism with user selectable node sizes.

43. A computer readable medium storing computer executable instructions for performing the method of claim 35.