Suggesting alternate data mappings for charts

• US 9,135,233 B2
• Filed: 10/13/2011
• Issued: 09/15/2015
• Est. Priority Date: 10/13/2011
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Inventors: Fan, Kevin, Rampson, Benjamin Edward, Chiang, Nick, Wakefield, Robin
• Primary Examiner(s): Shanmugasundaram, Kannan
• Application Number:
  US13/272,522
• Publication Number:
  US 20130097177A1
• Time in Patent Office: 1,433 Days
• Field of Search: 707/722, 707999001-999005, 707/798
• US Class Current: 1/1
• CPC Class Codes: G06F 16/221 Column-oriented storage; Management thereof
• CPC Class Codes: G06F 16/24578 using ranking
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06F 16/34 Browsing; Visualisation therefor
• CPC Class Codes: G06F 16/438 Presentation of query results
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

Data mapping alternatives for creating a visual representation of a set of data are presented. A set of data is identified for analysis. The identified set of data and properties associated with the identified set of data are analyzed. Based on the analysis, data mapping alternatives for the identified set of data are determined. The determined data mapping alternatives for the identified set of data are ranked. The determined data mapping alternatives are presented in an order according to the ranking of the determined data mapping alternatives.

Claims

1. A method for presenting data mapping alternatives for creating a visual representation of a set of data, comprising:

identifying a set of data for analysis, the set of data comprising at least one row and at least one column in a chart;

modifying the set of data by trimming empty rows and empty columns;

analyzing the set of data and properties associated with the set of data;

based on the analysis, determining data mapping alternatives for the set of data;

ranking the determined data mapping alternatives for the set of data by generating a score for each of the data mapping alternatives according to a scoring system comprising static scores and score multipliers, the static scores being mapped against each of a plurality of chart selection rules that determine how appropriate a set of categories and value series are for a predetermined chart type and data mapping, the score multipliers being mapped against a data orientation, series-axis mappings and filtering rules, the score for each of the data mapping alternatives being weighted with a multiplier according to a likelihood that one of a row-wise orientation and a column-wise orientation reflects the set of data; and

presenting, in a user interface comprising a recommendations pane and a charts pane, the determined data mapping alternatives for selection, the data mapping alternatives being presented as a scrollable list of recommended charts in the recommendations pane for modification by a user within the user interface.

2. The method of claim 1, further comprising receiving a selection of a chart type for creating the visual representation of the set of data.

3. The method of claim 1, further comprising identifying a chart type for creating the visual representation of the set of data based on the analysis of the set of data and properties associated with the set of data.

4. The method of claim 1, wherein the identifying a set of data for analysis further comprises receiving a selection of the set of data from an electronic spreadsheet.

5. The method of claim 1, wherein the analyzing the set of data and properties associated with the set of data further comprises determining an organization associated with the set of data, identifying a type of data associated with the set of data, identifying a structure associated with the set of data.

6. The method of claim 1, wherein the analyzing the set of data and properties associated with the set of data further comprises determining a pattern associated with the set of data.

7. The method of claim 1, further comprising ordering the data mapping alternatives according to the generated score associated with each of the data mapping alternatives.

8. A chart recommendation device, comprising:

memory for storing data; and

a processor, coupled to the memory, the processor configured for identifying a set of data for analysis, the set of data comprising at least one row and at least one column in a chart,

modifying the set of data by trimming empty rows and empty columns, identifying the set of data for analysis, analyzing the set of data and properties associated with the set of data, based on the analysis, determining data mapping alternatives for the set of data, ranking the determined data mapping alternatives for the set of data by generating a score for each of the data mapping alternatives according to a scoring system comprising static scores and score multipliers, the static scores being mapped against each of a plurality of chart selection rules that determine how appropriate a set of categories and value series are for a predetermined chart type and data mapping, the score multipliers being mapped against a data orientation, series-axis mappings and filtering rules, the score for each of the data mapping alternatives being weighted with a multiplier according to a likelihood that one of a row-wise orientation and a column-wise orientation reflects the set of data, and presenting, in a user interface comprising a recommendations pane and a charts pane, the determined data mapping alternatives for selection, the data mapping alternatives being presented as a scrollable list of recommended charts in the recommendations pane for modification by a user within the user interface.

9. The chart recommendation device of claim 8, wherein the processor identifies a chart type for creating the visual representation of the set of data based on the analysis of the set of data and properties associated with the set of data.

10. The chart recommendation device of claim 8, wherein the processor determines an organization associated with the set of data, identifies a type of data associated with the set of data, and identifies a structure associated with the set of data.

11. The chart recommendation device of claim 8, wherein the processor determines a pattern associated with the set of data.

12. The chart recommendation device of claim 8, further comprising ordering the data mapping alternatives according to the generated score associated with each of the data mapping alternatives.

13. A computing device, comprising:

memory for storing data; and

a processor, coupled to the memory, the processor configured to;

identify a set of data for analysis;

analyze the set of data and properties associated with the set of data;

based on the analysis, determine data mapping alternatives for the set of data by identifying data mapping alternatives;

rank the determined data mapping alternatives for the set of data by generating a score for each of the data mapping alternatives according to a scoring system comprising static scores and score multipliers, the static scores being mapped against each of a plurality of chart selection rules that determine how appropriate a set of categories and value series are for a predetermined chart type and data mapping, the score multipliers being mapped against a data orientation, series-axis mappings and filtering rules, the score for each of the data mapping alternatives being weighted with a multiplier according to a likelihood that one of a row-wise orientation and a column-wise orientation reflects the set of data;

order the determined data mapping alternatives according to the generated score associated with each of the determined data mapping alternatives; and

present, in a user interface comprising a recommendations pane and a charts pane, the determined data mapping alternatives for selection, the data mapping alternatives being presented as a scrollable list of recommended charts in the recommendations pane for a modification by a user within the user interface.

14. The computing device of claim 13, wherein the processor is further configured to identify a chart type for creating the visual representation of the set of data based on the analysis of the set of data and properties associated with the set of data.