Patent Application
20070174228
Data summary tables may be used to analyze large amounts of data. A data summary table provides an efficient way to display and summarize data supplied by a database program or in a data listing of a spreadsheet. A user can select fields of the data to include within filter, row, column, or data regions of the data summary table and can choose parameters, such as the sum, variance, count, and standard deviation to be displayed for selected data fields. Data in a database that can be queried from within a spreadsheet program, or spreadsheet data including lists, can be analyzed in a data summary table.
Although a data summary table is designed so that data can be efficiently and intuitively analyzed, creation of a data summary table itself can be challenging for novice users. For example, some programs provide wizards that assist the user in creating a data summary table. While these wizards may be helpful in creating an initial data summary table, wizards cannot easily be used to modify the display once it is created and/or provide key performance indicators representative of the data being analyzed. Other programs allow users to drag and drop desired fields directly -onto the data summary table. While these programs provide the user with greater flexibility when creating the display, such programs can be less intuitive for a novice to use.
This summary is provided to introduce a selection of concepts in a simplified form that are further described below in the Detailed Description. This summary is not intended to identify key features of the claimed subject matter nor intended to be used as an aid in determining the scope of the claimed subject matter.
According to one aspect of the invention, key performance indicators and the accompanying key performance indicator elements may be displayed in a task pane to enable a user to select one or more key performance indicator elements for use in generating a data summary table. In one example, the key performance indicators of a dataset are identified and each of the associated key performance indicator elements associated with that key performance indicator is also identified. A key performance indicator may be obtained from any source, including the dataset to which it pertains. Additionally, a name of the identified key performance indicator is determined. The determined name and each of the identified key performance indicator elements are displayed in an organized manner so as to enable a user easy selection of the key performance indicator and/or the key performance indicator elements.
According to another aspect of the invention, key performance indicators may be displayed using graphical icons to provide a visual means for understanding the values of the key performance indicators. Upon selection of a key performance indicator, or key performance indicator element, in one embodiment, at least one property associated with the key performance indicator is determined. Additionally, a value of the key performance indicator representative of the key performance indicator property is determined. Based on the determined value, a graphical icon is assigned and displayed. The graphical icon is used to represent the value of the key performance indicator. In one example, the graphical icon is assigned based on a range in which the value of the key performance indicator falls. Different ranges may be assigned different graphical icons. Depending on the range in which the value of the key performance indicator falls, the appropriate graphical icon is assigned.
According to a yet another aspect of the invention, graphical icons that are displayed in a data summary table for a key performance indicator may be dynamically updated in response to a change to the data summary table. For example, if a user filters the data summary table, the value of the key performance indicator may change, and subsequently fall into a different range. As such, a different graphical icon, associated with the new range, may be displayed to replace the previously displayed graphical icon.
The foregoing aspects and many of the attendant advantages of this invention will become more readily appreciated as the same become better understood by reference to the following detailed description, when taken in conjunction with the accompanying drawings, wherein:
Embodiments will now be described more fully hereinafter with reference to the accompanying drawings. Embodiments disclosed herein are examples and should not be construed as limiting.
Summary tables may be generated from a set of data to aid a user in understanding the contents of the data at a higher level. In addition to providing a typical summary table, embodiments of the present invention provide the ability to identify, understand, and represent Key Performance Indicators (“KPIs”). A KPI as used herein is a calculated value that may be used to provide a high-level representation of a set of data and may be used to represent trends, or the status of the data. For example, KPIs may represent global or regional sales figures and trends over time, personnel statistics and trends, real-time supply chain information, or anything else that is desired to be represented at a high-level.
KPIs may be computed from any type of information, such as a spreadsheet or database. For example, KPIs may be computed from data stored in an Excel spreadsheet, an Oracle® database, etc. Additionally, KPIs may be computed based on data stored in multiple locations and/or multiple databases. For purposes of this discussion, data used to compute a KPI is referred to herein as a “dataset.” It will be understood that a dataset may include one or more databases, or other sources of information, with any amount and type of data. KPIs may be defined and computed for a particular dataset in a multitude of ways. For example, KPIs may be manually defined by a user for use in representing a portion of a dataset. Alternatively, KPIs may be established and defined by an administrator of a corporation based on core information desired by the management of that corporation. For purposes of this application, KPIs may be defined and computed in any manner. Additionally, KPIs may be stored as part of a dataset or computed and stored separately.
The KPI elements typically represent the type of high-level information to be displayed by the KPI. Items 120 may represent the relevant data identifiers for which the high-level information is to be displayed. For example, the KPI 101 named Gross Profit Margin 111, if selected by a user, may present high-level information regarding the items 120 of bikes 121 and clothing 123. In particular, the KPI 101 named Gross Profit Margin 111 may present the actual gross profit margin of bikes and clothing represented, by KPI element value 113, the gross profit margin goal for bikes and clothing, represented by KPI element goal 115, the gross profit margin status for bikes and clothing, represented by KPI element status 117, and the-gross profit margin trend for bikes and clothing, represented by KPI element trend 119. Each of the KPI elements may be calculated from the information contained in the respective dataset 103.
As noted by block 105, the KPI names 110 and KPI elements 112 defined for a particular dataset 103 may be identified and presented to a user in a friendly manner to allow selection by a user for use in generating a data summary table. As described in more detail below with respect to
Upon selection by a user, as illustrated by block 107, the selected KPIs and accompanying elements may be presented to a user. As described in more detail below, some calculated KPI elements 112, such as value 113 and goal 115, may be represented as the calculated numeric value. However, other KPI elements may be better represented as graphical indicators, or icons. For example, the KPI elements status 117 and trend 119 may be calculated in a manner that results in a value between the range of −1.0 and 1.0. As such, the value of the KPI element may be difficult to understand if presented as the numeric value. Accordingly, these types of KPI elements may be represented by a graphical identifier or icon representative of the value of the KPI element.
Additionally, as illustrated by block 109, KPIs displayed in a data summary table may be dynamically updated in response to changes made by a user. Referring to the KPI element trend 119, which may be computed over a specified period of time, the value of the KPI element may be dynamically updated in response to a user adjusting the timeframe for which the KPI should be computed. For example, if the KPI element trend 119 is representing the trend of bike sales over a five-year period, and the user adjusts the range to only cover three years, the value of the KPI element would dynamically update to represent the trend over the specified three year period.
The field pane 210 includes a folder list 212 of KPIs, identified by KPI names, for a given dataset. Each KPI has one or more associated KPI elements. For example the KPI named “Growth in Customer Base” 214, includes four KPI elements: value 216, goal 218, status 220, and trend 222. Each KPI element in list 212 includes a checkbox next to the element. For example, the KPI element goal 218 includes a checkbox 260 positioned adjacent to the KPI element caption. Techniques for displaying, selecting, and manipulating information in the task pane 200 are described in co-pending U.S. Pat. application No. 11/223,527, filed Sep. 9, 2005, entitled “User Interface for Creating a Spreadsheet Data Summary Table.”
In addition to displaying the KPI elements, the accompanying items are also presented for the selected KPI. In this example, the items relevant to the KPI named “Product Gross Profit Margin” include bikes 310 and clothing 320. Items may be structured in a parent-child relationship allowing a user to drill down to more specific information. In one example, the items of bikes 310 is a parent item that includes two child items, mountain bikes 311 and road bikes 312. Parent-child structured items may be expanded or contracted to show all of the items or only the parent item. In one embodiment, each item may include a plus or minus box next to the item name. Selection of a plus box results in the item being expanded to show all child items and the box will change to a minus box. In contrast, selection of a minus box results in all exposed child items being encompassed within the parent item and the box changing to a plus box.
For each item, the appropriate value of the associated KPI elements is displayed, thereby providing a high-level overview of the dataset. As mentioned above, some values of KPI elements may be presented as the calculated value, such as the values of KPI element value 301 and KPI element goal 303, while others may be more easily understood when displayed as a graphical icon, such as KPI element status 305 and KPI element trend 307. Graphical icons may be used to illustrate values of KPI elements by assigning different icons to different ranges of values and displaying the appropriate icon for a particular value of a KPI element based on those ranges. For example, assuming the values for the KPI element trend 307 are computed such that they fall between −1.0 and 1.0 and three different icons are to be presented, the icons may be associated as follows:
1st icon for: −1.0≧value of KPI element <−0.5
2nd icon for: −0.5≧value of KPI element <0.5
3rd icon for: 0.5≧value of KPI element <1.0 While the above examples provides for a range between −1.0 and 1.0, any range may be used for associating icons with values of KPI elements. Additionally, any number and/or type of icons may be used to represent values of KPI elements.
In addition to selecting graphical icons from the drop down menu 400, a user may also adjust how many different icons from a set are to be presented. In one embodiment, a user may specify the number of ranges for which graphical icons are to be associated. Additionally, the user may specify the border values for those ranges. Still further, a user may specify which icons are to be associated with each range. As will be appreciated by one of ordinary skill in the relevant art, any number and combination of ranges, icons, values, etc., may be configured in accordance with embodiments of the present invention.
Referring again to
In addition to providing graphical icons for some values of KPI elements, a user may filter the data summary table 300 and the graphical representation of values of KPI elements automatically update and dynamically change to match the new criteria specified by the user. For example, by using a filter tool 317, a user may specify the range for which a KPI is to be provided. In this example, a user has specified that the range for which a KPI is to be provided is fiscal year 2003. After viewing the results for that particular year, the filter may be changed, e.g., the user can filter to show results for fiscal year 2004, and the graphical representations for the values of the KPI elements will automatically update and the graphical icons automatically change to match the new information. Additionally, if a user selects to drill down into one of the properties by selecting the plus box, when the data summary table 300 expands to include the new items, the graphical representations for the values of the KPI elements associated with those items are dynamically updated and provided to the user in a manner consistent with the representation of the properties of the parent item.
Any type of modifications may be made to the data summary table 300 in response to which the graphical representations for values of KPI elements are dynamically updated. For example, the data summary table may be rearranged, items may be added, removed, and/or relocated, the KPIs can be sorted (based on name, value, goal, trend, status, etc.), and the data summary table layout can be altered, etc.
Upon identification of a KPI for a dataset, the KPI name for the dataset is determined, as illustrated by block 505. In addition to determining the KPI name, at block 507, a KPI element is identified for the KPI. At decision block 509, it is determined if there are additional KPI elements associated with the particular KPI. If it is determined at decision block 509 that there are additional KPI elements, control returns to block 507, and the routine continues.
However, if it is determined at decision block 509 that there are no additional KPI elements for the KPI identified at block 503, at decision block 511 it is determined if there are additional KPIs for the dataset for which a task pane is being generated. If it is determined at decision block 511 that there are additional KPIs for the dataset, control returns to block 503, and the routine continues. However, if it is determined at decision block 511 that there are no additional KPIs for the dataset, at block 513, each identified KPI name and associated KPI element(s) is displayed in the task pane. Upon display of the KPI names and KPI elements, the routine completes, as illustrated by decision block 515. In one embodiment, as illustrated in
Upon receipt of a KPI element selection, at block 605, an item associated with the selected KPI element is identified. At block 607, a value of the KPI element is determined for the item. At block 608, it is determined if the value of the KPI element should be displayed or if it should be represented as graphical icon. If it is determined that the value of the KPI element should be displayed as a graphical icon, at block 609, a graphical icon is assigned to the value based on a range in which the value falls. As discussed above, if a graphical icon is to be used to represent a value of a KPI element, a set of ranges may be specified, icons associated with each range, and the appropriate icon assigned to the value of the KPI element based on the range in which it falls.
After assigning a graphical icon to a value of a KPI element, or if it is determined at decision block 608 that the value of the KPI element is not to be represented by a graphical icon, at decision block 611 it is determined if there are additional items for the KPI selected at block 603. If it is determined at decision block 611 that there are additional items, control returns to block 605, and the routine continues. However, if it is determined at decision block 611 that there are no additional items for the selected KPI, at block 613, either a graphical icon is provided for the KPI element or the value of the KPI element is displayed.
At decision block 615, it is determined if a selection of an additional KPI element has been received. If it is determined at decision block 615 that an additional selection of a KPI element for a dataset has been received, control returns to block 605, and the routine continues. If it is determined that no additional KPI elements have been selected, the routine 600 completes, as illustrated by block 617.
Referring back to
While illustrative embodiments have been illustrated and described, it will be appreciated that various changes can be made therein without departing from the spirit and scope of the invention.
This application is related to co-pending U.S. patent application Ser. No. 11/223,527, filed Sep. 9, 2005, entitled “User Interface for Creating a Spreadsheet Data Summary Table,” which is incorporated herein by reference.
