Microsoft Fabric For Power Bi Developers

Using Power BI in Microsoft Fabric the new SaaS solution Experiece Microsoft Fabric from a Power BI perspective

What you'll learn

You learn Microsoft Fabric from a Power BI perspective

You learn differences between the Power BI service and the new SaaS Platform Microsoft Fabric

New connection modes for Power BI (including direct Lake)

Customization of Semantic models created in Microsoft Fabric

A hands on practical course (in parts case study) learning Power BI with Fabric using provided data sources

New ways of Power BI report creation (including paginated reports and automatic report creation)

Requirements

The course is hands on so a Fabric (trial) capacity is necessary if you like to do the exercise yourself

Power BI experience is certainly helpful

Fabric experience is NOT required. We start from scratch

Description

"Microsoft Fabric for Power BI Developers" is an exciting deep dive into Microsoft’s latest all-in-one analytics platform, Microsoft Fabric, tailored specifically for Power BI professionals. Microsoft Fabric is revolutionizing the analytics and data landscape by combining data engineering, data integration, data science, real-time analytics, and more into a single, unified platform. As the demand for data-driven insights skyrockets, Fabric is quickly becoming an essential tool for modern data professionals.In this course, you’ll gain practical skills to harness Microsoft Fabric’s capabilities, specifically from a Power BI perspective. We'll focus on key components, starting with the Lakehouse setup, where you’ll learn to store and manage vast data efficiently. Then, we’ll dive into Dataflow Gen 2, an advanced tool for data preparation and transformation. You’ll also learn to design and customize Starschema and Snowflake Semantic Models, essential for creating complex yet high-performance data models.Next, we’ll cover Power BI Report creation options, including Paginated Reports, giving you the flexibility to create and distribute precise, print-ready reports. You’ll explore various Connection Modes like Direct Lake and Direct Query, empowering you to optimize data retrieval and performance. Additionally, this course introduces Taskflows to automate processes and Local Semantic Model Extensions for advanced relationship handling, such as many-to-many relationships.By the end of this course, you’ll not only understand the inner workings of Microsoft Fabric for Power BI, but you’ll also be ready to apply these skills in real-world scenarios. Join us to stay at the forefront of data analytics technology!

Overview

Section 1: Prerequesits Microsoft Power BI within Microsoft Fabric

Lecture 1 1 Microsoft Fabric for Power BI Developers

Lecture 2 Download course resources

Lecture 3 3 Key Terminologies in Microsoft Fabric

Lecture 4 4 Getting started with Power BI in Microsoft Fabric Setting up the Workspace

Lecture 5 5 Creating our first Fabric Item the data storage

Section 2: Data Preparation for Power BI inside Microsoft Fabric

Lecture 6 6 Getting data into Fabric leveraging dataflow gen 2

Lecture 7 7 A brief introduction to dataflow Generation 2

Lecture 8 8 Extending the dataflow with relevant Web data

Lecture 9 9 Dataflow Gen2 data preparation walk through

Lecture 10 10 Table changes and Dataflow Gen 2 special features

Lecture 11 11 Convert uploaded Excel files to Delta Tables in Microsoft Fabric

Lecture 12 12 New Append Option in Dataflow Gen 2 step by step

Lecture 13 13 Building our semantic Model for Power BI Reports

Section 3: Power BI Report creation in Microsoft Fabric

Lecture 14 14 Automatic Power BI Report Creation in Microsoft Fabric

Lecture 15 15 Create Power BI reports tailored to your own specific needs

Lecture 16 16 Fabric Semantik Model Report creation with Power BI Desktop

Lecture 17 17 Paginated Reports with Micrososft Fabric without Report builder

Section 4: Power BI connection modes and local model extension

Lecture 18 18 New Power BI connection modes with direct lake

Lecture 19 19 Connection modes and extending Fabric semantic models with local data

Lecture 20 20 Explicit Measures and a quick time intelligence DAX check

Lecture 21 21 Local Models Many to Many relationship and Snowflake schemas

Section 5: Further Power BI related concepts and important items in Fabric related to Power

Lecture 22 22 Introduction to Task Flows in Fabric Power BI Experience

Lecture 23 23 Lakehouse connection modes from Power BI Desktop

Lecture 24 24 The one lake file explorer for windows

Lecture 25 25 Using external tools to connect to the sql endpoint of microsoft Fabric Lakeh

Section 6: Additonal Content Version Control with Power BI

Lecture 26 Note

Lecture 27 Power BI Version Control inside Fabric 1

Lecture 28 Power BI Version Control inside Fabric 2

Power BI Developers and those who want to work in this area,Anyone interested in Microsoft Fabric from a Power BI perspective,Anyone preparing for future job working with Microsoft Fabric,Data Analysts,Anyone working with Power BI