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.

There are two distinct approaches for creating data joins for the purpose of visualization:
  • 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.