A Dataset is the central principle of everything that can be done in Knowi. At the most simple level, a Dataset is the result of a Query or a Query with multiple joins.

Datasets allow you to:

A dataset is created when you save and run a query(ies). The Dataset page enables you to manage the following:


The Overview tab on the Dataset page provides you a control room with the following:

image alt text

Apart from the above, the Dataset page also provides insights into:

  1. Status of Query

  2. Datasource Name

  3. Number of Columns and Rows

  4. Creator's Name

image alt text

Create AI Dashboard

The AI Dashboard feature auto-generates a dashboard with a single click having various widgets based on the dataset. It first generates a Spreadsheet widget with the data and the other widgets could be charts or graphs. Users can further work with the individual widgets. This newly generated Dashboard is also given a name and auto-saved in your workspace. It is like any other Dashboard and all the settings and functionalities apply.

Note: Knowi is using its own AI service and no data is sent outside of Knowi.

To generate an AI Dashboard:

  1. Navigate to Queries
  2. In the list of queries, go to the Query details option (eye icon)
  3. On this page, click the Create AI dashboard button.
  4. Click Generate Dashboard.

Furthermore, users can modify the widgets by giving additional context to the AI. This is optional. This can be specified in the Provide any additional context textbox. You can use plain English for this but use the specific data names.

For the previous Sending Activity data example, now there is context.

And this is what the dashboard looks like after the context:

For each of the contexts that was provided, a widget is created with the same name along with the visualization. For example Maximum Sent by Message Type and Week with a bar chart visualization.

Remember to verify the results from the AI-generated dashboard since AI cannot be right always.

Dataset Diagram

The Dataset diagram conveys a high-level view of the data lineage that shows you Query, Dataset, and Widgets on the current dataset.

image alt text

You can also edit and modify your Query, Dataset, and Widget via Dataset diagram. You can hover your cursor over Query, Dataset, or Widget and click on the edit to start making modifications.

image alt text

Data Types

You can modify automatically detected data types by clicking on the Edit button.

image alt text

Once done with modifying the data types, click on the Save Changes button.

image alt text

Search-Based Analytics

You can manage and edit the Search-Based Analytics settings for the following:

image alt text

Once done with modifying the Search-Based Analytics, click on the Save Changes button.

image alt text

Perform Actions

You can perform a wide array of functions on your Dataset that includes:

image alt text

You can click on the More button and perform additional functions on your Dataset that include:

image alt text

Note: If your query is Non-direct, you'll also see:

image alt text

Indexes (For Non-Direct Queries)

For non-direct queries with large datasets, having indexes on commonly used filters can help to accelerate performance and improve the speed of the data retrieval operations.

You can build and edit the indexes by clicking on the Edit button.

image alt text


Your Dataset data can be viewed from the Data tab.

image alt text


You can click on the Log tab to view the entries for all the Query execution events you have performed in the past. The entries appear in chronological order and for any given entry, you can view the Query status, Time taken for the Query to execute, and the Number of records it processed.

image alt text

The records in the log help you perform internal analysis and optimization of how the Queries are executed.

image alt text

You can view further details for any Query Execution event by clicking on the caret:

image alt text

Query History

Query History give you a view of all historical changes made for the Query, as well the ability to revert to a previous version

image alt text

You can restore the Query state to any of the previous versions by clicking on the Revert.

image alt text


You can click on the Usage tab to view all the widgets derived from the Query and which dashboards contain them.

image alt text