Suggesting alternate data mappings for charts

• US 10,019,494 B2
• Filed: 07/28/2015
• Issued: 07/10/2018
• 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:
  US14/811,090
• Publication Number:
  US 20160026695A1
• Time in Patent Office: 1,078 Days
• 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:

receiving the set of data for analysis;

modifying the set of data to form a modified set of data;

receiving a selection of a chart type;

analyzing the modified set of data and properties associated with the modified set of data for the chart type in response to the selection of the chart type;

based on the analysis, determining data mapping alternatives for the modified set of data for the chart type, wherein determining the data mapping alternatives for the modified set of data for the chart type comprises;

determining different data orientations for the modified set of data for the chart type,

determining different series mappings for the different data orientations for the chart type, and

determining different axis mappings for the different series mappings to form a different series-axis mapping for each data mapping alternative;

ranking the data mapping alternatives based on the different data orientations, the different series-axis mappings and filtering rules; and

presenting, in a user interface, the data mapping alternatives for the chart type as applied to the modified set of data for selection based at least on the ranking.

2. The method of claim 1, wherein the data mapping alternatives are presented in a recommended charts pane.

3. The method of claim 2, further comprising:

receiving a desired selection of a desired chart from the recommended charts pane;

in response to the desired selection, presenting an alternative layouts box that provides different alternative layouts for the desired chart.

4. The method of claim 1, wherein the modified set of data for analysis is received from a data selection on an electronic spreadsheet.

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

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

7. The method of claim 1, wherein determining the data mapping alternatives for the modified set of data further comprises identifying data mapping alternatives heuristically based on the modified set of data.

8. The method of claim 1, wherein the ranking the data mapping alternatives further comprises generating a score for each of the data mapping alternatives and ordering the data mapping alternatives according to the score.

9. The method of claim 8, wherein the generating the score for each of the data mapping alternatives further comprises determining how appropriate a set of categories and value series are for a data mapping.

10. The method of claim 8, wherein the generating the score for each of the data mapping alternatives further comprises determining a multiplier for each of the data mapping alternatives based on the different data orientation and the series-axis mapping associated with each of the data mapping alternatives.

11. The method of claim 1, wherein the ranking the data mapping alternatives for the modified set of data further comprises using a minimum threshold to filter out the data mapping alternatives that are below the minimum threshold.

12. A chart recommendation system, comprising:

at least one processor; and

memory encoding computer executable instructions that, when executed by the at least one processor, perform a method comprising;

receiving 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 to form a modified set of data;

receiving a selection of a chart type;

determining at least two data mapping alternatives for the modified set of data for the chart type in response to the selection of the chart type;

ranking the at least two data mapping alternatives based on data orientation, series-axis mappings and filtering rules for the chart type; and

presenting the data mapping alternatives for the chart type as applied to the modified set of data based at least on the ranking.

13. The chart recommendation system of claim 12, wherein the data mapping alternatives are presented in a recommended charts pane.

14. The chart recommendation system of claim 13, the method further comprising:

receiving a desired selection of a desired chart from the recommended charts pane;

in response to the desired selection, presenting an alternative layouts box that provides different alternative layouts for the desired chart.

15. The chart recommendation system of claim 12, wherein the at least one processor determines an organization associated with the modified set of data, identifies a type of data associated with the modified set of data, and identifies a structure associated with the modified set of data, and

wherein the at least one processor determines a pattern associated with the modified set of data.

16. The chart recommendation system of claim 12, wherein the at least one processor determines the data mapping alternatives for the modified set of data heuristically based on different data mappings and chart layouts generated for the modified set of data.

17. The chart recommendation system of claim 12, wherein the at least one processor ranks the data mapping alternatives for the modified set of data by generating a score for each of the data mapping alternatives and ordering the data mapping alternatives according the score.

18. The chart recommendation system of claim 17, wherein the at least one processor generates the score for each of the data mapping alternatives by determining how appropriate a set of categories and value series are for the chart type and data mapping, and

wherein the at least one processor filters out the data mapping alternatives having scores below a minimum threshold.

19. The chart recommendation system of claim 12, wherein the at least one processor further determines a multiplier for each of the data mapping alternatives based on the data orientation and the series-axis mapping associated with each of the data mapping alternatives.

20. A computing device, comprising:

memory for storing data; and

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

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

receive a selection of a chart type;

modify the set of data by trimming empty rows and empty columns and addressing discontinuous ranges to form a modified set of data;

analyze the modified set of data and properties associated with the modified set of data for the chart type;

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

determining data orientations for the modified set of data for the chart type,

determining series mappings for the modified set of data for the chart type, and

determining axis mappings for the modified set of data for the chart type;

rank the data mapping alternatives based on the data orientations, the series mappings and filtering rules for the chart type; and

present, in a user interface, the data mapping alternatives as applied to the modified set of data for selection based at least on the ranking.