en
nlfr
IT Training

Data Engineering with Microsoft Fabric

Microsoft Fabric is an all-in-one analytics solution for enterprises that covers everything from data movement to data science, real-time analytics, and business intelligence. It offers a comprehensive suite of services, including data lake, data engineering, and data integration, all in one place. In this 5-day course, you will learn about and experience the major parts of Microsoft Fabric.

Who should attend this course?

This course is targeted to data engineers and BI professionals who want to build and use lakehouses and data warehouses using Microsoft Fabric.

Prerequisites

    Introduction into Microsoft Fabric

  • The chapter introduces the data lake approach. It also provides a high-level overview of the building blocks of Microsoft Fabric and how to get started. The Data Mesh architecture is discussed and compared with Microsoft Fabric.

    • Storing Data in OneLake

  • OneLake provides a single, unified, logical data lake for your whole organization. Like OneDrive, OneLake comes automatically with every Microsoft Fabric tenant and is designed to be the single place for all your analytics data.

    • Working with Delta Tables

  • Delta Lake is an optimized storage layer that provides the foundation for storing data and tables in a Fabric lakehouse. Learn how to create, query and optimize Delta Tables in a Microsoft Fabric.

    • Getting started with Data Factory

  • Data Factory allows you to ingest, prepare and transform data from a rich set of data sources like databases, files, cloud data sources,… This chapter illustrates how to use Activities to build pipelines that ingest data in a Lakehouse.

    • Authoring advanced Pipelines

  • This module dives deeper into the process of building an Fabric pipeline. The module mainly focusses on how to work with expressions, variables and parameters to make dynamic pipelines.

    • Ingest and Transforming data using Dataflows

  • With Dataflows you can visually design data transformations without the need to learn yet another tool or language. Dataflows in Microsoft Fabric are based on Power Query Online.

    • Building a Synapse Data Warehouse

  • A Synapse Data Warehouse is a database that stores data in OneLake and provides a medium to interact with the database using SQL commands.

    • Synapse Data Engineering using Spark

  • Data engineering is the process of designing and building systems that let people collect and analyze raw data from multiple sources and formats. Using popular languages such as Python, SQL and R data can be loaded, transformed and analyzed via interactive notebooks.

    • Data wrangling using PySpark and Spark SQL

  • PySpark and Spark SQL allow users to perform complex data processing tasks with few lines of code using Notebooks.

    • Synapse Real-Time Analytics in Fabric

  • Real-Time Analytics is a fully managed big data analytics platform optimized for streaming, time-series data. It contains a dedicated query language and engine with for searching structured, semi-structured, and unstructured data in close to real-time.

    • Reporting in Fabric

  • Power BI transforms your company’s data into rich visuals for you to monitor your business and get answers quickly. Learn how to connect to your data stored in Microsoft Fabric using Power BI.

    • Data Activator

  • Data Activator in Microsoft Fabric takes action based on what’s happening in your data. Learn how to setup conditions against your data and trigger actions like run a Power Automate Flow when the conditions are met.

Practical information

Duration

Publish

Languages

EN

Price

€2.100 + 21% VAT

Location

Classroom Course

Schedule

Guaranteed to run

Share this course on

Book your training

Enter your information to confirm your booking.

    You might also be interested in

    Prerequisite test

    Take the test

    Looking for a tailor made solution?

    Get started with personal training