BPC MS & SQL DWH project

Together with the merger with Medialaan, De Persgroep started upgrading their MS Dynamics AX 2009 ERP system to the new Microsoft Dynamics 365 system. In parallel to that migration they asked element61 to create a common financial DWH. That ERP project resulted in major changes in business notions (e.g. redefining masterdata, changes in reporting dimensions, etc.), leading to significant complexity in remapping old and new data.

The project has been set up in a Azure SQL Database using a tabular model and the latest Microsoft technologies to orchestrate the ETL. The full ETL was made in Visual Studio 17 and runs automatically in the Azure Data Factory on an hourly and daily base. This provided the foundation for an harmonized and detailed reporting layer. On top of this, the DWH also feeds a new BPC Application, implemented by element61 as well. The DWH provides actuals and metadata for management BPC reporting.

By the use of the elementary templates provided by element61, we have created a full end-to-end solution that runs automatically and informs the key users of any data errors or inconsistency.