Tableau Software, Inc.

Microsoft Technology Licensing, LLC

Salesforce, Inc.

Thomas Nhan

Susan Denise Doan

Elaine Weatherfield Sulc

David Pace

Jeffrey Mark Booth, Jr

Justin Talbot

Daniel Cory

Mathew Henry Luebbert

Michael Jay Gilmore

Tyler Robert Adams

Stephanie Horn

Alexandre Gueniot

Jie Li

Onur Onder

Nicolas Ratigan Borden

Matthew William Kernek

Constance Worsfold Gervais

Thomas R Mignone

Ramya Tridandapani

Bharat Kumar Ahuja

Heather Joanne Alekson

Garrett William Brown

Eric Minghai Gao

Allan Folting

Michael Alexander Fuller

Adam Ross Le Doux

Chris Welman

Jordan Krissi

Christian Gabriel Eubank

Amy Nicole Forstrom

Gideon Goldin

Lauren Christina Lum

Minkyeong Kim

Lena Protasov

Randall Moss

Allison Chia-Chun Sun

Russell Steven Paul-Jones

Tyler Martin

Yuwen Li

Mallika Manoj Malkani

Rakhi Harkawat

Haya Gur

Ryan Neil Travitz

Zeki Melek

Alvin Leung

Jinbo Feng

Franz Gustave Amador

Marian Simo Boitel

Jay Xu

Jordan Yee Ott

Caleb Marc Rouleau

Ganna Lomova

Nylah Ann McClellan DePass

A computing device displays a first object icon representing a first object of a first data source and a second object icon, representing a second object of the first data source. The first object icon is connected to the second object icon via a first connector representing a relationship between the first object and the second object. In response to receiving a first user input to add a third object, the computing device displays a third object icon representing the third object. In response to receiving a second user input on the third object icon, in accordance with a determination that the second object and the third object include at least one common data field, the computing device displays a second connector, connecting the third object icon to the second object icon.

Creation and consumption of data models that span multiple sets of facts

A computer system displays a data visualization in a data visualization user interface. In response to detecting a user input that selects a subset of visual data marks from the data visualization, the computer system displays a summary of the selected subset of visual data marks in a summary tab of a view data window. When the computer system determines that the selected subset of visual marks (1) corresponds to a plurality of data fields and (2) references a row-level calculation that uses logical fields from at least two logical tables of a plurality of logical tables of a data model, the computer system (i) generates a representation of the row-level calculation and (ii) displays the representation of the row-level calculation as a first tab in the view data window, distinct from the summary tab.

System and method for visually analyzing row-level calculations for data visualizations across multiple data tables including displaying separate tabs for the row-level calculations and visual data marks summary

A computing device displays, in a user interface, data field icons corresponding to a plurality of data fields. Each of the data fields is associated with a respective object in an object model. In response to receiving (i) user selection of a first data field icon corresponding to a first data field, and (ii) placement of the first data field icon in a shelf region of the user interface, where the first data field is associated with a first object of the object model, the computing device generates a first data visualization and updates a visual characteristic of a subset of the data field icons from a first visual characteristic to a second visual characteristic. Each data field icon in the subset is associated with a second object of the object model. The data field icons in the subset are user-selectable independently of the first or second visual characteristic.

Infoscenting fields for multi-fact data model analysis using shared dimensions

A computing device receives user input specifying a first dimension data field and a second dimension data field. The device constructs a dimension subquery according to characteristics of the first dimension data field, the second dimension data field, a first object to which the first dimension data field belongs, and/or a second object to which the second dimension data field belongs, including determining a join type for combining (i) first data rows that include data values of the first dimension data field and (ii) second data rows that include data values of the second dimension data field. The device constructs the dimension subquery according to the determined join type, and executes the dimension subquery to retrieve first tuples. The device constructs measure subqueries and executes the measure subqueries to retrieve second tuples. The device forms extended tuples, and generates and displays the data visualization according to the extended tuples.

Query semantics for multi-fact data model analysis using shared dimensions

A computing device generates and displays a data visualization in a data visualization user interface. The data visualization includes a plurality of visual data marks representing data from a data source. The computing device detects a first user input to select a visual data mark of the plurality of visual data marks. In response to detecting the first user input, the computing device identifies a first aggregated data value, for the visual data mark, corresponding to a first data field in the data source. The computing device retrieves a first disaggregated set of data rows corresponding to the first aggregated data value, from a first table, in the data source, containing the first data field. The computing device displays, in the data visualization user interface, a plurality of data rows from the first disaggregated set of data rows.

Using an object model to view data associated with data marks in a data visualization

A method for generating data visualizations includes receiving user selection of a data source, and receiving user input to define a dynamic set according to: (i) user selection of visual marks in a visualization region and/or (ii) user specification of a parameter corresponding to data fields in the data source. The method also includes receiving user input to define a calculation to compare data values for a data field from the data source to data values in the dynamic set. The method further includes identifying a set of rows from the data source whose data values are included in the dynamic set. The method also includes receiving user input to place a data field from the data source in a shelf region, and displaying a data visualization that includes a plurality of visual marks corresponding to data values, of the data field, in the set of rows.

Visual analysis platform utilizing dynamic group data elements in custom calculations

A computing device displays a data visualization user interface that includes a schema region. Each data field displayed in the schema region is visually associated with a respective data object of a plurality of data objects in an object model. The device receives user input to specify a mathematical expression that includes a first data field from a first object and a second data field from a second object. The first object and the second object are distinct objects in the object model. The device generates a calculated data field based on the mathematical expression. The device assigns the calculated data field as a member of a third object in the object model according to relations in the object model connecting the first object to the second object. The device displays the calculated data field, in the schema region, visually associated with the third object.

Using objects in an object model as database entities

A user selects a data source, and a computer displays a data visualization in a data visualization user interface according to the data source. The data visualization includes visual data marks representing data from the data source. The user selects a subset of the visual data marks. In response, the computer displays a view data window having a summary of the selected data marks. The computer obtains a data model encoding the data source as a tree of logical tables. The computer identifies aggregate measures corresponding to the selected data marks, where each aggregate measure is aggregated from logical tables of the data model. The computer displays each aggregate measure in the view data window. The computer also displays, in the view data window, one or more level of detail calculations referenced in the selected subset of visual data marks.

Methods and user interfaces for visually analyzing data visualizations with row-level calculations

A computing device displays a data visualization interface that includes a shelf region and a schema information region. The device receives user input to select a measure data field and a dimension data field from the schema information region. The device generates a custom calculation that groups data values of the dimension data field according to respective distinct data values of the dimension data field and aggregates data values of the measure data field for each of the distinct data values of the dimension data field. The device stores the custom calculation as a new selectable data field and displays the new selectable data field in the schema information region. The device receives user selection of the new selectable data field from the schema information region and placement of the new selectable data field in the shelf region. The device generates and displays a data visualization.

Methods and user interfaces for generating level of detail calculations for data visualizations

A method for analyzing data from data sources includes receiving user selection of a data source and displaying an interface that includes a schema region and a plurality of shelf regions. Each data field in the schema region is associated with a respective system-defined object from the data source. In a first display mode, each data field is displayed as associated with a respective system-defined object. In a second display mode, each data field is displayed in a respective user-defined folder. The method also includes displaying a data visualization according to a user placement of first and second data fields into the first and second shelf regions.

Analyzing data using data fields from multiple objects in an object model

A computer generates and displays a data visualization in a data visualization user interface according to placement of data fields, from a data source. The data visualization includes visual data marks representing data from the data source. The computer detects a user input to select a visual data mark. In response to detecting the user input, the computer obtains a data model encoding the data source as a tree of logical tables. The computer identifies one or more aggregated data values for the visual data mark, each of the aggregated data values corresponding to a respective data field in the data model. For each of the aggregated data values, the computer retrieves a respective disaggregated set of data rows from a respective logical table containing the respective data field. The computer displays a summary grid, with a respective tab corresponding to each of the retrieved disaggregated sets of data rows.

A method for analyzing data from data sources includes receiving user input to specify a mathematical expression. The mathematical expression includes a first data field from a first object and a second data field from a second object. The first object and the second object are distinct objects of an object model that includes a tree in which each relation between objects represents a respective many-to-one relationship between respective objects. The method further includes generating a calculated data field based on the mathematical expression, and assigning the calculated data field as a member of a third object in the object model according to relations in the tree connecting the first object to the second object.

A computing device displays a data visualization interface and receives user selection of a data source. The computing device also receives user input to select a measure data field and a dimension data field. In response to the user input, the computing device: generates a custom calculation that aggregates data for the measure data field, grouped by distinct data values of the dimension data field; and stores the custom calculation as a new selectable data field, associated with a data object corresponding to the dimension data field. The computing device also receives user selection of the new selectable data field and placement of the new selectable data field onto a first shelf in a shelf region. The first shelf defines a first data visualization characteristic determined according to data values of the custom calculation. The computing device generates and displays a data visualization based on the first data visualization characteristic.

A method for analyzing data from data sources includes receiving user selection of a data source and displaying an interface that includes a schema region and a search box. Each data field in the schema region is associated with a respective system-defined object from the data source. The method also includes receiving user input in the search box. The user input includes a predefined contiguous string of characters specifying a search parameter. The method also includes, in response to the user input in the search box, filtering the data fields displayed in the schema region, thereby displaying only data fields whose data type matches the data type specified by the search parameter.

Schema viewer searching for a data analytics platform

A method for analyzing data from data sources includes receiving user selection of a data source and displaying an interface that includes a schema region and a plurality of shelf regions. Each data field in the schema region is associated with a respective system-defined object from the data source. In a first display mode, each data field is displayed as associated with a respective system-defined object. The method also includes receiving, in the first display mode, user placement of a first data field into a first shelf region. In a second display mode, each data field is displayed in a respective user-defined folder. The user-defined folders are distinct from the system-defined objects. The method also includes generating a data visualization according to the user placement of the first and second data fields into the first and second shelf regions.

Growing community of inventors

Seattle, WA, United States of America

Thomas Nhan