BI - Business Intelligence

Resilux, a leading manufacturer in the packaging industry, sought to enhance its operational efficiency and gain deeper insights into its core business domains. To achieve this, the company partnered with our team to implement a comprehensive Power BI "Out-of-the-Box" solution.

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.

The project abstract for the data lakehouse migration for Transuniverse involves transitioning the Power BI "Out-of-the-Box" data warehouse to a data lakehouse architecture. The process includes setting up Self-Hosted Integration Runtimes, ingesting data sources to the silver layer, recreating silver views, transforming logic to gold, creating Power BI Models, and mapping General Ledger accounts in Dataverse. Additionally, it involves migrating PowerApps to the new data lakehouse file format and setting up an Azure Data Factory (ADF) pipeline to refresh the dataset post-loading.

The customs project for Isuzu, focused on the automation of documentation for imported parts. The project aimed to streamline the process of providing the customs authorities with a list of parts used in orders based on a PO number, including the origin of these parts. This was particularly crucial for Isuzu to demonstrate compliance with regulations prohibiting the import of Russian steel.

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.