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.
IT Training
Data Engineering with Microsoft Fabric
Qui devrait suivre ce cours?
This course is targeted to data engineers and BI professionals who want to build and use lakehouses and data warehouses using Microsoft Fabric.
Prérequis
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- A Synapse Data Warehouse is a database that stores data in OneLake and provides a medium to interact with the database using SQL commands.
- 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.
- PySpark and Spark SQL allow users to perform complex data processing tasks with few lines of code using Notebooks.
- 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.
- 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 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.
Introduction into Microsoft Fabric
Storing Data in OneLake
Working with Delta Tables
Getting started with Data Factory
Authoring advanced Pipelines
Ingest and Transforming data using Dataflows
Building a Synapse Data Warehouse
Synapse Data Engineering using Spark
Data wrangling using PySpark and Spark SQL
Synapse Real-Time Analytics in Fabric
Reporting in Fabric
Data Activator
Informations practiques
Durée
5 Days
Langues
EN
Prix
€2.100 + 21% VAT
Emplacement
Classroom Courses
Plannings
Réservez votre formation
Entrez vos informations pour confirmer votre réservation.