Data Mart Creation

Create a Star Schema

  1. Define a Galaxy (logical container above data marts)
  2. Create a Data Mart (Star Schema) under that galaxy
  3. Assign your dimension and fact transformations to the star schema

Assign Transformations

For each transformation:

  • Mark Dimension Transformations as “Dimensions”
  • Mark Fact Transformations as “Facts”
  • Link them to the appropriate star schema

This creates the logical model that can be exported to Power BI, SSAS, or other analytics tools.