Systems and Methods for Ranking Data Visualizations

    公开(公告)号:US20230079109A1

    公开(公告)日:2023-03-16

    申请号:US17985794

    申请日:2022-11-11

    摘要: A computer device receives user selection of a plurality of data fields from a data set. The computer device generates a plurality of data visualization options that use a majority of the plurality of data fields. The computer device computes, for each data visualization option of the plurality of data visualization options, a respective score for the respective data visualization option according to a set of ranking criteria. The set of ranking criteria includes a first ranking criterion that is based on values of one or more of the user-selected data fields in the data set. The computer device creates a ranked list of the data visualization options. The ranked list is ordered according to a plurality of computed scores corresponding to the plurality of data visualization options. The computer device presents the ranked list to the user.

    Data Preparation Using Semantic Roles

    公开(公告)号:US20220318312A1

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

    申请号:US17845921

    申请日:2022-06-21

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

    Blending and Visualizing Data from Multiple Data Sources

    公开(公告)号:US20220309066A1

    公开(公告)日:2022-09-29

    申请号:US17840546

    申请日:2022-06-14

    摘要: A user selects a first group of one or more dimension fields that specifies a primary aggregation for a data visualization, where the one or more dimension fields are in a first data source. When one or more first dimension fields in the first group are not dimension fields in a second data source, a client device joins the first data source with the second data source at a first level of detail that is more granular than the primary aggregation to form a single combined data set that includes the one or more dimension fields specified in the first group and one or more measure data fields aggregated according to the first group. The client device rolls up the combined data set, including the one or more measure data fields, to form a final data set and displays the data visualization using the data from the final data.

    One way cascading of attribute filters in hierarchical object models

    公开(公告)号:US11449510B1

    公开(公告)日:2022-09-20

    申请号:US16557815

    申请日:2019-08-30

    摘要: A method generates a data source. A user selects a first data set from a displayed object model of a database. The object model includes data sets linked visually by many-to-one relationships to form a tree. The user selects a data field in the first data set and specifies a filter condition. The system identifies a second data set in the tree, and joins the first and second data sets. When the second data set is related to the first data set via one or more many-to-one relationships, rows of the second data set are joined to rows of the first data set that satisfy the first filter condition. When the second data does not satisfy the condition, the second data set is joined to rows of the first data set that satisfy the first filter condition, and all rows of the second data set are included in the generation.

    Determining ranges for vague modifiers in natural language commands

    公开(公告)号:US11416559B2

    公开(公告)日:2022-08-16

    申请号:US17347453

    申请日:2021-06-14

    摘要: A computing device receives user selection of a data source and a natural language command directed to the data source. The device identifies a first keyword and a second keyword in the natural language command. The first keyword corresponds to a first data field from the data source and the second keyword expresses a limit on a range of data values for the first data field. The device generates a visual specification that specifies the data source, a plurality of visual variables, and a plurality of data fields from the data source, including the first data field. The visual variables determine characteristics of visual marks in a data visualization according to the second keyword, and each of the visual variables is associated with a respective data field of the plurality of data fields. The device generates and displays the data visualization based on the visual specification.