Granted Patent B2

US 12,430,003 · App. 18/508,180 · Granted Sep 30, 2025

Inventors: Jun Kim (Sammamish, WA); Will Pugh (Seattle, WA); Isaac Kunen (Seattle, WA)

Assignee: Tableau Software, Inc.

G06F3/0482G06F3/04845G06F8/38G06F16/254G06F16/26G06T11/206G06F9/451G06F2203/04803

Abstract

Claims (81)

1. A method of preparing data for subsequent analysis, comprising:

at a computer system having a display, one or more processors, and memory storing one or more programs configured for execution by the one or more processors:

displaying a user interface that includes a concurrent display of a data flow pane, a profile pane, and a data pane, including displaying, in the data flow pane, a flow diagram including a plurality of linked nodes, each node specifying (i) a respective operation performed on respective data of a selected data source and (ii) a respective intermediate data set of transformed data that is generated upon execution of the respective operation, wherein at least some of the transformed data is distinct from the respective data of the selected data source;

receiving user selection of one or more nodes, from the plurality of linked nodes, in the flow diagram;

in response to receiving the user selection:

displaying, in the profile pane, schemas corresponding to the selected one or more nodes, including (1) data elements showing information about data fields of one or more intermediate data sets of transformed data, corresponding to the selected one or more nodes, and (2) statistical information about data values for the data fields:

determining a sample of data rows corresponding to the one or more intermediate data sets of transformed data; and

displaying, in the data pane, the sample of data rows corresponding to the one or more intermediate data sets of transformed data;

receiving, via the profile pane, a first user interaction to modify a first data element of the data elements in the profile pane; and

in response to receiving the first user interaction via the profile pane, modifying the flow diagram displayed in the data flow pane, including:

identifying an operation to perform that encapsulates the first user interaction; and

updating the selected one or more nodes, or adding a new node, to include the operation in the flow diagram.

2. The method of claim 1 , further comprising:

receiving a first user action on a first data range for a first data field in the profile pane; and

in response to receiving the first user action:

identifying the operation to perform as a filter operation; and

adding a new node to the flow diagram that filters data to the first data range.

3. The method of claim 1 , further comprising:

receiving a second user interaction in the profile pane to map data ranges for a first data field to specified values; and

in response to receiving the second user interaction, adding a new node to the flow diagram that performs the mapping specified in the second user interaction.

4. The method of claim 1 , further comprising:

receiving a second user interaction with a first data value from the sample of data rows that are displayed in the data pane; and

in response to receiving the second user interaction, adding a new node, to the flow diagram, that filters data to the first data value.

5. The method of claim 1 , further comprising:

receiving a user modification of a first data value of a first data field in the data pane; and

in response to receiving the user modification, adding a new node, to the flow diagram, the new node specifying a modification operation to each row of data whose data value for the first data field equals the first data value.

6. The method of claim 1 , further comprising:

in response to receiving a first user action on a first data field in the data pane, adding a new node, to the flow diagram, that splits the first data field into two or more separate data fields.

7. The method of claim 1 , further comprising:

updating the profile pane and data pane asynchronously as selections are made in the data flow pane.

8. The method of claim 1 , wherein further comprising displaying, in the profile pane, one or more histograms that include distributions of data values for data fields.

9. A computer system for preparing data for subsequent analysis, comprising:

one or more processors;

memory; and

one or more programs stored in the memory and configured for execution by the one or more processors, the one or more programs comprising instructions for:

displaying a user interface that includes a concurrent display of a data flow pane, a profile pane, and a data pane, including displaying, in the data flow pane, a flow diagram including a plurality of linked nodes, each node specifying (i) a respective operation performed on respective data of a selected data source and (ii) a respective intermediate data set of transformed data that is generated upon execution of the respective operation, wherein at least some of the transformed data is distinct from the respective data of the selected data source;

receiving user selection of one or more nodes, from the plurality of linked nodes, in the flow diagram;

in response to receiving the user selection:

displaying, in the profile pane, schemas corresponding to the selected one or more nodes, including (1) data elements showing information about data fields of one or more intermediate data sets of transformed data, corresponding to the selected one or more nodes, and (2) statistical information about data values for the data fields:

determining a sample of data rows corresponding to the one or more intermediate data sets of transformed data; and

displaying, in the data pane, the sample of data rows corresponding to the one or more intermediate data sets of transformed data;

receiving, via the profile pane, a first user interaction to modify a first data element of the data elements in the profile pane; and

in response to receiving the first user interaction via the profile pane, modifying the flow diagram displayed in the data flow pane, including:

identifying an operation to perform that encapsulates the first user interaction; and

updating the selected one or more nodes, or adding a new node, to include the operation in the flow diagram.

10. The computer system of claim 9 , wherein the data elements showing information about data fields displayed in the profile pane includes data ranges for a first data field.

11. The computer system of claim 9 , the one or more programs further comprising instructions for:

receiving a first user action on a first data range for a first data field in the profile pane; and

in response to receiving the first user action:

identifying the operation to perform as a filter operation; and

adding a new node to the flow diagram that filters data to the first data range.

12. The computer system of claim 9 , the one or more programs further comprising instructions for:

receiving a second user interaction in the profile pane to map the data ranges for a first data field to specified values; and

in response to receiving the second user interaction, adding a new node to the flow diagram that performs the mapping specified in the second user interaction.

13. The computer system of claim 9 , the one or more programs further comprising instructions for:

receiving a second user interaction with a first data value from the sample of data rows that are displayed in the data pane; and

in response to receiving the second user interaction, adding a new node, to the flow diagram, that filters data to the first data value.

14. The computer system of claim 9 , the one or more programs further comprising instructions for:

receiving a user modification of a first data value of a first data field in the data pane; and

in response receiving the user modification, adding a new node, to the flow diagram, the new node specifying a modification operation to each row of data whose data value for the first data field equals the first data value.

15. The computer system of claim 9 , wherein the profile pane and data pane are configured to update asynchronously as selections are made in the data flow pane.

16. The computer system of claim 9 , the one or more programs further comprising instructions for:

displaying, in the profile pane, one or more histograms that include distributions of data values for data fields.

17. The computer system of claim 9 , the one or more programs further comprising instructions for:

in response to receiving a first user action on a first data field in the data pane, adding a new node, to the flow diagram, that splits the first data field into two or more separate data fields.

18. A non-transitory computer readable storage medium storing one or more programs configured for execution by a computer system having one or more processors, memory, and a display, the one or more programs comprising instructions for:

displaying a user interface that includes a concurrent display of a data flow pane, a profile pane, and a data pane, including displaying, in the data flow pane, a flow diagram including a plurality of linked nodes, each node specifying (i) a respective operation performed on respective data of a selected data source and (ii) a respective intermediate data set of transformed data that is generated upon execution of the respective operation, wherein at least some of the transformed data is distinct from the respective data of the selected data source;

receiving user selection of one or more nodes, from the plurality of linked nodes, in the flow diagram;

in response to receiving the user selection:

displaying, in the profile pane, schemas corresponding to the selected one or more nodes, including (1) data elements showing information about data fields of one or more intermediate data sets of transformed data, corresponding to the selected one or more nodes, and (2) statistical information about data values for the data fields;

determining a sample of data rows corresponding to the one or more intermediate data sets of transformed data; and

displaying, in the data pane, the sample of data rows corresponding to the one or more intermediate data sets of transformed data:

receiving, via the profile pane, a first user interaction to modify a first data element of the data elements in the profile pane; and

in response to receiving the first user interaction via the profile pane, modifying the flow diagram displayed in the data flow pane, including:

identifying an operation to perform that encapsulates the first user interaction; and

updating the selected one or more nodes, or adding a new node, to include the operation in the flow diagram.

19. The non-transitory computer readable storage medium of claim 18 , the one or more programs further comprising instructions for:

receiving a user modification of a first data value of a first data field in the data pane; and

in response receiving the user modification, adding a new node, to the flow diagram, the new node specifying a modification operation to each row of data whose data value for the first data field equals the first data value.

20. The non-transitory computer readable storage medium of claim 18 , the one or more programs further comprising instructions for:

in response to receiving a first user action on a first data field in the data pane, adding a new node, to the flow diagram, that splits the first data field into two or more separate data fields.

Continuity (2)

References Cited (213)