Generating data analysis dashboard templates for selected data sources
A method generates data analysis templates. A computing device receives, via a graphical user interface, a natural language input, which includes multiple terms. The terms include one or more data fields and/or data values from a data source. The device designates the natural language input as trigger text for a data analysis template. The trigger text includes the multiple terms. A user defines one or more rules for a subset of the terms, each rule specifying respective criteria to match a respective term in the subset. A user specifies multiple data visualizations corresponding to the trigger text. Each of the data visualizations (i) uses a respective one or more data fields, from the data source, corresponding to terms from the trigger text and (ii) has a respective data visualization type. The device generates the data analysis template according to the trigger text, the user definition, and the user specification.
1. A method of generating data analysis templates for visual analytics, comprising:
at a computing device having a display, one or more processors, and memory comprising one or more programs for execution by the one or more processors, including instructions to perform:
receiving, via a graphical user interface, a first natural language input that includes a plurality of terms;
identifying from a plurality of data sources a data source relevant to the first natural language input, the plurality of data sources stored on the computing device or stored remotely, wherein the plurality of terms correspond to at least a first data field of one or more data fields and/or data values from the data source;
designating the first natural language input as trigger text for generating a first data analysis template, the trigger text including the plurality of terms;
receiving, via the graphical user interface, user specification of one or more data visualizations corresponding to the trigger text, each of the one or more data visualizations (i) using a respective one or more data fields, from the data source, corresponding to terms from the trigger text, (ii) having a respective data visualization type; and (iii) corresponding to a respective set of phrases that define the respective data visualization;
receiving a user input for converting the first data field in the trigger text to a first parameterized term;
generating the first data analysis template according to the trigger text, the user input, and the user specification, wherein the first data analysis template includes (i) a parameterized query including the first parameterized term and (ii) a respective updated set of phrases, corresponding to each of the one or more data visualizations, wherein the first data field in the respective set of phrases is replaced by the first parameterized term in the respective updated set of phrases;
rendering the first data analysis template on the graphical user interface, including displaying the first parameterized term with a different visual characteristic from other phrases in the respective set of phrases; and
saving the first data analysis template for subsequent use, wherein in response to receipt of the trigger text via the graphical use interface the computing device initiates a search of the data source using the parameterized query and displays, on the graphical user interface, results of the parameterized query using the one or more data visualizations.
2. The method of claim 1 , further comprising:
receiving, via the graphical user interface, user definition of one or more rules for a subset of terms in the plurality of terms, wherein each rule specifies respective criteria to match a respective term in the subset, and wherein the user definition of the one or more rules includes user designation of:
one or more first terms in the subset as required terms; and
a second term in the subset as an optional term.
3. The method of claim 2 , wherein the one or more first terms include one or more fixed terms.
4. The method of claim 2 , wherein the one or more first terms include one or more variable terms.
5. The method of claim 4 , wherein the one or more variable terms include one or more of:
a variable dimension expression that is limited to being replaced by dimension fields from the data source;
a variable field expression that is limited to being replaced by a subset of data fields from the data source; and
a variable superlative expression that is limited to being replaced by a superlative adjective and a data field from the data source.
6. The method of claim 1 , further comprising receiving user identification of one or more additional data sources for which the first data analysis template is designated.
7. The method of claim 1 , wherein the user specification of the one or more data visualizations further comprises user specification of an order in which the one or more data visualizations are to be displayed.
8. The method of claim 1 , wherein the first natural language input is received via an input box of the graphical user interface.
9. The method of claim 1 , further comprising:
after generating the first data analysis template:
receiving user submission of the first natural language input; and
in response to receiving the user submission:
generating and displaying a first dashboard, corresponding to the first data analysis template, including displaying the one or more data visualizations.
10. The method of claim 1 , further comprising:
displaying, in the graphical user interface, a visualization customization region that includes:
the one or more data visualizations; and
for each of the data visualizations, a respective plurality of phrases that define the respective data visualization.
11. The method of claim 10 , wherein the respective plurality of phrases for a first data visualization includes a first phrase that identifies the first data field.
12. The method of claim 10 , wherein the respective plurality of phrases for a first data visualization includes a first phrase that identifies a second data field, from the data source, that is not included in the first natural language input.
13. The method of claim 1 , wherein the respective data visualization type is selected from the group consisting of a bar chart, a Gantt chart, a line chart, a map, a pie chart, a scatter plot, a tree map, and a text table.
14. A computing device, comprising:
a display device;
one or more processors; and
memory coupled to the one or more processors, the memory storing one or more programs configured to be executed by the one or more processors, the one or more programs including instructions for:
receiving, via a graphical user interface, a first natural language input that includes a plurality of terms;
identifying from a plurality of data sources a data source relevant to the first natural language input, the plurality of data sources stored on the computing device or stored remotely, wherein the plurality of terms correspond to at least a first data field of one or more data fields and/or data values from the data source;
designating the first natural language input as trigger text for generating a first data analysis template, the trigger text including the plurality of terms;
receiving, via the graphical user interface, user specification of one or more data visualizations corresponding to the trigger text, each of the one or more data visualizations (i) using a respective one or more data fields, from the data source, corresponding to terms from the trigger text, (ii) having a respective data visualization type; and (iii) corresponding to a respective set of phrases that define the respective data visualization;
receiving a user input for converting the first data field in the trigger text to a first parameterized term;
generating the first data analysis template according to the trigger text, the user input, and the user specification, wherein the first data analysis template includes (i) a parameterized query including the first parameterized term and (ii) a respective updated set of phrases, corresponding to each of the one or more data visualizations, wherein the first data field in the respective set of phrases is replaced by the first parameterized term in the respective updated set of phrases;
rendering the first data analysis template on the graphical user interface, including displaying the first parameterized term with a different visual characteristic from other phrases in the respective set of phrases; and
saving the first data analysis template for subsequent use, wherein in response to receipt of the trigger text via the graphical use interface the computing device initiates a search of the data source using the parameterized query and displays, on the graphical user interface, results of the parameterized query using the one or more data visualizations.
15. The computing device of claim 14 , the one or more programs including instructions for:
receiving, via the graphical user interface, user definition of one or more rules for a subset of terms in the plurality of terms, wherein each rule specifies respective criteria to match a respective term in the subset, and wherein the user definition of the one or more rules includes user designation of:
one or more first terms in the subset as required terms; and
a second term in the subset as an optional term.
16. The computing device of claim 15 , wherein the one or more first terms include one or more variable terms, the one or more variable terms including one or more of:
a variable dimension expression that is limited to being replaced by dimension fields from the data source;
a variable field expression that is limited to being replaced by a subset of data fields from the data source; and
a variable superlative expression that is limited to being replaced by a superlative adjective and a data field from the data source.
17. The computing device of claim 14 , wherein the respective data visualization type is selected from the group consisting of: a bar chart, a Gantt chart, a line chart, a map, a pie chart, a scatter plot, a tree map, and a text table.
18. A non-transitory computer-readable storage medium storing one or more programs configured for execution by one or more processors of a computing device that includes a display, the one or more programs comprising instructions for:
receiving, via a graphical user interface, a first natural language input that includes a plurality of terms;
identifying from a plurality of data sources a data source relevant to the first natural language input, the plurality of data sources stored on the computing device or stored remotely, wherein the plurality of terms correspond to at least a first data field of one or more data fields and/or data values from the data source;
designating the first natural language input as trigger text for generating a first data analysis template, the trigger text including the plurality of terms;
receiving, via the graphical user interface, user specification of one or more data visualizations corresponding to the trigger text, each of the one or more data visualizations (i) using a respective one or more data fields, from the data source, corresponding to terms from the trigger text, (ii) having a respective data visualization type; and (iii) corresponding to a respective set of phrases that define the respective data visualization;
receiving a user input for converting the first data field in the trigger text to a first parameterized term;
generating the first data analysis template according to the trigger text, the user input, and the user specification, wherein the first data analysis template includes (i) a parameterized query including the first parameterized term and (ii) a respective updated set of phrases, corresponding to each of the one or more data visualizations, wherein the first data field in the respective set of phrases is replaced by the first parameterized term in the respective updated set of phrases;
rendering the first data analysis template on the graphical user interface, including displaying the first parameterized term with a different visual characteristic from other phrases in the respective set of phrases; and
saving the first data analysis template for subsequent use, wherein in response to receipt of the trigger text via the graphical use interface, the computing device initiates a search of the data source using the parameterized query and displays, on the graphical user interface, results of the parameterized query using the one or more data visualizations.
19. The method of claim 2 , wherein the user definition further comprises user designation of one or more constraints on the one or more first terms, each constraint specifying a respective limited set of values that are designated as matching a respective one of the first terms.
20. The computing device of claim 15 , wherein the user definition further comprises user designation of one or more constraints on the one or more first terms, each constraint specifying a respective limited set of values that are designated as matching a respective one of the first terms.