Skip to content
  • Sign In
  • Try Now
View all events
Data Science

Getting Started With Microsoft Fabric

Published by O'Reilly Media, Inc.

Beginner content levelBeginner

Learn the fundamental skills to work with Microsoft Fabric

Course outcomes

  • Understand various components of Microsoft Fabric
  • Examine use cases for implementing a lakehouse or warehouse in Fabric
  • Design Power BI solutions in Microsoft Fabric
  • Implement end-to-end analytics solution in Microsoft Fabric

Course description

Join expert Nikola Ilic to discover why Microsoft Fabric has taken the analytics world by storm. You’ll understand essential concepts and techniques for working with various services and features in Microsoft Fabric and the skills necessary to succeed as a data analytics professional. Learn how to get the most out of the Microsoft Fabric platform with practical examples that any data professional can immediately apply in their day-to-day job.

What you’ll learn and how you can apply it

  • Understand the core components of the Microsoft Fabric platform
  • Design data architecture with lakehouse and warehouse
  • Understand Microsoft Fabric from the Power BI perspective
  • Implement best practices for optimal workloads in Microsoft Fabric

This live event is for you because...

  • You’re a data analyst, BI developer, analytics engineer, or data engineer who wants to apply your skills by using the latest Microsoft data platform solution.
  • You work with data on a daily basis and want to extend your knowledge of the modern data realm.
  • You want to become a Microsoft Fabric data professional.

Prerequisites

  • Basic understanding of data analytics
  • Experience with any BI tool, preferably Microsoft’s stack
  • Foundational knowledge of relational databases

Schedule

The time frames are only estimates and may vary according to how the class is progressing.

Terminology and user interface (45 minutes)

  • Group discussion: What’s your experience level with various BI tools?
  • Presentation: The current data landscape; understanding SaaS, “Unified Experience,” and end-to-end analytics in MS Fabric; Fabric UI (admin portal, experiences, etc.)
  • Q&A

Core components (45 minutes)

  • Presentation: OneLake as a storage layer; working with shortcuts in OneLake; understanding various analytic engines (Spark, SQL, Power BI, KQL); Data Factory workloads; Data Activator and real-time analytics use cases
  • Q&A
  • Break

Lakehouse or warehouse? (30 minutes)

  • Presentation: Differences between and key advantages of lakehouse and warehouse
  • Demonstration: Creating a lakehouse and warehouse in Fabric; identifying relationship keys
  • Q&A

Fabric for Power BI professionals (45 minutes)

  • Presentation: New features from a Power BI perspective; overview of storage modes; Direct Lake mode; differences between the default and custom semantic model
  • Demonstration: Creating a Power BI report using Direct Lake mode
  • Q&A
  • Break

Building an end-to-end analytics solution (45 minutes)

  • Presentation: Scenario for end-to-end analytics solution in MS Fabric; ingesting data by using Dataflows Gen2; implementing a medallion architecture in Fabric lakehouse; creating a custom semantic model in Direct Lake mode; creating a Power BI report to provide insights from the data
  • Q&A

Understanding Fabric licensing options (15 minutes)

  • Presentation: Differences between pay-as-you-go and reserved capacity licenses; choosing the appropriate capacity size
  • Q&A
  • Break

Closing (15 minutes)

  • Presentation: How to get the most out of MS Fabric—practical tips, tricks and recommendations
  • Group discussion: What do you expect from Microsoft Fabric in the future?
  • Q&A

Your Instructor

  • Nikola Ilic

    Nikola Ilic is known as “Data Mozart,” because he’s making music from the data! He works as an independent data platform consultant and trainer focusing on Microsoft technologies. For his exceptional contributions to the tech community, Nikola was awarded a Microsoft Data Platform MVP. He’s also a Microsoft Certified Trainer, blogger, public speaker, mentor, and author of many online courses. He’s interested in everything related to data and is always eager to extract valuable info from raw data most effectively.