Ranking visualization types based upon fitness for visualizing a data set

• US 8,677,235 B2
• Filed: 05/13/2008
• Issued: 03/18/2014
• Est. Priority Date: 05/13/2008
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Chronister, Benjamin L, Cory, Daniel Philip, Lee, David Benjamin
• Primary Examiner(s): STORK, KYLE R
• Application Number:
  US12/120,227
• Publication Number:
  US 20090287673A1
• Time in Patent Office: 2,135 Days
• Field of Search: 715/234, 715/243, 715/253, 715/254, 715/255
• US Class Current: 715/253
• CPC Class Codes: G06F 16/904 Browsing; Visualisation therefor for navigating the web G06F16/954; browsing optimisation for the web G06F16/957

Abstract

Technologies are described herein for ranking visualization types. In order to rank the visualization types, visualization metadata is generated for each of the visualization types and data set metadata is generated for the data set. A suitability score is then computed based upon the visualization metadata and the data set metadata through the use of data mapping rules and chart selection rules. The visualization types are then ranked according to the computed scores. A user interface may then be displayed that includes visual representations corresponding to the visualization types that are ordered according to the ranking. One of the visual representations may then be selected to apply the corresponding visualization type to the data set.

Claims

1. A method for ranking a plurality of different visualization types, the method comprising:

generating visualization metadata for each of the plurality of different visualization types, the visualization metadata comprises data describing one or more attributes of a visualization type that specifies

a preferred input for each particular visualization type,

particular axes and particular data series for each particular visualization type, and

attributes regarding a preferred type of data for each of the particular axes or particular data series;

generating data set metadata for each column independently for a data set, the data set metadata comprising data describing one of a data type or mathematical properties of the data set;

calculating a suitability score for each of the plurality of different visualization types based upon the visualization metadata and the data set metadata, the suitability score comprising a number indicating the suitability of a visualization type for use with the data set, the number being based on data mapping rules that create a mapping between columns in the data set to one of each axis and each series of a visualization type of the plurality of visualization types;

ranking the plurality of different visualization types based upon the calculated suitability scores;

determining whether each of the calculated suitability scores exceeds a threshold;

displaying on a user interface a visual representation of each of the plurality of different visualization types where the calculated suitability score exceeds the threshold, the visual representations displayed in order according to the ranking;

receiving a selection of one of the displayed visual representations; and

rendering the data set using the visualization type corresponding to the selected visual representation.

2. The method of claim 1, wherein calculating a suitability score for a visualization type comprises:

using chart selection rules to calculate the suitability score for the data set in view of the mapping.

3. The method of claim 1, wherein ranking the plurality of visualization types based upon the calculated suitability scores comprises ranking the plurality of visualization types based upon the calculated suitability scores and upon the contents of a user profile.

4. The method of claim 1, wherein the data set comprises tabular data or other structured data.

5. The method of claim 1, wherein the visual representations comprise preview images showing the application of each visualization type to the data set.

6. A computer storage medium that is not a signal having computer executable instructions stored thereon which, when executed by a computer, cause the computer to:

receive a request to assist with the selection of one of a plurality of different visualization types for use with a data set, the plurality of different visualization types for visualizing the data set, the plurality of different visualization types comprising at least two from the group of column chart, line chart, pie chart, bar chart, area chart, and scatter chart; and

in response to the request, to generate a ranking of the different visualization types according to their suitability for use with the data set, the suitability based on data mapping rules that create a mapping between columns in the data set to one of each axis and each series of a visualization type of the plurality of visualization types, to display a user interface comprising visual representations of the different visualization types ordered according to the ranking, to receive a selection of one of the different visual representations displayed, and to render the data set using the visualization type that corresponds to the selected visual representation,

wherein generating a ranking of the different visualization types according to their suitability for use with the data set comprises;

generating visualization metadata for each of the plurality of different visualization types, the visualization metadata comprising data describing one or more attributes of a visualization type that specifies

a preferred input for each particular visualization type,

particular axes and particular data series for each particular visualization type, and

attributes regarding a preferred type of data for each of the particular axes or particular data series;

generating data set metadata for each column independently for the data set, the data set metadata comprising data describing one of a data type or mathematical properties of the data set;

calculating a suitability score for each of the plurality of different visualization types based upon the visualization metadata and the data set metadata; and

generating a ranking of the plurality of visualization types according to their suitability for use with the data set based upon the calculated suitability scores.

7. The computer storage medium of claim 6, wherein the data set comprises tabular data or other structured data having one or more columns.

8. The computer storage medium of claim 6, wherein the suitability score comprises a number indicating the suitability of a visualization type for use with the data set.

9. The computer storage medium of claim 8, wherein calculating a suitability score for a visualization type comprises:

using chart selection rules to calculate the suitability score for the data set in view of the mapping.

10. The computer storage medium of claim 9, wherein generating a ranking of the visualization types according to their suitability for use with the data set comprises ranking the plurality of visualization types based upon the calculated suitability scores and upon the contents of a user profile.

11. A method for ranking a plurality of different visualization types, the method comprising:

generating visualization metadata for each of the plurality of different visualization types, the visualization metadata comprising data describing one or more attributes of a visualization type that specifies

a preferred input for each particular visualization type,

particular axes and particular data series for each particular visualization type, and

attributes regarding a preferred type of data for each of the particular axes or particular data series;

generating data set metadata for each column independently for a data set, the data set metadata comprising data describing one of a data type or mathematical properties of the data set;

calculating a suitability score for each of the plurality of different visualization types based upon the visualization metadata and the data set metadata, the suitability score comprising a number indicating the suitability of a visualization type for use with the data set, the number being based on data mapping rules that create a mapping between columns in the data set to one of each axis and each series of a visualization type of the plurality of visualization types;

generating a ranking of the plurality of different visualization types based upon the calculated suitability scores;

displaying a user interface comprising visual representations corresponding to the plurality of different visualization types, the plurality of different visual representations being ordered according to the ranking;

receiving a selection of one of the plurality of different visual representations displayed on the user interface; and

rendering the data set using the visualization type corresponding to the selected visual representation.

12. The method of claim 11, wherein calculating a suitability score for a visualization type comprises:

using chart selection rules to calculate the suitability score for the data set in view of the mapping.

13. The method of claim 12, wherein generating a ranking of the plurality of visualization types based upon the calculated suitability scores comprises ranking the plurality of different visualization types based upon the calculated suitability scores and upon the contents of a user profile.