Data Analytics with MS Fabric
Seminarübersicht
| ID | 2401002 |
| Dauer | 2.0 Tage |
| Methoden | Lecture with examples and exercises. |
| Vorwissen | Experience with Business Intelligence concepts |
| Zielgruppe | Data Analysts, Data Engineers |
| Vorgängerkurs | 1401001 |
Ziele
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
Übersicht
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.
Termine
Zurzeit stehen keine offenen Termine zur Verfügung. Nutzen Sie alternativ die Inhouse‑Option.
Lernen Sie anhand maßgeschneiderter Beispiele und Inhalte – passgenau für Ihre Anforderungen.
Ihre Vorteile im Überblick
- Flexibles Wunschdatum
- Maßgeschneiderte Inhalte
- Intensiver Austausch
- Hoher Praxisbezug
Themen
- Understanding the Architecture of MS Fabric
- Implementing Data Warehousing with MS Fabric
- Create Semantic Models
- Manage and Set Up MS Fabric
- Implement Security
Beschreibung
Learn Microsoft Fabric to implement data integration and manage data platforms.
Services
- Mittagessen / Catering
- Hilfe bei Hotel / Anreise
- Comelio-Zertifikat
- Flexibel: Bis einen Tag vorher kostenlos stornieren
Comelio Medien
Noch auf der Suche nach weiterführender Literatur? Entdecken Sie passende Fachbücher in unserem Katalog.
Inhalt
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
Dozent/in
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.
Veröffentlichungen
- 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