Microsoft Fabric for Data Engineers

1 day /8 hours | online / onsite | seminar style

Real world content for hands-on pros.

This workshop is ideal for data engineers, architects, and data professionals looking to hone their skills in the Azure data platform. Whether you want to improve your skills as a data engineer or integrate analytics into your workflow, this workshop will equip you with the knowledge needed to achieve your desired results.

What Does this Course Cover?

Dive into the world of data engineering with our Microsoft Fabric workshop, designed specifically for data engineers. This seminar will take you through lake architecture, data ingestion, transformation, and analytics techniques.

Next Dates

17/04/2024; Vienna, onsite; EUR 650,00 register

Course Outline

  • Introduction to Microsoft Fabric
    • Introductory module that familiarizes data engineers with the core components of Microsoft Fabric, such as OneLake, Data Engineering, Datawarehouse, Data science, Real-time analytics, Data activator, and PowerBI
  • Workspaces
    • Overview
    • Create and manage workspaces
  • Data Management
    • Create lakehouse
    • Managed tables
    • External (unmanaged tables)
    • Delta tables
  • Data Ingestion and Transformation
    • Manual upload
    • Using Spark
    • Using Data pipeline
    • Using Dataflow Gen2
    • Limitations
  • Datawarehouse
    • Overview
    • Data ingestion and transformation using pipelines/T-SQL/Copy
    • Query using T-SQL, SQL/visual query editor
    • Semantic models
    • Limitations
  • Data Visualization and Reporting
    • Overview
    • Visualize data using notebooks
    • Create reports in PowerBI
    • Create paginated reports
  • Data Activator
    • Overview
    • Events, Objects, Triggers and Properties
    • Get data
    • Integration with MS tools
    • Limitations
  • Real-time Analytics
    • Overview
    • Get data
    • Store and analyze data
    • Respond to data (using Data Activator)

Karol Papaj

Trainer & Author

Karol Papaj, MCTS and former SQL Server MVP, is a mentor with Lucient since 2006. Karol is specializing in Relational Engine and Business Intelligence in SQL Server with focus on Performance Tuning and High Availability. He has been working with SQL Server since SQL Server 6.5 and participates in many projects for IT/Telco companies and companies from the banking industry in Slovakia. Besides mentoring and consulting Karol regularly speaks at conferences organizing by Microsoft and at community events in Slovakia and neighboring countries and teaching Lucient’s SQL Server courses.