Tableau Software, Inc.

A computer system displays a user interface that includes a data flow region, a data profiling region, and a data preview region. The system displays, in the data flow region, an interactive flow diagram having a plurality of linked nodes, where at least one node of the plurality of linked nodes indicates one or more data transformation operations performed on data of a data source. The system displays, in the data preview region, a sample of data values and concurrently displays, in the data profiling region, statistical information about the sample of data values. The system receives a user interaction to modify at least one data value of the sample of data values. In response to receiving the user interaction, the system modifies the at least one data value and updates the interactive flow diagram in a manner that is responsive to the user interaction.

A computer system displays a user interface that includes a data flow pane, a profile pane, and a data pane. The data flow pane displays a flow diagram including a plurality of linked nodes. Each node specifies a respective operation and a respective intermediate data set generated upon execution of the respective operation. The profile pane displays schemas corresponding to selected nodes in the flow diagram, including (1) data elements showing information about data fields and (2) statistical information about data values for the data fields. User interaction to modify any of the data elements in the profile pane modifies the flow diagram displayed in the data flow pane. The data pane displays rows of intermediate data sets corresponding to selected nodes in the flow diagram. User interaction with individual data values from the displayed rows of data modifies the flow diagram displayed in the data flow pane.

A computer receives user selection of data fields from a data source and user placement of the data fields into a shelf region of a user interface. The computer obtains a data model encoding the data source as a tree of related logical tables. Each logical table includes logical fields, each of which corresponds to either a dimension or a measure. The computer generates a dimension subquery for the dimensions. The computer also generates, for each measure, an aggregated measure subquery grouped by the dimensions. The computer forms a final query by joining the dimension subquery to each of the aggregated measure subqueries. The computer subsequently executes the final query and displays a data visualization according to the results of the final query.

A system displays a tree of class icons in a model region. While displaying the tree, the system detects a first portion of an input to place a candidate class icon in the model region. In response, the system (i) identifies a neighboring class icon, in the tree of class icons, that is nearest to the candidate class icon, where the neighboring class icon is circumscribed by a revealer region, and (ii) when the location of the candidate class icon is outside the revealer region, displaying a tentative connector, between the candidate class icon and the neighboring class icon. The system detects a second portion of the user input. In response to the detection, the system presents options for user selection of JOIN fields, including displaying a first data field selection list for the candidate class icon and a second data field selection list for the neighboring class icon.

A method executes at a computer system to retrieve data from a database. Upon receiving a database query, the computer system translates the query into an intermediate representation, and estimates a compilation time to compile the intermediate representation into machine executable code. The query execution time to retrieve a result set is also estimated. In accordance with a determination that the query execution time and compilation time satisfy an interpretation criterion, the computer system invokes a byte code interpreter to interpret the intermediate representation and retrieve the result set from the database. In accordance with a determination that the query execution and compilation times satisfy one of a plurality of compilation criteria, the computer system compiles the intermediate representation to form machine code and executes the machine code to retrieve the result set from the database. In some cases, the query intermediate representation is optimized prior to compilation.

A computer system obtains a data model that encodes a data source as a tree of logical tables. Each logical table includes respective data fields of the data source. For each data field in the logical tables, the system automatically assigns a semantic role to the data field based on a concept obtained from a concept graph, a data type of the data field, and data values of the data field. The system determines hierarchies between the data field and other data fields in the data source based on their respective semantic roles. The system validates the data field based on the assigned semantic role and the determined hierarchies. The system displays transformations to clean the data field based on the assigned semantic role. The system transforms data values for the data field according to a user input and updates the logical tables according to the transforming.

A computing device parses a user-specified natural language command to form a first expression. The computing device determines that the first expression is ambiguous or underspecified. The computing device, in accordance with the determination, infers first information using one or more inferencing rules, where at least one of the inferencing rules is based on an attribute of data fields and/or data values in a data source. The computing device forms a second expression based on the first expression using and the first information. The computing device retrieves one or more data sets from the data source using according to the second expression. The computing device generates and displays a data visualization of the retrieved one or more data sets.

A computer user interface displays a two-dimensional grid of data values. A user selects a first set of two or more columns of data values from the grid, and the computer performs a first pivot on the first set of two or more columns to form a modified grid having a plurality of new rows and a first set of two or more new columns. The user selects a second set of two or more columns of data values from the grid. The second set is distinct from the first set. The computer performs a second pivot on the second set of two or more columns to form a second new column added to the modified grid. Each data value from the second set of two or more columns is added to the second new column in a respective row of the new rows. The computer redisplays the modified grid.

A computer receives user selection of data fields from a data source and user placement of the data fields into a shelf region of a user interface. The computer obtains a data model encoding the data source as a tree of related logical tables. Each logical table includes logical fields, each of which corresponds to either a dimension or a measure. The computer generates a dimension subquery for the dimensions. The computer also generates, for each measure, an aggregated measure subquery grouped by the dimensions. The computer forms a final query by joining the dimension subquery to each of the aggregated measure subqueries. The computer subsequently executes the final query and displays a data visualization according to the results of the final query.

A method executes at a computing device that includes a display, one or more processors, and memory. The device displays a data visualization based on a dataset retrieved from a database. The device also displays one or more first phrases in a first region. The first phrases define the data visualization. The device receives a first user input in a second region to specify a natural language command related to the displayed data visualization. In response to the first user input, the device displays one or more proposed actions. The device receives user selection of a first proposed action of the proposed actions. In response to the user selection, the device generates an updated data visualization. The device displays the updated data visualization and displays a plurality of second phrases in the first region. The second phrases define the updated data visualization.