Data Analytics with MS Fabric
Course Overview
| ID | 2401002 |
| Duration | 2.0 days |
| Methods | Lecture with examples and exercises. |
| Prerequisites | Experience with Business Intelligence concepts |
| Target group | Data Analysts, Data Engineers |
| Vorgängerkurs | 1401001 |
Objectives
Get an overview of MS Fabric
Learn about the components of MS Fabric for Business Intelligence
Integrate Data
Use T-SQL and Dataflows for Data Integration
Query Data
Query Data with T-SQL and the Query Editor
Monitor an MS Fabric Data Warehouse
Monitor Activity and Capacity with Various Tools
Secure MS Fabric
Secure Data and Objects
Overview
This course teaches methods and best practices for implementing and managing data analytics solutions with Microsoft Fabric. Participants will learn how to use Fabric dataflows, pipelines, and notebooks to develop analytics artifacts such as semantic models, data warehouses, and lakehouses.
Dates
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 Data Warehousing with MS Fabric
- Create Semantic Models
- Manage and Set Up MS Fabric
- Implement 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
Comelio Media
Still looking for additional reading? Discover suitable specialist books in our catalog.
Content
Overview of Microsoft Fabric
Components and Architecture of MS Fabric - Lakehouses in MS Fabric - Apache Spark - Delta Lake Tables - Orchestrating Processes - Gen2 Dataflows - Data Warehouses in MS Fabric - Data Science Tools - Real-Time Intelligence - Administration
Data Warehouses with MS Fabric
Loading Data: Data Loading Strategies, T-SQL, Gen2 Dataflow, Transformations - Queries: SQL Query Editor, Visual Query Editor - Monitoring: Capacity Metrics, Current Activity, Queries - Security: Dynamic Data Masking, Row-Level Security, Granular SQL Permissions
Semantic Models in MS Fabric
Designing Data Models - DAX Calculations - Semantic Models for Big Data - Performance Optimization - Creating Reusable Power BI Resources - Model Security
Managing Microsoft Fabric
Fabric Administrator Role - Managing Data and Security - Security Model in MS Fabric - Implementing Row- and Column-Level Security - Granular SQL Permissions - Microsoft Purview
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