Centralised Data Model

[shyammayhs]

Hi guys, I am thinking of creating Centralised Datasets for our Reporting we do for the organisation. What some points I should consider when creating these Data Models? Should it include all of our data tables in the model? Should we have data models per department?

Interested to hear what others have done!

Thanks.

[shyammayhs]

Hi guys, thanks for your replies. I agree with you both that the topic is very complex and requires a large amount of time to cover and fine tune.

This was more of an open topic just to understand what other members/organisations are doing to achieve this model!

Thanks.

[parry2k]

@shyammayhs in general it is hard to answer as @AlexisOlson  mentioned but for me, most of my clients usually have single (golden datasets), only 1 or 2 occasions we have to build a separate data model because it was totally independent of the golden datasets, example here is, golden dataset have all ERP/Sales/Finance data and then there was a need for social media/marketing database which has no link with golden datasets and we went for a separate dataset for marketing. Again, this is just an example, not necessarily it is one size fits all.

[AlexisOlson]

This is a complex topic that needs hundreds of pages to cover fully. Luckily, there's a white paper that's exactly this.

Check out this prior post:  Best Practices for Common Data Models - Microsoft Power BI Community