Working with data models in CDP Data Visualization
You can expand the basic one-table dataset by creating joins with other relevant tables from the same or other data stores. Combining data across multiple tables enriches the dataset considerably. It enables you to conduct much more meaningful research and produce insightful visual analytics.
Defining in UI is ideal for datasets that include star-type schemas.
Defining on back end ETL is preferable for fact-fact joins, so they may be pre-materialized.