公开(公告)号：US20210097065A1

公开(公告)日：2021-04-01

申请号：US16586554

申请日：2019-09-27

申请人： Tableau Software, Inc.

发明人： Andrew C. Beers ,  Jun Ho KIM ,  Ryan Andrew Atallah ,  Scott Sherman ,  Eleanor Page Darby Fields ,  Jeffrey Jon Weir

IPC分类号： G06F16/248 ,  G06F16/21 ,  G06F16/242 ,  G06F16/25 ,  G06F3/0482 ,  G06F3/0484

摘要： Embodiments are directed to a display engine that provides a graphical user interface (GUI) that includes a graph panel and a visualization panel may be generated. The graph panel may receive graph related inputs or interactions. Graph information based on the graph related inputs or interactions and a data source may be generated. A graph model based on the graph information and the data source may be generated. Elements that correspond to objects in the graph model or relationships in the graph model may be displayed in the graph panel. The graph information and the graph model may be employed to execute a query that provides a data model based on results of the query. The data model may be employed to provide a visualization that is displayed in the display panel.

公开(公告)号：US11853363B2

公开(公告)日：2023-12-26

申请号：US17845921

申请日：2022-06-21

申请人： Tableau Software, Inc.

发明人： Ryan Andrew Atallah

IPC分类号： G06F7/00 ,  G06F16/9032 ,  G06F16/904 ,  G06F16/957 ,  G06F16/901

CPC分类号： G06F16/90332 ,  G06F16/904 ,  G06F16/9024 ,  G06F16/9027 ,  G06F16/9577

摘要： 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. The system determines hierarchies between the data field and other data fields in the first data source based on a respective semantic role of the data field and semantic roles of the other data fields. 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 transformed data values.

公开(公告)号：US20220318312A1

公开(公告)日：2022-10-06

申请号：US17845921

申请日：2022-06-21

申请人： Tableau Software, Inc.

发明人： Ryan Andrew Atallah

IPC分类号： G06F16/9032 ,  G06F16/904 ,  G06F16/957 ,  G06F16/901

摘要： 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. The system determines hierarchies between the data field and other data fields in the first data source based on a respective semantic role of the data field and semantic roles of the other data fields. 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 transformed data values.

公开(公告)号：US11366858B2

公开(公告)日：2022-06-21

申请号：US16679234

申请日：2019-11-10

申请人： Tableau Software, Inc.

发明人： Ryan Andrew Atallah

IPC分类号： G06F7/00 ,  G06F16/9032 ,  G06F16/904 ,  G06F16/957 ,  G06F16/901

摘要： A method prepares data for subsequent analysis. The method obtains a data model that encodes a data sources as a tree of logical tables. Each logical table has its own physical representation and includes logical fields. Each logical field corresponds to either a data field or a calculation that spans logical tables. The method associates each logical table in the data model with a corresponding concept in a concept graph. The concept graph embodies hierarchical inheritance of semantics. For each logical field, the method assigns a semantic role to the logical field based on a concept corresponding to a logical table. The method also validates the logical field based on its semantic role. The method also displays transformations to clean the logical field based on validating the logical field. The method transforms the logical field according to a user selection, and updates the logical table.

公开(公告)号：US20210141838A1

公开(公告)日：2021-05-13

申请号：US16679234

申请日：2019-11-10

申请人： Tableau Software, Inc.

发明人： Ryan Andrew Atallah

IPC分类号： G06F16/9032 ,  G06F16/957 ,  G06F16/901 ,  G06F16/904

摘要： A method prepares data for subsequent analysis. The method obtains a data model that encodes a data sources as a tree of logical tables. Each logical table has its own physical representation and includes logical fields. Each logical field corresponds to either a data field or a calculation that spans logical tables. The method associates each logical table in the data model with a corresponding concept in a concept graph. The concept graph embodies hierarchical inheritance of semantics. For each logical field, the method assigns a semantic role to the logical field based on a concept corresponding to a logical table. The method also validates the logical field based on its semantic role. The method also displays transformations to clean the logical field based on validating the logical field. The method transforms the logical field according to a user selection, and updates the logical table.

公开(公告)号：US20240126815A1

公开(公告)日：2024-04-18

申请号：US18393517

申请日：2023-12-21

申请人： Tableau Software, Inc.

发明人： Ryan Andrew Atallah

IPC分类号： G06F16/9032 ,  G06F16/901 ,  G06F16/904 ,  G06F16/957

CPC分类号： G06F16/90332 ,  G06F16/9024 ,  G06F16/9027 ,  G06F16/904 ,  G06F16/9577

摘要： 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.