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​
- Click the
Add dimension table
button, then select the schema and the tables in the right sidebar and clickAdd Tables.
-
You need to set the type of each selected table, which can be either a
User table
(containing properties about user entities) or aGroup table
(containing properties about group/team entities). -
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 selectedUser table
as the table type, then you should set the user ID field, or if you've chosenGroup table,
select a field containing the group/team ID. -
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.