Interactive user interface for dynamic data analysis exploration and query processing
View Patent ↗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 hardware computer processors configured to execute code in order to cause the one or more hardware computer processors to:
provide a user interface configured to display at least a first panel, a second panel, and a third panel, wherein:
the first panel is configured to provide an analysis path visualization,
the second panel is configured to provide one or more selectable elements for analyzing one or more data sets, and
the third panel is configured to provide one or more data visualizations;
in response to a first user input selecting a first selectable element of the one or more selectable elements:
determine a first analysis type associated with the first selectable element;
add a first data visualization to the third panel representing results of an analysis of the first analysis type of a data set; and
add a first icon to the first panel representing the first analysis type associated with the first selectable element; and
in response to a second user input selecting a second selectable element of the one or more selectable elements:
determine a second analysis type associated with the second selectable element;
add a second icon to the first panel representing the second analysis type associated with the second selectable element; and
add an edge to the first panel connecting the first and second icons so as to visually indicate an analysis path.
2. The computer system of claim 1 , wherein the one or more hardware computer processors are configured to execute code in order to cause the one or more hardware computer processors to further:
in response to a third user input, based on the analysis path, apply the analysis of the first analysis type to the data set to generate a first analyzed one or more data sets; and
apply a second analysis of the second analysis type to the first analyzed one or more data sets to generate a second analyzed one or more data sets.
3. The computer system of claim 2 , wherein the one or more hardware computer processors are configured to execute code in order to cause the one or more hardware computer processors to further:
provide a second data visualization representing the second analyzed one or more data sets.
4. The computer system of claim 3 , 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.
5. The computer system of claim 1 , wherein the first and second icons include at least a symbol representative of the respective first and second analysis types.
6. The computer system of claim 1 , wherein the first or second analysis types include at least one of: a filter operation, or a join or merge operation.
7. The computer system of claim 1 , wherein the one or more hardware computer processors are configured to execute code in order to cause the one or more hardware computer processors to further:
in response to a third user input selecting a third selectable element of the one or more selectable elements:
determine a third analysis type associated with the third selectable element;
add a third icon to the first panel representing the third analysis type associated with the third selectable element; and
add a second edge to the first panel connecting the first and third icons so as to visually indicate a second analysis path different from the first analysis path.
8. The computer system of claim 1 , wherein the one or more hardware computer processors are configured to execute code in order to cause the one or more hardware computer processors to further:
generate, based on the analysis path, a query to apply to the one or more data sets; and
apply the query to the one or more data sets.
9. The computer system of claim 8 , wherein the query comprises one or more filters or merge operations to apply to the one or more data sets.
10. The computer system of claim 1 , wherein the one or more hardware computer processors are configured to execute code in order to cause the one or more hardware computer processors to further:
further in response to the second user input, add a second data visualization to the third panel representing results of an analysis of the second analysis type of at least part of the data set.
11. The computer system of claim 10 , wherein the one or more hardware computer processors are configured to execute code in order to cause the one or more hardware computer processors to further:
further in response to the second user input, perform the analysis of the second analysis type of the at least part of the data set.
12. The computer system of claim 11 , wherein the one or more hardware computer processors are configured to execute code in order to cause the one or more hardware computer processors to further:
spatially position the second data visualization below the first data visualization in the third panel.
13. The computer system of claim 11 , wherein the at least part of the data set comprises a result of the analysis of the of the first analysis type of the data set.
14. The computer system of claim 1 , wherein the one or more hardware computer processors are configured to execute code in order to cause the one or more hardware computer processors to further:
provide the first, second, and third panels for simultaneous display in the user interface.
15. The computer system of claim 1 , wherein the one or more hardware computer processors are configured to execute code in order to cause the one or more hardware computer processors to further:
further in response to the first user input, perform the analysis of the first analysis type of the data set.