Forum Discussion
doubts with connectivity and databases
Absolutely the first option (having a company wide, well maintained data dictionary without contradictions, and with a well staffed data stewardship team) is preferable as it avoids all the duplications and misunderstandings of the second option.
Humans seem to have difficulty finding the time to do things right, but they will happily spend that same time trying to mend hopelessly broken things.
Super UserRealistically the second option is unfortunately more popular, mostly because teams have different data privacy and security requirements. Financial data subjects have very different sensitivity than internal support cases, for example. If you go for a unified company wide data mart you need to have the option for solid segmentation (object level security) which Power BI is just about to introduce.
You can still coordinate between the data islands so that everybody is at least aware of each other.
so as you said that unfortunately the second option is the most used. Would it be better to make the first option?
or another option better in your opinion