Current tendencies around Power BI management and organization
?? Christophe Hervouet
DATA Advisor : Organisations / Gouvernances / Architectures + Lead tech Microsoft Data : Azure / Power BI / Microsoft Fabric + Expert Bigquery / DBT Cloud
LA FACTORY?
Provide "official" BI data ( SQL Lakehouse /DWH & Power BI) to consumers and datacitizens
?
- Supply? "official"? and "single source of truth" and "under governance"? data
- End to end ( Gold Analytic SQL star model --> Power BI)
- No worries , Power BI organization is still on Self BI , but quality is much better and under governance
- La factory is consumed by? data-citizens
- Remark ?: Composite V2 ?techno (aka Direct query to DS) is not currently relevant , on my opinion ( R.L.S & performances problems )
- Prefer to ?use IMPORT or DIRECT LAKE mode to feed the crossing model ?
- Take care to synchronize ?RLS & KPIs fomula
OFFER A ?BIG STAR SEMANTIC MODEL BY DOMAIN (mutiple data products as data source) ?
Here is an architecture (parent - children via perspectives) currently "under fashion" on large number of compagnies
Lots of advantages :
- Better to perfom maintenance (only one master / parent model to manage)
- Better for governance : Master semantic model is "single source of truth" compliant
- Provide few "thematic focused" perspectives (kind of view) ? to data citizens (reporting)
- Crossing? data products via a perspective is possible
- Global data products via perspective is possible
- Will be perfect if this one ?is managed by ?LA FACTORY TEAM (alway on self bi but strong governance & skills)?
Founder | Senior Data Executive | 30 Years of Leadership in Data Strategy & Innovation | Executive Director | Sales Executive | Mentor | Strategy | Analytics | AI | Gen AI | Transformation | ESG
1 个月Interesting points about data organization in Power BI for 2024! How do you see the implementation of "La Fabric" impacting the efficiency of BI processes across different domains? Would love to hear your insights or any challenges you anticipate with this approach!
DATA Advisor : Organisations / Gouvernances / Architectures + Lead tech Microsoft Data : Azure / Power BI / Microsoft Fabric + Expert Bigquery / DBT Cloud
11 个月You need a powerful Directquery to semantic models system ? ?? Don't hesitate please to vote for this IDEA ==> https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=b98381da-3002-ef11-a73c-6045bdbe85bd