Power BI Architecture Best Practice
Вставка
- Опубліковано 2 сер 2022
- Using Power BI is simple. However, using it properly needs a good architecture. In a multi-developer environment, the architecture of a Power BI implementation should allow multiple developers to work on the same solution at the same time. On the other hand, the Power BI architecture should be designed so that different layers of that can be decoupled from each other for better integration. In this video, I explain how Dataflows, Datamarts, and Shared Datasets can help build such architecture in Power BI.
To learn more and find links to study more, read my blog article here:
radacad.com/power-bi-architec...
*******************
Want to learn about Power BI or AI? or take your Power BI and AI knowledge to the next level for building reports? Check out our courses in RADACAD Academy for all aspects of Power BI and AI.
RADACAD courses: radacad.academy
Our upcoming courses: learn.radacad.com/events/
Free books and tools for Power BI: radacad.com
Power BI Helper: powerbihelper.org/
Become an academy member: learn.radacad.com/academy/
*******************
********
CONNECT with US!
********
-- / radacad_com
-- / rad_reza
-- / leila_etaati
-- / radacad
-- / leila-etaati-b0304636
-- / rezarad
-- / 6393399
-- radacad.com
********
#PowerBI #PowerBIfromRookieToRockStar #PowerQuery #DAX #Visualization #RADACAD - Наука та технологія
Very insightful, thank you! :)
Glad you enjoyed it!
Thank you Reza for sharing your knowledge. We are always grateful for that! Do you know how to use calculated groups and field parametrers in Datamart?
A Date table is commonly used by all departments data and takes place in all data models. Q: Such common tables must be kept as a separate Dataflow and so must be included as a different Data Source Query (only one Dataflow for Date Table) or must be included at every separate Department tables (repeating Date table at each Dataflow for different departmensts).
Do you recommend dimensions via dataflow and large fact e.g orders with in a shared dataset skipping the dataflow?
Right now, I have started working with shared datasets in the Power BI service.
This collaborative environment uses the Power BI service live connection, however, one of the main limitations is that left navigation and modeling are disabled.
How to overcome this limitation?
Thanks for the video, very helpful.
Would there be any benefit to use Staging Dataflows with azure datalake for storage INTO Datamarts for transofmation and azure sql storage INTO Datasets for the reports?
Yes, absolutely. as I mentioned, staging dataflows helping with data source isolation. I always recommend that.
For what scenarios in regards to data volume you consider Dataflow Staging layer usefull? I asume that at some point (big data volumes) to load all data to Dataflow staging layer will consume a lot of time. Thanks
I would recommend it regardless of the size of the data. Because it gives you the data source isolation.
Really helpful!
Glad it was helpful!
Thanks, multi developer means colloborative developer, right?
Yes, correct
How will query folding work here ?
Query folding is only a concept from Power Query to the data source, which is still valid from Dataflow to the data source (as long as your data source supports it and your transformations support it).
Reza how can I become power bi architect? I am just a developer right now. can you help me? Please let me know what all things I should know
💔 քʀօʍօֆʍ
The heavy lifting should be done in SQL. Thats also a single version of the truth