A CITIZEN DEVELOPERS DATAWAREHOUSE IN DATAVERSE DEEPDIVE [EN]

Every Power BI user knows or should know the star schema concept. And then apply it! But if you are not a data engineer or SQL server admin, how are you going to save your remodeled data in a real Datawarehouse. Well if your company enables you to use Dataverse, then a citizen developer might be able to build a Datawarehouse him/her self in Dataverse. Including incremental refresh.

During this session I will show you how to do this and also talk about the pro’s and con’s.
I will build a dataflow to:
– create a Customer Dimension table with surrogate Key
– create a Sales Fact table in which I combine Order header and Order details. And the Order Freight amount will be allocated to the related details lines.
Both tables will then be saved to Dataverse.
After the creation of the tables, I am going to apply Incremental refresh in order to only load the newer records during future refreshes.
I will use a public ODATA version of Northwind trader’s database as my transactional source system.
Finally, I will connect my Power BI to the Dataverse tables.
For your information: Dataverse is an Enterprise scale database solution with very sophisticated security options. And a central part of the Power Platform.