Immersion Microsoft Fabric: Architecture & Practices - 1 Day Workshop

Unlock the Power of Unified Analytics with Microsoft Fabric! Move beyond high-level overviews and master the architectural reality of Microsoft Fabric. This 1-day "Immersion Microsoft Fabric" workshop is designed for Data Architects, Data Engineers, and BI Professionals who are ready to modernize their data estate. We guide you through the transition from fragmented silos to a unified SaaS foundation, ensuring you understand not just how to use the tools, but why and when to apply them for maximum performance and cost-efficiency.

How We Help the Customer Adopting a new platform brings challenges regarding governance, cost management, and architectural choices. Our workshop accelerates your adoption curve by:

• Demystifying the Architecture: We break down the separation of Compute and Storage to help you design a scalable OneLake strategy.
• Optimizing Performance: We teach you the engineering best practices (V-Order, Partitioning) required to leverage the revolutionary Direct Lake mode in Power BI.
• Controlling Costs: We provide a "FinOps" deep dive into F-SKU capacities, throttling, and bursting, helping you avoid billing surprises.
• Industrializing Data: We move beyond the "Click-Ops" approach, introducing CI/CD, Git integration, and robust security models for production environments.

Technologies Covered This workshop covers the end-to-end capabilities of the Microsoft Fabric ecosystem, including:

• OneLake: Managing shortcuts, domains, and the "OneDrive for Data" concept.
• Data Factory: Orchestrating pipelines and utilizing Dataflows Gen2 for ingestion.
• Data Engineering: Using Apache Spark and Notebooks for advanced transformation.
• Data Warehouse: leveraging T-SQL for serving data.
• Power BI: Implementing Direct Lake mode and composite modeling.

Workshop Agenda

Morning: Foundations & Ingestion

• Architecture Realities: Understanding the SaaS model, Capacity Units (CU), and Tenant Governance.
• The Storage Debate: Detailed comparison of Lakehouse (Spark-centric) vs. Data Warehouse (SQL-centric) and how to implement a Medallion Architecture.
• Ingestion Strategies: When to use Pipelines vs. Dataflows, and how to use Shortcuts and Mirroring to achieve "Zero-Copy" data integration.

Afternoon: Transformation & Serving

• Advanced Engineering: A "Pro-Code" module focused on Spark Notebooks, Delta Parquet optimization, and Python-based transformations.
• The Direct Lake Revolution: Connecting Power BI directly to OneLake to eliminate data latency and import refresh limits.
• Industrialization & FinOps: Deploying with confidence using Deployment Pipelines, Git Integration, and Row-Level Security (RLS).

Deliverables By the end of the day, participants will have built a functional end-to-end Proof of Concept (POC)—from raw data ingestion to a high-speed Power BI report—and will possess the knowledge to architect a production-ready Fabric environment.