What is the best practice of using Datamart?

[marvzhang]

Hi guys,

Recently I noticed the new feature "Datamart" of Power BI. In the official documentation, it says "Datamarts help bridge the gap between business users and IT". In my point of view, it seems it is designed for data analysts or data gurus who are capable of writing SQL and do data analysis but with no full permissions of accessing all data they need?

Can somebody shed some light on this?

Regards,

Marvin

[v-xiaotang]

Hi @marvzhang 

Thanks for reaching out to us.

>>In my point of view, it seems it is designed for data analysts or data gurus who are capable of writing SQL and do data analysis but with no full permissions of accessing all data they need

Please refer to this article, Introduction to datamarts - Power BI | Microsoft Docs

Datamarts offer the following benefits:

• Self-service users can easily perform relational database analytics, without the need for a database administrator
• Datamarts provide end-to-end data ingestion, preparation and exploration with SQL, including no-code experiences

Besides, here is a good video for learning datamart

Exploring the preview of datamart in Power BI! - YouTube

Power BI dataflows vs datamarts: What's the difference??? - Guy in a Cube

This video talks about when to use datamart, Add Data at Scale | Datamart in Power BI - YouTube

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.