Skip to main content

Dimensions Tables

Overview​

User profiles are a common concept in data analytics. By user profiles, we often mean a set of properties that the users of a product may have. Examples of user properties:

  • Country of origin
  • Email addresses
  • Primary email address
  • Phone number
  • Is paying
  • First event time
  • Last event time
  • Sign-up time
  • etc.

Besides the user profiles, you can have group or team profiles as well containing properties belonging to the set of users like

  • Company name
  • Subscription group

Most companies store these properties in a data warehouse in separate tables, where each row holds information about a single user or group. Later, during analysis, they join these tables to the event tables for further filtering and segmentation.

Mitzu supports joining one or more dimension tables to event tables.

Setting up the user profile tables​

  1. Click the Add dimension table button, then select the schema and the tables in the right sidebar and click Add Tables.
image
  1. You need to set the type of each selected table, which can be either a User table (containing properties about user entities) or a Group table (containing properties about group/team entities).

  2. For the Primary key field, you need to set the field that can be used as a joining key when joining the event tables. If you've selected User table as the table type, then you should set the user ID field, or if you've chosen Group table, select a field containing the group/team ID.

  3. Click the Save & update catalog button to start updating your user properties catalog with the newest dimension properties.

Removing user profile tables​

If you decide to remove any dimension table, select it with the checkbox in the table and click the Remove tables button. It will remove the table from the list of tables and the user property catalog. All saved Insights using one of the removed tables will break.