DW - Data Warehousing & Modeling

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.

The Power BI "Out-of-the-Box" migration project at Napoleon Games is focused on transitioning from the Napoleon Games tenant to the Superbet tenant. This involves a meticulous process of migrating existing Power BI reports, dashboards, and data models to align with the new tenant's requirements, ensuring data integrity and consistency throughout the migration.

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.