Search

Modern data platform setup

Migration of current on-premise data sources/data warehouse layer to Azure Cloud. In preparation of Qlik to MS Power Bi migration and enabling platform for IOT and AI use-cases.

Renson Ventilation

Modern Data Platform to enable Smarter Home

Smart and IoT-enabled products like the Healthbox 3.0 generate a lot of (real-time) data. To turn this data into smart services for end-users, Renson needs a capable, scalable and flexible platform. To enable these capabilities Renson has been focusing on building a data platform that is equipped to handle the incoming data flow efficiently while exploiting the incoming data to generate additional value for the customers. This platform has been designed using a cloud-first approach on Azure.

Secure your data in Microsoft Fabric! 🔐

Introduction Microsoft Fabric is the new Microsoft branded analytics platform that integrates data warehousing, data integration and orchestration, data engineering, data science, real-time analytics, and business intelligence into a single product. This new one-stop shop for analytics brings a set of innovative features and capabilities by providing a transformative tool for data professionals and business users.

Nicolas Simon

Thursday, 23 November 2023

Power BI in the Power Platform

In this Insight, we will take a closer look at how to place and use Power BI in the Power Platform. We will briefly highlight each component separately after which we will discuss some examples of integrations.

Sven Pauwels

Tuesday, 21 November 2023

IoT and Predictive Maintenance for automated material handling

The project consisted of the development of an end-to-end set-up for IoT and sensor data to allow reporting and predictive maintenance. Technology consisted of a full Microsoft Azure stack incl. Azure IoT hub, Databricks, Azure Data Explorer & Grafana.

Modern data platform setup to allow Revenue reporting and Churn analysis in Gaming Industry

A Modern Azure based data platform was created to allow Finance, Sales & Marketing to analyse gaming data and behaviour by blending transactions data (online & landbased) with Google Analytics. This enabled revenue reporting for Finance and Controlling and customer churn analysis to allow Marketing to act and react. Both online gaming as gaming hall transactions were sourced to the datalake from Postgress and Google Cloud Platform (GCP) by using Databricks, APIs, Google Analytics, GCP and MS Power BI.

Setup of a Modern data platform to allow Water balance reporting

De Watergroep wanted to have a report on the water coming in versus the water going out in their water production facilities. This would help them both in their day to day operations and in their annual reporting.

Boost Excel for Budgeting with Vena Solutions

Through easy mapping and robust scenario analysis features, Vena offers a more collaborative and insightful approach to financial planning. The prospects of streamlined financial planning, real-time analysis, and informed decision-making become part of your financial process. Transitioning to Vena will leverage existing resources while embracing a culture of continuous improvement and self-supporting financial transparency.

Bjorn Van Damme

Bjorn Van Damme

Carlos Garrido

Jeremy Matthynssens

Jeremy Matthynssens

Monday, 13 November 2023

End-to-end Operational Process Monitoring for EOM (Electro Optics & Materials)

The Electro Optics & Materials (EOM) department of Umicore had a need to get reliable insights & metrics from their operational processes so they can monitor the materials from the first batch all the way to a finished wafer. Data was extracted from their SAP BW4HANA system and enriched with data coming from sharepoint, excels,... element61 proposed the data architecture and tooling, being Azure Data Factory, Azure Functions, Azure Data Lake, Azure SQL data warehouse, TimeXtender, API’s and front-end reporting in MS Power BI

KPI Dashboard for Human Resources

The HR department of Umicore wanted a story-approached dashboard which shows various benchmarks against strategic goals (e.g. diversity within the manager pool) and also contains historical progress and with a deep-dive into regional benchmarks. The dashboard is accessible to a wide-range of internal employees which can only see relevant data based on their role/region/... The dashboard needed to be highly secured using Row-level-security, seen the confidentiality of the data. Data was extracted from SAP BW4HANA & other internal sources. element61 proposed the data architecture and tooling, being Azure Data Factory, Azure Functions, Azure Data Lake, Azure SQL data warehouse, TimeXtender, API’s and front-end reporting in MS Power BI.