Skip to main content

Using the data library

The Data Library is Sisu’s centralized interface for viewing and managing datasets, including data source tables, csv’s, and custom queries defined in Sisu. The library represents any data you might use for metrics or analysis in Sisu. It also provides a path to create new metrics to analyze using the given datasets.

Open the data library by clicking on the database icon in the navigation bar

assets/DL1.png

From here, you can view, manage, create, and use datasets in Sisu.

assets/DL2.png

The list will contain both the source tables and custom queries for the given data source. Each row will allow actions depending on the type of object.

assets/DL3.png

Tables

  • View table: Open a preview of the table’s data
  • Create query: Open the query editor
  • Create new metric: Create a metric using the table
  • Define primary key: Specify 1+ dimensions as the primary key for the table (what each row represents) to help when setting up the metric. [If not already defined.]
  • Edit primary key: For a defined primary key, edit which dimension(s) are in the key.

assets/DL4.png

Queries

  • View query: Open the query editor for this custom query to preview its data or edit its code.
  • Create new metric: Create a metric using the query
  • Define primary key: Specify 1+ dimensions as the primary key for the query (what each row represents) to help when setting up the metric. [If not already defined.]
  • Edit primary key: For a defined primary key, edit which dimension(s) are in the key.

Primary key definition

The primary key denotes what each row signifies in a given dataset. It’s helpful to make sure the primary keys of the datasets used are defined in Sisu to help you set up your metrics correctly. The primary key does not need to be defined in the database to be defined in Sisu

Sisu automatically detects many single-dimension primary keys. If you notice that’s not the case, please reach out to your customer success manager. Sisu will note which keys are detected. If it is not right,  primary keys can be modified.  This is how the initial detection may appear.

assets/DL5.png

Most multi-dimensional, or compound, primary keys, need to be defined in Sisu. Sisu will attempt to help validate key definition.

assets/DL6.png

When you create or edit a metric, you’ll see the primary key for the selected dataset represented in the setup interface. The grain of the metric should match that of the data, so each row is an observation of the metric.

assets/DL7.png

Please reach out to [email protected] with any questions!