Reverse ETL your Data Warehouse into ERP Business & Power BI and Kimball (IN-PERSON @ element61)
10/05/2022 - element61
Esplanade 1, bus 96
Michiel Van Brusselen (element61)
The Alpha and the Omega: Reverse ETL your Data Warehouse into ERP Business
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)
Isabelle Van Campenhoudt
Power BI and Kimball
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…
Speakers
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 is a MVP DataPlatform who has been working for more than 20 years in the world of databases; she lives in Belgium and has strong experience in Business Intelligence and Database Administration. Trainer (Microsoft Certified Trainer), speaker and consultant, she uses to collaborate with developers (databases design and performance) and infrastructure team.
She was also a teacher for the Bachelor of Computer Science curriculum. In 2014 she co-founded the Global Francophone V-Chapter. Isabelle is a user group board member (GUSS.pro) and takes part in organising events such as SQL Saturday and 24HOP. She started www.shareql.com with another MVP, Serge Luca.
Agenda
| 18u00 | Welcome + Food & Drinks |
| 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 | Event Ends |
Location
element61
Buro & Design Center
Esplanade 1, bus 96
1020 Brussels