Analytics

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

Screen Shot 2022-04-06 at 14.21.17.png

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

no-transform-steps.png

Data transform step

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

risk-fact-transformation.png

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.