Skip to Content
View all events

Microsoft Fabric Analytics Engineer Associate Bootcamp (DP-600)

Published by O'Reilly Media, Inc.

Beginner to intermediate content levelBeginner to intermediate

Learn in-demand skills and become a certified Fabric Analytics Engineer

Course outcomes

  • Understand the role of the Analytics Engineer in today’s data realm
  • Examine various components of Microsoft Fabric and their use cases
  • Discover implementation methods of Microsoft Fabric concepts and features
  • Get ready for the DP-600 exam (Implementing Analytics Solutions Using Microsoft Fabric)

Have you ever dreamed of becoming an Analytics Engineer and mastering the most in-demand skills in today’s data analytics ecosystem? This course will boost your career opportunities in the analytics realm, while at the same time setting you ready for acquiring the popular DP-600 certificate (Microsoft Fabric Analytics Engineer). You’ll learn the skills necessary to succeed as an Analytics Engineer, and how to practically apply these skills by using Microsoft Fabric!

This course includes practical examples that any Analytics Engineer can immediately apply in their day-to-day job, and many useful tips specifically related to successfully passing the DP-600 exam.

NOTE: With today’s registration, you’ll be signed up for both sessions. Although you can attend either of the sessions individually, we recommend participating in both.

What you’ll learn and how you can apply it

  • Implement end-to-end analytics solution in Microsoft Fabric
  • Prepare and enrich data for analysis in Microsoft Fabric
  • Secure and maintain Fabric assets
  • Implement and manage semantic models

This live event is for you because...

  • You’re a data analyst, data engineer, or a BI professional who wants to transition into an analytics engineer role.
  • You work with data on a daily basis, using various tools or service, such as Microsoft Power BI, Azure Synapse Analytics, SQL Server, or Azure SQL DB.
  • You want to become a certified Microsoft Fabric Analytics Engineer.

Prerequisites

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

Course Followup:

Schedule

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

Day 1: Preparing and Serving Data in Microsoft Fabric

Course Introduction(15 minutes)

  • Presentation: Check-in, agenda and learning outcomes
  • Discussion: What’s your experience level with Microsoft Fabric and related tools?
  • Q&A

Microsoft Fabric Core Components (45 minutes)

  • Presentation: Fabric - unified platform, tools, people who work with Fabric
  • OneLake
  • Different Fabric engines
  • Delta format as a key pillar of Fabric
  • Q&A

Prepare Data in Microsoft Fabric - Get Data (25 minutes)

  • Presentation: Create a data connection
  • Discover data by using OneLake data hub and real-time hub
  • Ingest or access data as needed
  • Choose between a lakehouse, warehouse, or eventhouse
  • Implement OneLake integration for eventhouse and semantic models
  • incl. Q&A and Break

Prepare Data in Microsoft Fabric - Transform Data (90 minutes)

  • Presentation: Create views, functions, and stored procedures
  • Enrich data by adding new columns or tables
  • Implement a star schema for a lakehouse or warehouse
  • Denormalize data
  • Aggregate data
  • Merge or join data
  • Identify and resolve duplicate data, missing data, or null values
  • Convert column data types
  • Filter data
  • Incl. Q&A and Break

Prepare Data in Microsoft Fabric - Query and Analyze Data (45 minutes)

  • Presentation: Select, filter, and aggregate data by using the Visual Query Editor
  • Select, filter, and aggregate data by using SQL
  • Select, filter, and aggregate data by using KQL
  • Q&A

Maintain a Data Analytics Solution - Implement Security and Governance (20 minutes)

  • Presentation: Implement workspace-level access controls
  • Implement item-level access controls
  • Implement row-level, column-level, object-level, and file-level access control
  • Apply sensitivity labels to items
  • Endorse items
  • Q&A

Day 2: Implementing and Managing Semantic Models in Microsoft Fabric

Maintain the Analytics Development Lifecycle (60 minutes)

  • Presentation: Configure version control for a workspace
  • Create and manage a Power BI Desktop project (.pbip)
  • Create and configure deployment pipelines
  • Perform impact analysis of downstream dependencies from lakehouses, data warehouses, dataflows, and semantic models
  • Deploy and manage semantic models by using the XMLA endpoint
  • Create and update reusable assets, including Power BI template (.pbit) files, Power BI data source (.pbids) files, and shared semantic models

Design and Build Semantic Models (120 minutes)

  • Presentation: Choose a storage mode
  • Implement a star schema for a semantic model
  • Implement relationships, such as bridge tables and many-to-many relationships
  • Write calculations that use DAX variables and functions, such as iterators, table filtering, windowing, and information functions
  • Implement calculation groups, dynamic format strings, and field parameters
  • Identify use cases for and configure large semantic model storage format
  • Design and build composite models
  • Incl. 2xQ&A and Breaks

Optimize Enterprise-scale Semantic Models (30 minutes)

  • Presentation: Implement performance improvements in queries and report visuals
  • Improve DAX performance
  • Configure Direct Lake, including default fallback and refresh behavior
  • Implement incremental refresh for semantic models

Practical Exam Tips, Quiz, and Closing (30 minutes)

  • Presentation: How to prepare for the exam - practical tips, tricks and recommendations
  • Discussion: What do you expect from the certificate?
  • Quiz: Check participants’ knowledge in an interactive quiz using Slido (10 questions)
  • Q&A session
  • Wrap up and feedback

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.

Skills covered

  • Microsoft Fabric
  • Business Intelligence