Financial Data Warehouse in Publishing Media
Together with the merger with Medialaan, DPP is upgrading their Microsoft Dynamics AX 2009 ERP system to the new Microsoft Dynamics 365 system. Included in this migration, they have asked element61 to create a new financial DWH based on their new Microsoft Dynamics 365 ERP system. Next to the physical DWH model, they requested a common reporting layer 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 with Visual Studio 17 and runs automatically in the Azure Data Factory on an hourly and daily base. Next to this, the DWH also feeds the BPC application, also implemented by element61. The DWH provides actuals and metadata for the BPC dimensions on an hourly and daily base. 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 inconsitency.