Unblocking Power BI —Should Data Mart be Implemented in Azure Synapse or Power BI Premium? (Ep. 7)

Technologies include Azure, Power BI, and Excel. Together, they can be leveraged to deliver a scalable and data-driven cloud BI platform

Co-authors: Gananda Hayardisi, Wipada Chanthaweethip

Last year, it was obvious from the Microsoft BI official announcement that Power BI Premium is a superset of Azure Analysis Services. You may check out my old post below.

Unblocking Power BI — Power BI Premium as a Superset of Analysis Services (Ep. 5) | by Korkrid Akepanidtaworn (Kyle) | Dev Dream Team | Medium

The concept of data mart vs. data warehouse has been one of the biggest hurdles to my customers. The difference comes in three aspects:

1. Data Size — a data mart is typically less than 100 GB; a data warehouse is typically larger than 100 GB and often a terabyte or more.
2. Range — a data mart is limited to a single focus for one line of business; a data warehouse is typically enterprise-wide and ranges across multiple areas.
3. Source System — a data mart includes data from just a few sources; a data warehouse stores data from multiple sources.