RDM: Segregate as measures and facts/dimensions example
In the Relational Data Modeling chapter of the User Guide documentation, it is commented that:
“With a feature like Lookup Columns you can:
- Organize your data in a normalized model avoiding duplication of information across tables
- Segregate as measures (numeric data columns which you could aggregate) and facts/dimensions (data columns which you use for grouping in reports).
- Define familiar models like Star Schema & Snow-flake Schema which are optimized for reporting and analysis.”
Could you kindly provide some sample tables to understand better this:
"Segregate as measures (numeric data columns which you could aggregate) and facts/dimensions (data columns which you use for grouping in reports)."
By the way the User Guide documentation is very helpful and well explained, thank you.