Interactive user interface for dynamic data analysis exploration and query processing
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.
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 computer system to:
in response to receiving one or more user inputs defining sequential analyses to perform on a data set, generate an analysis path visualization,
wherein the analysis path visualization includes a hierarchical plurality of nodes corresponding to the sequential analyses,
wherein the nodes of the hierarchical plurality of nodes are visually joined to indicate hierarchical relationships among the nodes, and
wherein the nodes of the hierarchical plurality of nodes comprise icons representative of types of the respective sequential analyses.
2. The computer system of claim 1 , wherein at least one or more nodes of the hierarchical plurality of nodes further comprise indications of user inputs defining the sequential analyses.
3. The computer system of claim 2 , wherein the indications comprise query information provided by a user.
4. The computer system of claim 1 , wherein the software code, in response to execution by the one or more computer processors, further causes the computer system to:
in response to a first user input selecting a node of the hierarchical plurality of nodes, generate a data visualization based on the data set and an analysis associated with the node.
5. The computer system of claim 4 , wherein the software code, in response to execution by the one or more computer processors, further causes the computer system to:
cause display of the data path visualization and the data visualization adjacent to one another.
6. The computer system of claim 5 , wherein the software code, in response to execution by the one or more computer processors, further causes the computer system to:
in response to a second user input, update the data path visualization to display all paths associated with the sequential analyses.
7. The computer system of claim 1 , wherein the hierarchical plurality of nodes includes key nodes associated with the sequential analyses and not other non-key nodes associated with the sequential analyses.
8. A computer-implemented method comprising:
by one or more computer processors executing software code:
in response to receiving one or more user inputs defining sequential analyses to perform on a data set, generating an analysis path visualization,
wherein the analysis path visualization includes a hierarchical plurality of nodes corresponding to the sequential analyses,
wherein the nodes of the hierarchical plurality of nodes are visually joined to indicate hierarchical relationships among the nodes, and
wherein the nodes of the hierarchical plurality of nodes comprise icons representative of types of the respective sequential analyses.
9. The computer-implemented method of claim 8 , wherein at least one or more nodes of the hierarchical plurality of nodes further comprise indications of user inputs defining the sequential analyses.
10. The computer-implemented method of claim 9 , wherein the indications comprise query information provided by a user.
11. The computer-implemented method of claim 8 further comprising:
by the one or more computer processors executing software code:
in response to a first user input selecting a node of the hierarchical plurality of nodes, generating a data visualization based on the data set and an analysis associated with the node.
12. The computer-implemented method of claim 11 further comprising:
by the one or more computer processors executing software code:
causing display of the data path visualization and the data visualization adjacent to one another.
13. The computer-implemented method of claim 12 further comprising:
by the one or more computer processors executing software code:
in response to a second user input, updating the data path visualization to display all paths associated with the sequential analyses.
14. The computer-implemented method of claim 8 , wherein the hierarchical plurality of nodes includes key nodes associated with the sequential analyses and not other non-key nodes associated with the sequential analyses.
15. A computer program product comprising a computer readable storage medium having program instructions embodied therewith, the program instructions executable by one or more processors to cause the one or more processors to:
in response to receiving one or more user inputs defining sequential analyses to perform on a data set, generate an analysis path visualization,
wherein the analysis path visualization includes a hierarchical plurality of nodes corresponding to the sequential analyses,
wherein the nodes of the hierarchical plurality of nodes are visually joined to indicate hierarchical relationships among the nodes, and
wherein the nodes of the hierarchical plurality of nodes comprise icons representative of types of the respective sequential analyses.