Fabric Analytics Engineer – End-to-End Fabric view

What are "Learning Labs"?

Dynamic Communities’ “Learning Labs” are interactive virtual classrooms designed to foster hands-on learning in a collaborative environment. These exclusive virtual classes will equip attendees with the tools needed to tackle real-world challenges through curated trainings led by experienced instructors. Each course is focused, practical, and built to deliver immediate value that participants put to use in their roles. Whether you're looking to deepen your product knowledge or explore new technologies, Learning Labs offer an engaging and impactful learning experience.

Workshop Level:

Beginners/Intermediate

Description:

Microsoft Fabric is a comprehensive end-to-end analytics solution that consolidates various services into a single platform. These services include data Lake, data engineering, data warehousing, business intelligence, data science, artificial intelligence, semantic modeling, real-time analytics and data governance. Fabric offers an integrated and secure experience, streamlining all your analytical requirements.

In this workshop, we’ll guide data professionals of all sorts—such as data analysts, Power BI users, DBAs, BI/SQL developers, data engineers, and data scientists—through the process of leveraging Microsoft Fabric for an end-to-end experience within the data lifecycle. Even if you have limited or no prior experience with Fabric, you’ll learn how to utilize its multiple experiences to construct an end-to-end analytics solution, use the different tools to perform data engineering, explore ingested and cleaned data to develop advanced analytics and data science, serve final insights with business intelligence, and govern all data assets within the Fabric echosystem. This involves ingesting, transforming, and loading data into the lakehouse, followed by data analysis.

Microsoft Fabric Course Overview Download Slides

Topics Covered:

By the end of this workshop, you’ll have a solid understanding of Microsoft Fabric and its capabilities, and be able to apply gained skills in your day to day work

1. Getting Started with Microsoft Fabric: You’ll become familiar with accessing and navigating the Microsoft Fabric portal. We’ll introduce you to the various experiences available within Fabric, helping you make informed selections.
2. Organizing data in OneLake: Using OneLake as a central storage repository, you’ll build a data lakehouse. We’ll also explain the concepts of Shortcuts and Mirroring, that allow you to retain data in its original location while leveraging your preferred analytics tools.
3. Semantic Model fundamentals: You’ll understand how to design and implement efficient and scalable semantic models for business reporting
4. Visualization and Insights: Finally, you’ll use Power BI, which seamlessly integrates with Fabric, to visualize and share rich interactive reports.
5. Machine Learning: leveraging Fabric Synapse Analytics to develop advanced analytics and data science projects, leveraging Semantic Link
6. AI in Fabric: let’s use all Copilot and AI capabilities within Fabric ecosystem: Fabric Data Agent, Copilot for Power BI (stand alone) integration with Copilot Studio and deployment to Teams.
7. Data Engineering: You’ll perform essential data engineering tasks using Data Factory pipelines and Spark notebooks to transform and enrich the data.
8. Data Governance using Pureview and its data lineage and data quality capabilities

Learning Objectives:

• Learning Objective 1: Understand Microsoft Fabric foundational capabilities and architecture
• Learning Objective 2: Discover Microsoft Fabric Data Engineering, Data Science and Business Intelligence experience within an unified environment
• Learning Objective 3: Learn how to manage, administer and govern multiple data assets within Fabric

Required Prerequisites:

Advance Preparation for the Attendee: Recommended to do the 30-day challenge of Microsoft Fabric from Microsoft Learn

• Basic understanding of data analytics concepts
• Familiarity with basic database concepts - tables, views, relationships
• Microsoft account with access to Microsoft Fabric (free Trial license is ok)
• Laptop with a web browser and an internet connection

Tools Used During This Course: