Forum Discussion

Community Champion

2 years ago

Solved

Master Models

Hi! I don't have an actual "solve this for me" type of question. More just looking for info. We expect to have a number of different semantic models such as "sales", "finance", "inventory", etc...

Need Help

lbendlin
2 years ago
Also known as "Golden dataset". Mostly an exercise in futility, especially in larger organizations. cf "Expanded Tables"
GilbertQ
2 years ago
Hi littlemojopuppy

I agree here that quite often, while it seems like it is great to create a golden data set in reality, this often doesn't happen as expected due to the complexities and different business areas. I would recommend trying to do one area at a time, and once you've got a handle on all the different areas over time, then see if it is possible to build a golden data set.

Anonymous

Not applicable

2 years ago

Hi littlemojopuppy

Developing a master model that encompasses all shared facts and dimensions, and then selectively deploying subsets of these into specific sub-models is a smart approach.

Here are some links for reference:

Universal and Timeless Database Design Patterns for 2024 and Beyond | Vertabelo Database Modeler

Tabular Optimization (elegantbi.com)

Design and build tabular models - Training | Microsoft Learn

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.