Analyze Usage Tracking Data Using a Subject Area in the Semantic Model

Create usage reports using a subject area in the semantic model to understand the user queries.

You must import metadata to ensure that physical and metadata are synchronized. Don't customize by adding new columns in the usage tracking tables to avoid schema mismatch issues.

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. Import the semantic model that has the Usage Tracking tables updated with the query results. See Import the Deployed Model to Create a Semantic Model.
3. On the Home page, click Data, and then under Datasets, select the subject area that corresponds to the usage tracking tables to create a workbook.
4. On the New Workbook page, 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.