BI - Business Intelligence

Renson has experienced significant growth in recent years. This growth also creates challenges in terms of developing and maintaining a centralized ERP system, to be able to report company-wide and harmonized. To meet this need, it was decided to roll out SAP S/4HANA ERP in phases across all divisions. 

Collaborating with our team, Fepco introduced a tailored Power BI "Out-of-the-Box" solution, designed to provide comprehensive insights into their business domains, including finance, sales, inventory, and purchase.  To further empower Fepco's decision-making capabilities, the standard "Out-of-the-Box" domains were augmented with advanced reporting features to calculate and maximize margins, a critical aspect of the wood trading business.

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.