Current tendencies around Power BI  management and organization

Current tendencies around Power BI management and organization


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)?


Cameron Price

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!

赞
回复
?? Christophe Hervouet

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

赞
回复

要查看或添加评论,请登录

?? Christophe Hervouet的更多文章

社区洞察

其他会员也浏览了