Automatic creation of drill paths

• US 9,792,017 B1
• Filed: 04/18/2014
• Issued: 10/17/2017
• 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): Abdul-Ali, Omar
• Application Number:
  US14/256,299
• Time in Patent Office: 1,278 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 for suggesting data visualizations, the method comprising:

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

at a display device, responsive to receipt of the first user input, displaying the primary data visualization that graphically illustrates a primary data set of a database;

at a processor, responsive to receipt of the first user input, automatically applying criteria to the database to identify a first secondary data set of the database that meets the criteria;

at the display device, displaying a first secondary data visualization that graphically illustrates the first secondary data set;

recording an analysis path by at least recording a first decision record comprising user selection of the first secondary data visualization;

at the display device, displaying an analysis path playback user interface comprising a plurality of decision records comprising the first decision record; and

receiving a third user input selecting the first decision record from the plurality of decision records.

2. The computer-implemented method of claim 1, wherein at the display device, performing a step comprising automatically displaying a first indicator representative of the first secondary data visualization, wherein the first indicator is selectable by a user to initiate display of the first secondary data visualization.

3. The computer-implemented method of claim 2,

wherein the step comprises displaying the first indicator, the Method further comprising:

at the input device, receiving a second user input selecting the first indicator; and

at the display device and responsive to receipt of the second user input, displaying the first secondary data visualization.

4. The computer-implemented method of claim 3, further comprising, prior to receipt of the second user input:

at the processor, applying the criteria to the database to identify a second secondary data set of the database that meets the criteria and includes at least a portion of data from the primary data set; and

at the display device displaying a second indicator representative of the second secondary data set, wherein the second indicator is selectable by the user to initiate display of a second secondary data visualization that graphically illustrates the second secondary data set.

5. The computer-implemented method of claim 4, wherein the first indicator and the second indicator comprise miniature images of the first secondary data visualization and the second secondary data visualization, respectively.

6. The computer-implemented method of claim 3, further comprising, after displaying the first secondary data visualization:

at the processor, applying the criteria to the database to identify a tertiary data set of the database that meets the criteria and includes at least a portion of data from the first secondary data set;

displaying a third indicator representative of a tertiary data visualization that graphically illustrates the tertiary data set;

at the input device, receiving a fourth user input selecting the third indicator; and

responsive to receipt of the fourth user input, displaying the tertiary data visualization.

7. The computer-implemented method of claim 1, further comprising, after displaying the first secondary data visualization:

at the input device, receiving a fourth user input selecting a first tertiary data visualization that graphically illustrates a first tertiary data set; and

at the display device, responsive to receipt of the fourth user input, displaying the first tertiary data visualization;

and wherein recording the analysis path further comprises recording a second decision record comprising user selection of the first tertiary data visualization.

8. The computer-implemented method of claim 7, further comprising:

at the display device, displaying the second decision record;

at the input device, receiving a fifth user input selecting a second tertiary data visualization that graphically illustrates a second tertiary data set;

responsive to receipt of the fifth user input, displaying the second tertiary data visualization; and

revising the analysis path such that the second decision record comprises user selection of the second tertiary data visualization.

9. The computer-implemented method of claim 1, further comprising, after displaying the first secondary data visualization:

at the input device, receiving a fourth user input selecting a resource selected from the group consisting of a document, a multimedia file, and a web site; and

at the display device, responsive to receipt of the fourth user input, displaying the selected resource;

and wherein recording the analysis path further comprises recording a second decision record comprising user selection of the resource.

10. The computer-implemented method of claim 1, further comprising, responsive to receipt of the third user input, displaying an element selected from the group consisting of the primary data visualization and the first secondary data visualization.

11. The computer-implemented method of claim 1, wherein applying the criteria to the database comprises determining that the first secondary data set includes at least a portion of data from the primary data set.

12. The computer-implemented method of claim 1, wherein applying the criteria to the database comprises determining that the first secondary data set does not include more than a maximum number of data values.

13. The computer-implemented method of claim 1, wherein applying the criteria to the database comprises determining that the first secondary data set does not include fewer than a minimum number of data values.

14. The computer-implemented method of claim 1, wherein applying the criteria to the database comprises determining that the first secondary data set comprises data values that are dimensions.

15. The computer-implemented method of claim 1, wherein applying the criteria to the database comprises determining that the first secondary data set comprises data values that are of a data type different from that of data values of the primary data set.

16. The computer-implemented method of claim 1, wherein applying the criteria to the database comprises determining that the first secondary data set comprises data values comprising a descriptor different from that of data values of the primary data set.

17. The computer-implemented method of claim 1, wherein applying the criteria to the database comprises determining that the first secondary data set comprises data values contained within a previous data set graphically illustrated by a previous data visualization previously selected for viewing by a user.

18. The computer-implemented method of claim 1, wherein applying the criteria to the database comprises determining that the first secondary data set comprises data values comprising a data parameter that is the same as that of data values of a previous data set graphically illustrated by a previous data visualization previously selected for viewing by a user.

19. A computer program product for suggesting data visualizations, comprising:

a non-transitory storage medium; and

computer program code, encoded on the medium, configured to cause at least one processor to perform the steps of;

causing an input device to receive a first user input selecting a primary data visualization;

responsive to receipt of the first user input, causing a display device to display the primary data visualization that graphically illustrates a primary data set of a database;

responsive to receipt of the first user input, automatically applying criteria to the database to identify a first secondary data set of the database that meets the criteria; and

causing the display device to display a first secondary data visualization that graphically illustrates the first secondary data set;

recording an analysis path by recording a first decision record comprising user selection of the first secondary data visualization;

causing the display device to display an analysis path playback user interface comprising a plurality of decision records comprising the first decision record; and

causing the input device to receive a third user input selecting the first decision record from the plurality of decision records.

20. The computer program product of claim 19, wherein the computer program code is further configured to cause the at least one processor, after display of the first secondary data visualization, to perform steps of:

causing the input device to receive a fourth user input selecting a first tertiary data visualization that graphically illustrates a first tertiary data set; and

responsive to receipt of the fourth user input, causing the display device to display the first tertiary data visualization;

wherein recording the analysis path further comprises recording a second decision record comprising user selection of the first tertiary data visualization;

and wherein the computer program code is further configured to cause the at least one processor to perform the steps of;

causing the display device to display the second decision record;

causing the input device to receive a fifth user input selecting a second tertiary data visualization that graphically illustrates a second tertiary data set;

responsive to receipt of the fifth user input, causing the display device to display the second tertiary data visualization; and

revising the analysis path such that the second decision record comprises user selection of the second tertiary data visualization.

21. The computer program product of claim 19, wherein the computer program code is further configured to cause the at least one processor, after display of the first secondary data visualization, to perform steps of:

causing the input device to receive a fourth user input selecting a resource selected from the group consisting of a document, a multimedia file, and a web site; and

responsive to receipt of the fourth user input, causing the display device to display the selected resource;

and wherein the computer program code is further configured to cause the at least one processor to record the analysis path by recording a second decision record comprising user selection of the resource.

22. The computer program product of claim 19, wherein the computer program code is further configured to cause the at least one processor, after display of the first secondary data visualization, to perform the steps of:

responsive to receipt of the third user input, causing the display device to display an element selected from the group consisting of the primary data visualization and the first secondary data visualization.

23. The computer program product of claim 19, wherein the computer program code configured to cause the at least one processor to apply the criteria to the database comprises computer program code configured to cause the at least one processor to perform a step selected from the group consisting of:

determining that the first secondary data set includes at least a portion of data from the primary data set;

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

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

determining that the first secondary data comprises data values that are dimensions;

determining that the first secondary data set comprises data values that are of a data type different from that of data values of the primary data set;

determining that the first secondary data set comprises data values comprising a descriptor different from that of data values of the primary data set;

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

determining that the first secondary data set comprises data values comprising a data parameter that is the same as that of data values of the previous data set graphically illustrated by the previous data visualization previously selected for viewing by a user.

24. The computer program product of claim 19, wherein the at least one processor performs a step comprising causing the display device to automatically display a first indicator representative of the first secondary data visualization, wherein the first indicator is selectable by a user to initiate display of the first secondary data visualization.

25. The computer program product of claim 24, wherein the computer program code configured to cause the at least one processor to cause the display device to perform the step comprising causing the display device to automatically display the first indicator, wherein the computer program code is further configured to cause the at least one processor to perform steps of:

causing the input device to receive a second user input selecting the first indicator; and

responsive to receipt of the second user input, causing the display device to display the first secondary data visualization.

26. The computer program product of claim 25, wherein the computer program code is further configured to cause the at least one processor, prior to receipt of the second user input, to perform the steps of:

applying the criteria to the database to identify a second secondary data set of the database that meets the criteria and includes at least a portion of data from the primary data set; and

causing the display device to display a second indicator representative of the second secondary data set, wherein the second indicator is selectable by the user to initiate display of a second secondary data visualization that graphically illustrates the second secondary data set.

27. The computer program product of claim 25, wherein the computer program code is further configured to cause the at least one processor, after display of the first secondary data visualization, to perform the steps of:

applying the criteria to the database to identify a tertiary data set of the database that meets the criteria and includes at least a portion of data from the first secondary data set;

causing the display device to display a third indicator representative of a tertiary data visualization that graphically illustrates the tertiary data set;

causing the input device to receive a fourth user input selecting the third indicator; and

responsive to receipt of the fourth user input, causing the display device to display the tertiary data visualization.

28. A system for suggesting data visualizations, the system comprising:

an input device configured to receive a first user input selecting a primary data visualization;

a display device configured to, responsive to receipt of the first user input, display the primary data visualization that graphically illustrates a primary data set of a database;

a processor, communicatively coupled to the input device and the display device, configured to;

responsive to receipt of the first user input, automatically apply criteria to the database to identify a first secondary data set of the database that meets the criteria; and

cause the display device to automatically display a first secondary data visualization that graphically illustrates the first secondary data set;

record an analysis path by recording a first decision record comprising user selection of the first secondary data visualization;

cause the display device to display an analysis path playback user interface comprising a plurality of decision records comprising the first decision record; and

cause the input device to receive a third user input selecting the first decision record from the plurality of decision records.

29. The system of claim 28, wherein the processor is further configured to, after display of the first secondary data visualization:

cause the input device to receive a fourth user input selecting a first tertiary data visualization that graphically illustrates a first tertiary data set; and

cause the display device, responsive to receipt of the fourth user input, to display the first tertiary data visualization;

wherein the processor is further configured to record the analysis path by recording a second decision record comprising user selection of the first tertiary data visualization;

and wherein the processor is further configured to;

cause the display device to display the second decision record;

cause the input device to receive a fifth user input selecting a second tertiary data visualization that graphically illustrates a second tertiary data set;

cause the display device, responsive to receipt of the fifth user input, to display the second tertiary data visualization; and

revise the analysis path such that the second decision record comprises user selection of the second tertiary data visualization.

30. The system of claim 28, wherein the processor is further configured, after display of the first secondary data visualization, to:

cause the input device to receive a fourth user input selecting a resource selected from the group consisting of a document, a multimedia file, and a web site; and

cause the display device, responsive to receipt of the fourth user input, to display the selected resource;

and wherein the processor is further configured to record the analysis path by recording a second decision record comprising user selection of the resource.

31. The system of claim 28, wherein the processor is further configured, after display of the first secondary data visualization, to:

cause the display device, responsive to receipt of the third user input, to display an element selected from the group consisting of the primary data visualization and the first secondary data visualization.

32. The system of claim 28, wherein the processor is further configured to apply the criteria to the database by performing a step selected from the group consisting of:

determining that the first secondary data set includes at least a portion of data from the primary data set;

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

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

determining that the first secondary data comprises data values that are dimensions;

determining that the first secondary data set comprises data values that are of a data type different from that of data values of the primary data set;

determining that the first secondary data set comprises data values comprising a descriptor different from that of data values of the primary data set;

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

determining that the first secondary data set comprises data values comprising a data parameter that is the same as that of data values of a previous data set graphically illustrated by a previous data visualization previously selected for viewing by a user.

33. The system of claim 28, wherein the processor is further configured to cause the display device to perform a step comprising automatically display a first indicator representative of the first secondary data visualization, wherein the first indicator is selectable by a user to initiate display of the first secondary data visualization.

34. The system of claim 33, wherein the processor is further configured to cause the display device to perform the step by causing the display device to display the first indicator;

wherein the input device is further configured to receive a second user input selecting the first indicator;

and wherein the display device is further configured, responsive to receipt of the second user input, to display the first secondary data visualization.

35. The system of claim 34, wherein the processor is further configured, prior to receipt of the second user input, to:

apply the criteria to the database to identify a second secondary data set of the database that meets the criteria and includes at least a portion of data from the primary data set; and

cause the display device to display a second indicator representative of the second secondary data set, wherein the second indicator is selectable by the user to initiate display of a second secondary data visualization that graphically illustrates the second secondary data set.

36. The system of claim 34, wherein the processor is further configured, after display of the first secondary data visualization, to:

apply the criteria to the database to identify a tertiary data set of the database that meets the criteria and includes at least a portion of data from the first secondary data set;

cause the display device to display a third indicator representative of a tertiary data visualization that graphically illustrates the tertiary data set;

cause the input device to receive a fourth user input selecting the third indicator; and

responsive to receipt of the fourth user input, cause the display device to display the tertiary data visualization.