DW - Data Warehousing & Modeling

Unlocking Data Synergy: The Power of Databricks Federated Queries

Databricks Federated Queries enable seamless data querying across multiple sources, eliminating the need for data duplication.

Maurits Geeroms

Maurits Geeroms

Mardi, 26 mars 2024

Unleash the Power of Your Databricks Superhero

Stay updated with Databricks! Explore the latest features and insights into their Data Intelligence Platform. Learn practical tips to maximize your data experience on this leading cloud-based platform for scalable solutions.

Lennert Van den Broeck

Lennert Van den Broeck

Vendredi, 15 mars 2024

HR Reporting & Bug Reporting

In this project, element61 helped set-up the internal analytics platform for OMP using Databricks Lakehouse and Power BI, to enable data-driven decision making across different business functions and processes. The platform integrated data from various sources and our project focused as first use-cases on HR reporting & bug-reporting. This project was done in end-to-end coaching & codevelopment to guarantee the internal team got trained and comfortable with the new tools put in place.

Can Power BI DAX Query view replace DAX Studio? Not quite, but…

Introduction Everybody who's been working with Power BI has heard (or should have heard) about another great tool, called Dax Studio. If you want a powerful way to look at the measures of a model, look deeper into performance, view the metrics of your model to figure out if there is nothing there slowing you down or eating up valuable space, etc. DAX Studio was and is still the go-to tool.

Dirk Meert

Mercredi, 7 février 2024

Goodbye Modern Data Platform, Hello Data Intelligence Platform? A Data & AI World Tour recap

The first-ever Data & AI World tour was a huge success, and you can expect it to happen again next year in some form (maybe even in Belgium!). Generative AI is a robust ongoing trend, and Databricks utilizes Generative AI to enhance various functionalities and features. This integration has spawned the term "Data Intelligence Platform" by combining Generative AI with a Lakehouse, simplifying data querying, management, and governance processes significantly.

Yoshi Coppens

Mardi, 5 décembre 2023

Modern data platform setup

The roadmap showed that the design of a new Data Platform was crucial to harmonize the data from existing ERPs & the future SAP S4 ERP as well as to be ready for everything related to production OT data & AI. This platform was set up by element61 in co-development on initial reporting domains such as sales, purchasing, inventory & finance.

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.

DWH Migration SQL server on premise to Azure SQL server

With this project, Connect Group wanted to migrate their on-premises Data Warehouse on SQL Server to a Modern Data Platform in the cloud and to Power BI to improve their BI and analytics capabilities. The platform on Azure included services like a data lake, SQL Database, ADF – to rebuild the ETL with the element61 Acceleration Kit, and Power BI implemented on top. The data platform enabled finance, sales, production, procurement & stock reporting on top of SAP ECC.

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.

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