Reverse ETL your Data Warehouse into Business & Power BI and Kimball (IN-PERSON)

Detailed information and registration can be found here :
https://dataminds.be/reverse-etl-erp-powerbi-kimball/

Michiel Van Brusselen (element61)
The Alpha and the Omega: Reverse ETL your Data Warehouse into ERP Business

Session:
The investment is already made. A Data Warehouse is already in place. The business analysts at your company are zen. They have their insights on a daily basis. They point out to you if things are going wrong. History will not repeat as they can see and analyze your past. Customers are being segmented, products are being followed or discarded, warehouses are being optimized,... . The business is ready to take the next step: Automatically react on your business insights.

Reverse ETL your highly potential customers to the ERP system. Where account managers will not be feeling that 'cold' and 'alone' anymore. Precious, quality, high potential data will be available to them. Their sales rise like never before.

(Business/technical introduction to Reverse ETL. 30 percent technical, 70 percent business)

Speaker:
Michiel Van Brusselen obtained a Master’s degree in Industrial Sciences -specialising in structural engineering- at the University of Antwerp in 2017. He completed the final master year working as a stability engineer at Planet Engineering in Brasschaat. His master thesis dealt with the automation of a sludge wall calculation, where the source data was manipulated using Python and REST API calls. For a data analysis project, in which the energy balance of a house was mapped and optimised, he gained data analysis and visualisation experience in PowerBI and the Azure data platform.
After completing his master’s thesis, Michiel started at Cropland as a Junior Data Scientist. As a consultant, he performed various tasks: analysing visitor numbers, setting up master data management processes, maintaining data quality, up to ETL actions on data sources. Furthermore, he gained knowledge by developing analyses in Python using Azure Databricks and Jupyter.
His initial Data Science projects and his work on data management & ETL motivated him to choose a career in Microsoft Analytics.
Michiel joined element61 in 2020.
In his first months at element61, Michiel was involved in the migration of an on-premise data warehouse solution to the Microsoft Azure Cloud environment. Here he was responsible for setting up Azure Data Factory pipelines, transforming and remodelling an on-premises SQL Server Database into Azure Synapse Analytics. The entire process was automated dmc CI/CD principles using ARM templates in Azure DevOps.

Isabelle Van Campenhoudt (ShareQL - Power Platform Associates)
Power BI and Kimball

Session:
In this session, Isabelle will map the advanced concepts of the Kimball dimensional model to Power BI. Star schema but also Role playing Dimension Time changing dimension and so on...

Agenda (CEST, UTC+2)
18u00 Welcome and introductions
18u30
The Alpha and the Omega: Reverse ETL your Data Warehouse into ERP Business (60 minutes)
19u45 Power BI and Kimball (60 minutes)
20u45 Networking
21u30 Session End