Data model

Our data model that you can explore in the template app, is highly optimized for an easy analytical experience. Please follow the steps described here , on how to download and explore the Power BI template app in Power BI desktop.

Data load step

In Power BI desktop open the transform data dialog

All the tables loaded in this step, are simply tables from our OData API- no transformations are done

Data transform step

All data transformation step is done with 1 virtual table, using the DAX language. Our fact table is transformed here

If you are new to DAX this might look scary, but it's not that tricky. Our fact table is cross-joined to create a period concept. This makes it very easy for you as a Power BI developer to build a visualization showing the compliance percentage development over time - regardless of the specific locations' compliance percentage was actually modified in the time period.