Analyze Usage Tracking Data by Creating a Dataset

Create usage reports by creating datasets with data from the physical and logical query logging tables to understand the user queries.

1. On the Home page, click the Page Menu and select Open Classic Home. Create and run an analysis.
   The system populates the query in the usage tracking tables in the usage tracking database.
2. On the Home page, click Create, and click Dataset.
3. In Create Dataset, click the connection to the usage tracking database, and select the schema specified in the Physical Query and Logical Query Logging table names in System Settings. For example, the schema name provided in <database name>.<schema name>.<table name> for the Physical Query and Logical Query Logging table names.
   This is the database connection you created to set up usage tracking. See Prerequisites for Usage Tracking.
4. In Add Dataset, search for the usage tracking physical query logging table, add all the columns, name the dataset (for example, Physical Queries), and then click Add. Similarly, search for the usage tracking logical query logging table, add all the columns, name the dataset (for example, Logical Queries), and then click Add.
5. On the dataset Results page, click Create Workbook. Add both the datasets to the workbook: for example, the Physical Queries and Logical Queries datasets. Name the workbook (for example, Usage Tracking).
6. In the Prepare tab of the workbook, click Data Diagram, and create joins between the datasets using a column such as the ID column.
7. In Visualize, drag data to create visualizations based on your requirement.
   Refer to the usage tracking table descriptions in "Understand Usage Tracking Tables" to select applicable columns. For example, you can create a visualization to show how many queries took how much time.