Develop a Fabric solution in a day

Are you looking to get started with Microsoft Fabric, or have you already explored it but found the many options overwhelming? This workshop is designed to help you navigate the key capabilities of Microsoft Fabric and understand how to leverage them effectively.

Understanding the Fundamentals

Microsoft Fabric can be used to implement a data mesh or a data fabric architecture. To set the stage, you will first learn about these architectures and the role of domains in structuring your data environment.

Exploring the Five Core Experiences of Microsoft Fabric

This workshop focuses on the five most important experiences that Fabric offers:

1. Data Ingestion

Microsoft Fabric provides two primary approaches for data ingestion:

• Pipelines
• Dataflows Gen 2 (Power Query)

You will see both in action and explore the strengths and limitations of each approach.

2. Data Lakehouse & Warehouse

Ingested data is stored in OneLake, Fabric's unified data lake. However, Fabric automatically integrates this data into a logical data warehouse, complete with a semantic model for reporting.

3. Spark for Data Processing

Spark is an open-source parallel processing framework that allows you to:

• Cleanse and transform OneLake data
• Serve processed data as tables for reports
• Perform advanced analytics and machine learning

This approach is particularly appealing for those with coding skills who prefer programmatic data interaction.

4. Streaming Data & Event Processing

Fabric also supports real-time data processing. You will learn how to:

• Query both batch and streaming data efficiently using Kusto Query Language (KQL)
• Set up an EventHouse for event-driven architectures
• Automate workflows using Data Activators

5. Reporting & Visualization

Fabric includes a robust reporting experience, widely known as Power BI. During the workshop, you’ll build reports using data from OneLake, Spark, and the EventHouse, experiencing firsthand how easy it is to create compelling visual insights.

What You’ll Gain

By the end of the workshop, you will have hands-on experience with the five key aspects of Microsoft Fabric and understand how they can be combined to build a complete data analytics solution.

Prerequisites

No prior experience with Fabric is required. However, familiarity with SQL and the basics of Power BI will be beneficial for the hands-on labs.

Join us for a full day of learning and practical experience, and take your first step towards mastering Microsoft Fabric!