How do we decide/suggest customer that we need a different workspace for data Hub?
Do we have any other benefits of having different workspace for data hub other than User segregation?
yes! yes! Great question. One that many of us face, especially after the first model has been built.
There are so many benefits of a data hub beyond segregation of duties. Recommend you read this article first by @guillaume_arnau - short and sweet.
Some rules of thumb that help build the case for a DH (besides segregation of duties)
There are some "gotchas" though (my opinion only)-
It was helpful.
But I wanted to know what is the difference between having data Hub & spoke model in the same workspace and in difference workspace?Which should we prefer? How do we decide that?
Very good question and the answer centers around security and segregation of duties. 95+% of the time, we see data hubs in their own workspace as the owners of the data hub can be a different team, not always, but usually. Since actions can span across workspaces, having data hubs and spoke models in different workspaces is not a big deal and is recommended to keep the overhead of the workspace down.
Hope this helps,
Thank you for your response.
We have a follow-up question if we keep data hub model and spoke models(Demand planning model) in different workspace. Let's say we collect 3 years of sales history into data hub to generate statistical forecast in demand planning model. It has consumed some space (Eg 2 GB). Should we also copy the same data into demand planning model again to generate Statistical forecast in demand planning model. If so don't we use double space to store the same data in different models? Please help to understand this better.
Only bring in the data at the level (granularity) you need into the spoke models. So, if you have transactional (daily level) data in the hub but only use Monthly level data in the spoke model, only bring that into the spoke model. Understand what data you really need for that model and what granularity and only bring that in.