DWH - Data Integratie & kwaliteit

The Power BI "Out-of-the-Box" project at PCS Innotec focuses on implementing the purchase domain to streamline procurement processes and enhance data-driven decision-making. The project entails integrating Power BI tools with PCS Innotec's existing Azure Databricks data lakehouse to provide comprehensive analytics and reporting capabilities for the purchasing department.

Boekestijn Transport Services aims to provide the organization with reliable data on drivers' working time, costs, and potential improvements, thereby supporting informed business decisions and operational excellence.  We also addressed the high demand for drivers due to the fleet's rapid expansion. It focuses on delivering high-quality data on the recruitment process, including live data on recruited and exiting drivers, sources, headcount, retention rates, and the transition time from "In Progress to Driver" status.

For Elindus, element61 set-up a Qlik Modern Data Platform on Azure infrastructure. Using Qlik Talend Cloud as a CDC ingest tool, data is streamed from Salesforce & MS SQL Server into Azure Databricks. The views in the Databricks gold layer are then loaded into Qlik Sense SaaS doe self-service reporting & dashboarding.

As AMCRA leverages NPrinting to generate thousands of reports monthly, the need was there to optimize this process. element61 developed the tools for AMCRA to generate all these different reports and templates in a chained sequence. Furthermore, element61 reviewed certain parts of the Qlik Sense ETL resulting a better performance and equally important more readable and easier to maintain ETL code.

This project involved implementing a data model for financial and procurement reporting using Oracle Netsuite as the source. A Modern Data Platform was established on Azure, and Power BI. The project deliverables included reports for finance (e.g. P&L per ship, aging), as well as procurement. Moreover - and more importantly - this financial data model provided a preliminary basis for the data preparation for the Tagetik implementation that was launched in parallel.

The main objective of this project was to help Andre Celis migrate their legacy on-premise data processing system for reporting and other data streams to a modern and scalable cloud-based solution. They also wanted to re-design and optimize their existing reporting according to the latest best practices, and leverage the full potential of Power BI as a self-service and enterprise BI tool.

The HR department of Exmar has a large need for automation of reporting, mainly due to the extensive and frequent reporting obligations. The project aims to automate reporting by centralizing and harmonizing crewing data, which will then be used to generate automated Power BI reports. This initiative is part of Exmar's broader ambition to establish a robust data foundation that can be utilized across various teams and projects.

This project helps Exmar with a wide range of topics and activities related to IoT data. This data is continuously generated by sensors on the ships, and needs to be smoothly transferred to the already set up central Modern Data Platform for storage and further analysis, or pushed to other systems where needed. This data can relate to sensors on machinery, but also to e.g. sailing conditions and geo-location.

In this project, element61 helped Exmar to gain easy insight into the measurement data from the Tango FLNG infrastructure. About 600 measurements are available daily. A solution was built to bring this data together and integrate it, so that it can be reported and analyzed according to best practices. The solution was built on the already established Modern Data Platform, and is a combination of Sharepoint, ADF, Databricks and Power BI.

This project is about helping Exmar to facilitate the data need for Tagetik. Tagetik is a tool that can do consolidation, budgeting and forecasting. element61 follows a Best Practice of using a central and consistent data model for Tagetik. This means that the data from the ERP system has to be prepared and modelled correctly. element61 helps Exmar with this task using TimeXtender, and also makes sure that the data can be used for Power BI.