Forum Discussion

littlemojopuppy's avatar
littlemojopuppy
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's avatar
    lbendlin
    2 years ago

    Also known as "Golden dataset".  Mostly an exercise in futility, especially in larger organizations. cf "Expanded Tables"

  • GilbertQ's avatar
    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's avatar
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.

  • littlemojopuppy's avatar
    littlemojopuppy
    Community Champion
    2 years ago

    Anonymous thank you for the references!