Data Engineering with MS Fabric

The Comeli dragon is teaching at the blackboard at ComelioCademy.

Course Overview

ID 2401003
Duration 2.0 days
Methods Lecture with examples and exercises.
Prerequisites Experience with Business Intelligence concepts
Target group Data Engineers
Vorgängerkurs 1401001

Objectives

Integrating data

Using T-SQL and dataflows for data integration

Using real-time intelligence

Setting up and using event houses and KQL databases

Processing data

Querying and processing data with Apache Spark and Spark SQL

An MS Fabric data Monitor the Warehouse

Monitoring activity and capacity with various tools

Manage MS Fabric

Deploy and secure data and objects

Overview

This course teaches methods and procedures for implementing modern data engineering solutions with Microsoft Fabric. Participants will learn how to design and implement efficient data loading processes, scalable data architectures, and automated orchestration workflows. The goal of the course is to cover the entire data lifecycle – from capture and transformation to securing and managing data engineering solutions, and monitoring data engineering solutions.

Dates

OPEN
IN-HOUSE

Zurzeit stehen keine offenen Termine zur Verfügung. Nutzen Sie alternativ die Inhouse‑Option.

Learn with customized examples and content—precisely tailored to your requirements.

Your benefits at a glance

  • Flexible preferred date
  • Customized content
  • Intensive exchange
  • High practical relevance

Topics

  • Understanding the architecture of MS Fabric
  • Implementing lakehouses with MS Fabric
  • Setting up continuous integration and continuous delivery (CI/CD)
  • Setting up event houses and KQL databases
  • Implementing security

Description

Learn Microsoft Fabric to implement data integration and manage data platforms.

Services

  • Lunch / catering
  • Help with hotel / travel
  • Comelio certificate
  • Flexible: free cancellation up to one day before
Blue coffee pot pouring coffee into two cups.
The Comeli dragon reads in a library surrounded by bookshelves and stacks — symbolizing documentation and knowledge management.

Still looking for additional reading? Discover suitable specialist books in our catalog.

Content

Data integration with MS Fabric

ETL with Dataflows Gen2 - Data Factory and Pipelines - Apache Spark: Load, process, and analyze data with Spark SQL - Eventhouse and KQL databases

Implement a Lakehouse with MS Fabric

Create Microsoft Fabric lakehouses - Work with Apache Spark and Spark SQL to transform, visualize, and analyze data - Create and use Delta Lake tables

Real-time Intelligence with Microsoft Fabric - Eventhouses and KQL Databases - Real-Time Dashboards - Fabric Activator: Configuration, Rules, Actions

Eventstream in Real-Time Intelligence (RTI)

Managing an MS Fabric Environment

Continuous Integration and Continuous Delivery (CI/CD): Version Control and Git Integration, Deployment Pipelines - Monitoring MS Fabric with the Microsoft Fabric Activator - Configuring Workspace and Item Permissions - Managing Security in Microsoft Fabric

Instructor

Marco Skulschus studied economics with a focus on business informatics in Wuppertal and Paris and has been working as a lecturer and developer of data analysis solutions using the Microsoft BI Stack for over 10 years. He is also an author of specialist books and has been involved in various research projects.

Publications

  • MS SQL Server - T-SQL Abfragen und Analysen (Comelio Medien )
    978-3-939701-93-4
  • MS SQL Server - Implementierung, Administration und Programmierung mit T-SQL (Comelio Medien )
    978-3-939701-71-2
  • MS SQL Server 2014 - XML-Integration mit T-SQL (Comelio Medien )
    978-3-939701-97-2
  • SQL und relationale Datenbanken (Comelio Medien )
    978-3-939701-52-1

Projects

As a developer, Mr. Skulschus designs business analytics systems using Microsoft tools. He develops data lakehouses, data warehouses, and reporting components.

Research

He led various research projects using semantic technologies or complex relational and ontological data modeling.

Certificates

Marco Skulschus is a Microsoft Certified: Power BI Data Analyst Associate, a Microsoft Certified: Fabric Analytics Engineer Associate, a Microsoft Certified Trainer, and has completed various other Microsoft certifications.