Automatic creation of drill paths

• US 10,726,624 B2
• Filed: 08/21/2017
• Issued: 07/28/2020
• Est. Priority Date: 07/12/2011
• Status: Active Grant

• Current Assignee: Domo, Inc.
• Original Assignee: Domo, Inc.
• Inventors: Landefeld, Adam, Gibb, Gary, Winters, Alan Adams, Thayne, Daren, Burtenshaw, Jeff, Cheney, Mardell
• Primary Examiner(s): Nguyen, Maikhanh
• Application Number:
  US15/682,536
• Publication Number:
  US 20170351407A1
• Time in Patent Office: 1,072 Days
• CPC Class Codes: G06F 3/04845 for image manipulation, e.g. dragging, rotation, expansion or change of colour
• CPC Class Codes: G06F 3/04883 for inputting data by handwriting, e.g. gesture or text
• CPC Class Codes: G06T 11/206 Drawing of charts or graphs
• CPC Class Codes: G06T 19/00 Manipulating 3D models or images for computer graphics

Abstract

A data analysis system may automatically suggest data visualizations to a user. A primary data visualization may be displayed to graphically illustrate a primary data set of a database. Criteria may be automatically applied to the database to identify a secondary data set that meets the criteria. A secondary data visualization that graphically illustrates the secondary data visualization and/or a corresponding indicator may be displayed. Multiple visualizations and/or indicators may be displayed, and the user may select one for viewing. The criteria may again be applied to the database to identify a tertiary data set. An analysis path may be recorded to enable the user to easily view the decisions made and/or the data visualizations viewed. The criteria may include determination that the secondary data set has the desired amount of data, has unique data types or descriptors, includes data previously selected by the user, or the like.

Claims

1. A computer-implemented method, comprising:

at an input device, receiving, from a user, a first user input selecting a primary data visualization;

at a display device, responsive to receipt of the first user input, displaying a graphical user interface including the primary data visualization, the primary data visualization graphically illustrating a primary data set from a database;

at a processor, responsive to receipt of the first user input,

automatically identifying a data field in the database that meets one or more predefined relevance criteria for a secondary data set, the one or more predefined relevance criteria specifying relevance of data values of the secondary data set to the primary data set; and

retrieving data values of the data field from the database to obtain the secondary data set;

automatically displaying, in the graphical user interface in association with the primary data visualization, a secondary graphical representation for the secondary data set for selection by the user to further analyze a different aspect of the primary data set of the primary data visualization;

responsive to automatically displaying the secondary graphical representation for the secondary data set, receiving, at the input device, a second user input selecting the secondary graphical representation for further analysis of the different aspect of the primary data set represented by the secondary graphical representation;

at the display device, responsive to receipt of the second user input, displaying a secondary data visualization graphically illustrating the secondary data set;

at the input device, receiving a third user input setting the secondary data visualization as a new primary data visualization;

at the processor, applying the one or more predefined relevance criteria to the database to identify a plurality of tertiary data sets of the database that meet the one or more predefined relevance criteria, the one or more predefined relevance criteria specifying relevance of data values of a tertiary data set to the secondary data set; and

automatically displaying, in association with the new primary data visualization, a tertiary graphical representation of each of the plurality of tertiary data sets for selection by the user to further analyze a different aspect of the secondary data set.

2. The computer-implemented method of claim 1, further comprising:

identifying a plurality of secondary data sets from the database; and

wherein

automatically displaying, in association with the primary data visualization, the

secondary graphical representation for the secondary data set comprises;

automatically displaying a plurality of indicators in the graphical user interface that are respectively representative of the plurality of secondary data sets, each indicator from the plurality of indicators being individually selectable by the user to view a corresponding secondary data visualization graphically illustrating a corresponding secondary data set from the plurality of secondary data sets.

3. The computer-implemented method of claim 2, wherein each indicator comprises a thumbnail image of the corresponding secondary data visualization.

4. The computer-implemented method of claim 1, further comprising:

identifying a plurality of secondary data sets from the database; and

wherein

automatically displaying, in association with the primary data visualization, the secondary graphical representation for the secondary data set comprises;

automatically displaying a plurality of secondary data visualizations that are respectively representative of the plurality of secondary data sets, each secondary data visualization of the plurality of secondary data visualizations graphically illustrating a corresponding secondary data set from the plurality of secondary data sets.

5. The computer-implemented method of claim 1, further comprising:

adding a graphical representation of the primary data visualization and the secondary graphical representation of the secondary data set to a playback section of the graphical user interface, the playback section reflecting an analysis path of the primary data set by the user.

6. The computer-implemented method of claim 1, further comprising:

generating, at the processor, monitoring data from monitoring the second user input selecting the secondary graphical representation; and

incorporating the monitoring data into the one or more predefined relevance criteria.

7. The computer-implemented method of claim 1, wherein the primary data set comprises a plurality of data values and the one or more predefined relevance criteria include one or more of:

a determination that the secondary data set includes at least some of the plurality of data values of the primary data set;

a determination that the secondary data set does not include more than a maximum number of data values;

a determination that the secondary data set does not include fewer than a minimum number of data values;

a determination that the secondary data set includes data values that are dimensions;

a determination that the secondary data set includes data values that are of a data type different from that of the plurality of data values of the primary data set;

a determination that the secondary data set includes data values with descriptors different from that of the plurality of data values of the primary data set;

a determination that the secondary data set includes data values contained within a previous data set graphically illustrated by a previous data visualization previously selected for viewing by the user; and

a determination that the secondary data set includes data values with data parameters that are the same as those of data values of a previous data set graphically illustrated by a previous data visualization previously selected for viewing by the user.

8. A computer system, comprising:

one or more processors; and

one or more memories storing computer logic that, when executed by the one or more processors, causes the computer system to perform operations including;

at an input device, receiving, from a user, a first user input selecting a primary data visualization;

at a display device, responsive to receipt of the first user input, displaying a graphical user interface including the primary data visualization, the primary data visualization graphically illustrating a primary data set from a database;

at the one or more processors, responsive to receipt of the first user input,

automatically identifying a data field in the database that meets one or more predefined relevance criteria for a secondary data set, the one or more predefined relevance criteria specifying relevance of data values of the secondary data set to the primary data set; and

retrieving data values of the data field from the database to obtain the secondary data set;

automatically displaying, in the graphical user interface in association with the primary data visualization, a secondary graphical representation for the secondary data set for selection by the user to further analyze a different aspect of the primary data set of the primary data visualization;

responsive to automatically displaying the secondary graphical representation for the secondary data set, receiving, at the input device, a second user input selecting the secondary graphical representation for further analysis of the different aspect of the primary data set represented by the secondary graphical representation;

at the display device, responsive to receipt of the second user input, displaying a secondary data visualization graphically illustrating the secondary data set;

at the input device, receiving a third user input setting the secondary data visualization as a new primary data visualization;

at the one or more processors, applying the one or more predefined relevance criteria to the database to identify a plurality of tertiary data sets of the database that meet the one or more predefined relevance criteria, the one or more predefined relevance criteria specifying relevance of data values of a tertiary data set to the secondary data set; and

automatically displaying, in association with the new primary data visualization, a tertiary graphical representation of each of the plurality of tertiary data sets for selection by the user to further analyze a different aspect of the secondary data set.

9. The computer system of claim 8, wherein the computer logic causes the computer system to perform the operations including:

identifying a plurality of secondary data sets from the database; and

wherein

automatically displaying, in association with the primary data visualization, the secondary graphical representation for the secondary data set comprises;

automatically displaying a plurality of indicators in the graphical user interface that are respectively representative of the plurality of secondary data sets, each indicator from the plurality of indicators being individually selectable by the user to view a corresponding secondary data visualization graphically illustrating a corresponding secondary data set from the plurality of secondary data sets.

10. The computer system of claim 9, wherein each indicator comprises a thumbnail image of the corresponding secondary data visualization.

11. The computer system of claim 8, wherein the computer logic causes the computer system to perform the operations including:

identifying a plurality of secondary data sets from the database; and

wherein

automatically displaying, in association with the primary data visualization, the secondary graphical representation for the secondary data set comprises;

automatically displaying a plurality of secondary data visualizations that are respectively representative of the plurality of secondary data sets, each secondary data visualization of the plurality of secondary data visualizations graphically illustrating a corresponding secondary data set from the plurality of secondary data sets.

12. The computer system of claim 8, wherein the computer logic causes the computer system to perform the operations including:

adding a graphical representation of the primary data visualization and the secondary graphical representation of the secondary data set to a playback section of the graphical user interface, the playback section reflecting an analysis path of the primary data set by the user.

13. The computer system of claim 8, wherein the computer logic causes the computer system to perform the operations including:

generating, by the one or more processors, monitoring data from monitoring the second user input selecting the secondary graphical representation; and

incorporating the monitoring data into the one or more predefined relevance criteria.

14. The computer system of claim 8, wherein the primary data set comprises a plurality of data values and the one or more predefined relevance criteria include one or more of:

a determination that the secondary data set includes at least some of the plurality of data values of the primary data set;

a determination that the secondary data set does not include more than a maximum number of data values;

a determination that the secondary data set does not include fewer than a minimum number of data values;

a determination that the secondary data set includes data values that are dimensions;

a determination that the secondary data set includes data values that are of a data type different from that of the plurality of data values of the primary data set;

a determination that the secondary data set includes data values with descriptors different from that of the plurality of data values of the primary data set;

a determination that the secondary data set includes data values contained within a previous data set graphically illustrated by a previous data visualization previously selected for viewing by the user; and

a determination that the secondary data set includes data values with data parameters that are the same as those of data values of a previous data set graphically illustrated by a previous data visualization previously selected for viewing by the user.

15. A system comprising:

means for receiving, from a user, a first user input selecting a primary data visualization;

means for displaying a graphical user interface including the primary data visualization, the primary data visualization graphically illustrating a primary data set from a database;

means for automatically identifying a data field in the database that meets one or more predefined relevance criteria for a secondary data set, the one or more predefined relevance criteria specifying relevance of data values of the secondary data set to the primary data set;

means for retrieving data values of the data field from the database to obtain the secondary data set;

means for automatically displaying, in the graphical user interface in association with the primary data visualization, a secondary graphical representation for the secondary data set for selection by the user to further analyze a different aspect of the primary data set of the primary data visualization;

means for, responsive to automatically displaying the secondary graphical representation for the secondary data set, receiving a second user input selecting the secondary graphical representation for further analysis of the different aspect of the primary data set represented by the secondary graphical representation;

means for, responsive to receipt of the second user input, displaying a secondary data visualization graphically illustrating the secondary data set;

means for receiving a third user input setting the secondary data visualization as a new primary data visualization;

means for applying the one or more predefined relevance criteria to the database to identify a plurality of tertiary data sets of the database that meet the one or more predefined relevance criteria, the one or more predefined relevance criteria specifying relevance of data values of a tertiary data set to the secondary data set; and

means for automatically displaying, in association with the new primary data visualization, a tertiary graphical representation of each of the plurality of tertiary data sets for selection by the user to further analyze a different aspect of the secondary data set.

16. The system of claim 15, further comprising:

means for identifying a plurality of secondary data sets from the database, wherein the means for automatically displaying, in the graphical user interface in association with the primary data visualization, the secondary graphical representation for the secondary data set comprises;

automatically displaying a plurality of indicators in the graphical user interface that are respectively representative of the plurality of secondary data sets, each indicator from the plurality of indicators being individually selectable by the user to view a corresponding secondary data visualization graphically illustrating a corresponding secondary data set from the plurality of secondary data sets.

17. The system of claim 16, wherein each indicator comprises a thumbnail image of the corresponding secondary data visualization.

18. The system of claim 15, further comprising:

means for identifying a plurality of secondary data sets from the database, wherein the means for automatically displaying, in the graphical user interface in association with the primary data visualization, the secondary graphical representation for the secondary data set comprises;

means for automatically displaying a plurality of secondary data visualizations that are respectively representative of the plurality of secondary data sets, each secondary data visualization of the plurality of secondary data visualizations graphically illustrating a corresponding secondary data set from the plurality of secondary data sets.

19. The system of claim 15, further comprising:

means for adding a graphical representation of the primary data visualization and the secondary graphical representation of the secondary data set to a playback section of the graphical user interface, the playback section reflecting an analysis path of the primary data set by the user.