BETA: How do I model a data source?

You create modelled data sources in the Modeller. With modelled data sources, you can use formulas and properties to organize and restructure your data. Using modelled data sources simplifies Klip building and enables you to reuse settings and calculations across multiple Klips. You clarify and organize your data in the Modeller, including converting tree structured data into tabular data, and then use the modelled data source to build a Klip or a Metric Klip.

Notes:

  • In order to model a data source, you must have already created a data source. Learn how to create a data source.
  • Modelling dynamic data sources is not currently supported.

To create a modelled data source:

  1. Click Data Sources in the left navigation bar.
  2. From your list of data sources, select the one you want to model.
  3. Click New modelled data source. You will be redirected to the Modeller.

 To create a modelled data source using Beta Metric Klips:

  1. Select either Klips or Metric Klips (Beta) from the drop-down list.
  2. Click Data Sources in the left navigation bar.
  3. From your list of data sources, select the one you want to model.
  4. Click New modelled data source. You will be redirected to the Modeller.

All Metric Klips must be created from modelled data sources. Learn more about creating a Metric Klip here.

Setting properties for a modelled data source

The Properties panel, that displays on the right side of the Modeller, is used to select general settings for your model, including the following:

  • Name: Type a name for your model here. You can also hover and click on the title at the top-left of your page to name your model. The name you choose will display for your modelled data in the Klip Editor and help you identify your modelled data source in your list of data sources.
  • Description: Type a description for your model here to identify its purpose.
  • Column Names: Choose the row number that contains the title of your data columns from the drop-down list.
  • Exclude Rows: Enable Exclude data before row to choose the row number you want your data to start with in the model. For example, if you choose 5, the data in your model will start with row 5 and onwards.

In the Modeller workspace, add individual columns to your modelled data source using the + button. Select a column of data from your raw data source to populate the new column. If you are using tree-structured data you must add each column of your modelled data source individually.

Access the 3-dot menu on the right-side of each column name to view keyboard shortcuts, remove a column, move it left or right, or rename it.

Access the toolbar on the top of the Modeller to add, duplicate, move, and remove columns. Here, you can also use the arrow icons to undo and re-do actions in the Modeller. Use the three-dot menu on the toolbar to access more options. 

Setting column properties for a modelled data source

The Column Properties panel displays on the right-side of the Modeller when an individual column is selected. 

Set properties and align your data by choosing a Name and a Data Format for each column.

  • Name: The column name you choose will display in the Klip Editor. Name each column by entering a name or by selecting the column and hovering over the column name. You can also name your column using the 3-dot menu beside the column name.
  • Data Format: Choose one of the following data types for each column:
    • Text: Textual data is denoted by ABC next to the column name.
    • Number: Numeric data is denoted by 123 next to the column name.
    • Percentage: Data formatted as a percent is denoted by a percentage symbol, %, next to the column name. When choosing this data format, make sure to use the formula bar to convert percentage values to decimals between 0 and 1, if they are not already.
      For example, if your values are 23, 33, and 55, add “/100” to the formula in the formula bar so that they become 0.23, 0.33, and 0.55.
    • Currency: Data formatted as Currency is denoted by a currency symbol, $, next to the column name.
    • Date/Time: Date/time data is denoted by DATE next to the column name. When choosing this data format, you can optionally set your date/time formats using the Input Format menu and Display Format menu. When you choose your Display Format it will be reflected in your data column. You can also set your timezone here. You can either use your default account level time zone or set a different one.

Writing calculations for a modelled data source

You write calculations using functions and references in the formula bar. The formula bar in the Modeller works the same as the formula bar in the Klip Editor.

Learn more about using the formula bar here.

You can find best practices for modelling data for Metric Klips here.

Note: Variables, formula references, and result references are not currently supported in modeller.

Saving a modelled data source

When you are finished creating your modelled data source, make sure to Save and Exit. You can always go back and edit your model later.

To edit a modelled data source:

  1. Click Data Sources in the left navigation bar.
  2. Click on the modelled data source.
  3. Click Edit Model.

To edit a modelled data source using Beta Metric Klips:

  1. Select either Klips or Metric Klips (Beta) from the drop-down list.
  2. Click Data Sources in the left navigation bar.
  3. Click on the modelled data source.
  4. Click Edit Model.

Note: If the raw data source that your model is based on changes, you may get an error in the modeller asking you to confirm the changes are reflected correctly in the modeller. Click Save and Exit to dismiss the warnings. 

Building a Klip using a modelled data source

Once you have created a modelled data source, you can build Klips with the modelled data source. You can do this by either going to the About this Modelled data source page for the data source (this page displays when you select a modelled data source from your list of data sources) and clicking Build a Klip with this Model or in the Klip Editor by clicking +Add Data Source and selecting the modelled data source.

Drag a component to your Klip workspace and begin assigning data columns to your component. References to modelled data source columns are denoted by a @ and the column name.

Learn more: