Overview

This course features Coursera Coach! A smarter way to learn with interactive, real-time conversations that help you test your knowledge, challenge assumptions, and deepen your understanding as you progress through the course. Gain foundational knowledge of Microsoft Fabric and discover how to streamline your Power BI workflow. This course takes you through essential aspects of Microsoft Fabric, from initial setup and key terminologies to advanced features like Dataflow Gen 2 and real-time data streaming. You’ll learn how to create Delta tables, visualize data with Power BI, and automate your data processing tasks. The course is structured around guided lessons that walk you through the platform's interface, configuration settings, and data storage methods. You’ll work hands-on with tools like Data Engineering Notebooks, Delta Tables, and external SQL endpoints. Throughout, you will learn to integrate Microsoft Fabric with Power BI for enhanced reporting and analytics. The journey covers creating semantic models, understanding version control, and leveraging the new features of Fabric for advanced data management. You’ll also get the chance to use Microsoft Fabric with Power BI's real-time capabilities, streamlining reporting and data transformation. This course is designed for professionals looking to enhance their data engineering and reporting skills. It’s ideal for beginners, with a focus on Power BI developers and data engineers. Prerequisites include familiarity with Power BI, but no advanced coding skills are required. By the end of the course, you will be able to navigate Microsoft Fabric, create and manage Delta tables, integrate Power BI for automated reporting, and leverage advanced dataflow features for optimized workflows.

Syllabus

Microsoft Fabric for Beginners – How to Get Started

In this module, we will introduce you to Microsoft Fabric, covering essential terms and concepts to help you get started with the platform. We’ll guide you through enabling the trial capacity, configuring your workspace, and creating your first data items in the Lakehouse. Additionally, we will explore advanced features like Delta tables, Dataflow Gen 2, Power BI integration, and version control, ensuring you are well-equipped to manage your data and reporting tasks within Microsoft Fabric.

Prerequisites – Microsoft Power BI within Microsoft Fabric

In this module, we will provide the foundational knowledge necessary for integrating Power BI into the Microsoft Fabric environment. You will learn about the key features designed specifically for Power BI developers, from workspace setup to creating your first Fabric item focused on data storage. This will give you the skills to begin building data solutions for Power BI within Microsoft Fabric.

Data Preparation for Power BI Inside Microsoft Fabric

In this module, we will dive deep into Dataflow Gen 2, exploring its capabilities to streamline data preparation for Power BI inside Microsoft Fabric. We will show you how to import, extend, and transform data from various sources, including web data and Excel files. Additionally, you’ll learn how to create and work with semantic models to enhance the reporting experience in Power BI.

Power BI Report Creation in Microsoft Fabric

In this module, we will show you how to seamlessly integrate Power BI with Microsoft Fabric for enhanced reporting. From automating report creation to building custom reports based on your data needs, you will learn how to leverage semantic models and create detailed paginated reports directly within the platform.

Power BI Connection Modes and Local Model Extension

In this module, we will explore the latest Power BI connection modes and how to use them to extend your data capabilities within Microsoft Fabric. We will also guide you through creating local models and advanced DAX features, which will elevate your data analysis and modeling within Power BI.

Further Power BI Related Concepts and Important Items in Fabric Related to Power

In this module, we will introduce advanced Power BI concepts and features in Microsoft Fabric that enhance data flow, connectivity, and synchronization. We will cover the power of Task Flows for automating processes, syncing semantic models, and managing your data more effectively across the platform.

Bonus: Power BI SharePoint Connection – Best Practices

In this module, we will provide expert tips and best practices for connecting Power BI to SharePoint, ensuring a seamless and high-performance integration. By mastering this connection, you will be able to streamline reporting workflows and enhance your business intelligence processes.