Interactive user interface for dynamic data analysis exploration and query processing

• US 10,157,200 B2
• Filed: 04/07/2016
• Issued: 12/18/2018
• Est. Priority Date: 12/29/2014
• Status: Active Grant

• Current Assignee: Palantir Technologies Incorporated
• Original Assignee: Palantir Technologies Incorporated
• Inventors: Elliot, Mark, Duffield, Benjamin, Borochoff, Adam
• Primary Examiner(s): NABI, REZA U
• Application Number:
  US15/092,964
• Publication Number:
  US 20170102863A1
• Time in Patent Office: 985 Days
• Field of Search: 715771
• CPC Class Codes: G06F 16/2423 Interactive query statement specification based on a database schema
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06F 16/26 Visual data mining; Browsing structured data
• CPC Class Codes: G06F 3/04817 using icons graphical or visual programming using iconic symbols G06F8/34
• CPC Class Codes: G06F 3/0482 Interaction with lists of selectable items, e.g. menus
• CPC Class Codes: G06F 3/04842 Selection of displayed objects or displayed text elements G06F3/0482 takes precedence
• CPC Class Codes: G06F 3/04847 Interaction techniques to control parameter settings, e.g. interaction with sliders or dials

Abstract

The systems and methods described herein provide highly dynamic and interactive data analysis user interfaces which enable data analysts to quickly and efficiently explore large volume data sources. In particular, a data analysis system, such as described herein, may provide features to enable the data analyst to investigate large volumes of data over many different paths of analysis while maintaining detailed and retraceable steps taken by the data analyst over the course of an investigation, as captured via the data analyst'"'"'s queries and user interaction with the user interfaces provided by the data analysis system. Data analysis paths may involve exploration of high volume data sets, such as Internet proxy data, which may include trillions of rows of data. The data analyst may pursue a data analysis path that involves, among other things, applying filters, joining to other tables in a database, viewing interactive data visualizations, and so on.

Claims

1. A computer system comprising:

one or more computer processors configured to execute software code; and

a non-transitory storage medium storing software code that, when executed by the one or more computer processors causes the one or more computer processors to;

generate a first data visualization representing a first set of data items;

receive a selection of an element of the first data visualization representing a subset of the first set of data items;

generate, based on the selection, a second data visualization representing the subset of the first set of data items; and

generate an analysis path visualization including a visual representation of the first data visualization and a visual representation of the second data visualization, wherein the analysis path visualization is rendered as a hierarchical plurality of nodes wherein at least one or more nodes of the hierarchical plurality of nodes indicates query information selected by a user.

2. The computer system of claim 1, wherein the software code, in response to execution by the one or more computer processors, further causes the one or more computer processors to:

generate a user interface including first data visualization, the second data visualization, and the analysis path visualization; and

cause display of the user interface in an electronic display.

3. The computer system of claim 1, wherein generating the second data visualization comprises:

generating, based on the subset of the first set of data items, a query to apply to the first set of data.

4. The computer system of claim 3, wherein the query comprises one or more filters to apply to the first set of data, wherein the one or more filters are based on the selection.

5. The computer system of claim 1, wherein the first or second data visualization comprises at least one of:

a time series view, a time grid view, a pivot table view, or a data summary view.

6. The computer system of claim 1, wherein the software code, in response to execution by the one or more computer processors, further causes the one or more computer processors to:

receive a selection of an element of the second data visualization representing a subset of the first set of data items;

generate, based at least in part on the selection of the element of the second data visualization, a third data visualization; and

update the analysis path visualization to include a visual representation of the third data visualization.

7. The computer system of claim 6, wherein generating the third data visualization comprises:

generating, based at least in part on the selection of the element of the second data visualization, a query to apply to one or more sets of data including the first set of data.

8. The computer system of claim 7, wherein the query comprises a join operation to be performed with respect to a second set of data distinct from the first set of data.

9. The computer system of claim 1, wherein the selection comprises an indication of a range of values.

10. The computer system of claim 1, wherein the visual representations of the first and second data visualizations are selectable, and wherein the software code, in response to execution by the one or more computer processors, further causes the one or more computer processors to:

in response to selection of the visual representation of the first data visualization, cause display of the first data visualization in a user interface; and

in response to selection of the visual representation of the second data visualization, cause display of the second data visualization in the user interface.

11. A computer-implemented method comprising:

by one or more computer processors executing software code;

generating a first data visualization representing a first set of data items;

receiving a selection of an element of the first data visualization representing a subset of the first set of data items;

generating, based on the selection, a second data visualization representing the subset of the first set of data items; and

generating an analysis path visualization including a visual representation of the first data visualization and a visual representation of the second data visualization, wherein the analysis path visualization is rendered as a hierarchical plurality of nodes wherein at least one or more nodes of the hierarchical plurality of nodes indicates query information selected by a user.

12. The computer-implemented method of claim 11 further comprising:

by the one or more computer processors executing software code;

generating a user interface including first data visualization, the second data visualization, and the analysis path visualization; and

causing display of the user interface in an electronic display.

13. The computer-implemented method of claim 11, wherein generating the second data visualization comprises:

by the one or more computer processors executing software code;

generating, based on the subset of the first set of data items, a query to apply to the first set of data, wherein the query comprises one or more filters to apply to the first set of data, wherein the one or more filters are based on the selection.

14. The computer-implemented method of claim 11 further comprising:

by the one or more computer processors executing software code;

receiving a selection of an element of the second data visualization representing a subset of the first set of data items;

generating, based at least in part on the selection of the element of the second data visualization, a third data visualization; and

updating the analysis path visualization to include a visual representation of the third data visualization.

15. The computer-implemented method of claim 14, wherein generating the third data visualization comprises:

by the one or more computer processors executing software code;

generating, based at least in part on the selection of the element of the second data visualization, a query to apply to one or more sets of data including the first set of data.

16. The computer-implemented method of claim 15, wherein the query comprises a join operation to be performed with respect to a second set of data distinct from the first set of data.

17. The computer-implemented of claim 11, wherein the selection comprises an indication of a range of values.

18. The computer-implemented method of claim 11, wherein the visual representations of the first and second data visualizations are selectable, and wherein the computer-implemented method further comprises:

by the one or more computer processors executing software code;

in response to selection of the visual representation of the first data visualization, causing display of the first data visualization in a user interface; and

in response to selection of the visual representation of the second data visualization, causing display of the second data visualization in the user interface.

19. The computer-implemented method of claim 11, wherein the analysis path visualization includes a visual representation of multiple paths associated with a plurality of data visualizations including the first data visualization and the second data visualization.

20. A non-transitory computer readable storage medium having computer-executable instructions stored thereon, the computer-executable instructions executable by a computing system having one or more hardware processors, wherein the computer-executable instructions are executable to perform operations comprising:

generating a first data visualization representing a first set of data items;

receiving a selection of an element of the first data visualization representing a subset of the first set of data items;

generating, based on the selection, a second data visualization representing the subset of the first set of data items; and

generating an analysis path visualization including a visual representation of the first data visualization and a visual representation of the second data visualization, wherein the analysis path visualization is rendered as a hierarchical plurality of nodes wherein at least one or more nodes of the hierarchical plurality of nodes indicates query information selected by a user.