Good day,
I would like some ideas on best way to implement a Self Service Environment,
I want to open the platform for self service, users has Powerbi desktop installed.
My Thoughts are: On SQL DW Server, create separate DW DB that does not affect data processing that is refreshed in the mornings to populate the Bus Units DB
I would like to split the db into Bus units "finance", i can create a DB named "LactalisDWSS" SS = SelfService
but i would like to create sub db within LactalisDWSS per business units to control permissions and table security
LactalisDWSS > Finance / Logistics / Sales
Thoughts & ideas please on the self service platform > is this good or better ideas?
How do i create subfolders within a DB as i dont want to create a DB per Bus Unit?
Please Any help
regards