Learning Microsoft Fabric: A Data Analytics and Engineering Preview

1h 30mIntermediate2023-09-15

Authors

Gini von Courter

Teaching computer classes on Microsoft Office for 20+ years

Helen Wall

Data analytics and business analysis expert

Course details

When Microsoft CEO Satya Nadella announced Fabric at the spring 2023 Build conference, he called it the most significant announcement for business data users since the launch of the first version of SQL Server. But what is Fabric? How does it work, and what does it do that will help you? In this course, Microsoft expert Gini von Courter and data analytics expert Helen Wall give you a first look at how Fabric will help your business and data initiatives. Get an overview of the current issues that Fabric was designed to solve, the components that make it up, and how to enable Fabric. Learn how to build a workspace and a lakehouse in Fabric. Find out how to create dataflows and load your dataflow to the Fabric model. Go over creating notebooks, uploading data to them, and using them to build visuals and AI models. Use Datamarts to connect multidimensional models, build pipelines to account for international holidays, and much more. Plus, explore ways to generate a Power BI report using a Fabric data lakehouse.

Skills covered

Microsoft FabricFirst LookPower BIMicrosoft CopilotBusiness AnalysisData EngineeringData AnalysisProject ManagementData ScienceBusiness Analysis and StrategyBusiness Software and ToolsMicrosoft

Concepts

0. Introduction

01 - Reshape how your entire team uses data with Microsoft Fabric

1. Overview

02 - Why Fabric matters
03 - What is Fabric
04 - Enable the Fabric preview

2. Building Workspaces and Lakehouses

05 - OneLake and Lakehouses
06 - Create a workspace
07 - Create a Lakehouse for Power BI data
08 - Explore the Lakehouse
09 - Add users to a workspace

3. Flows in Fabric

10 - Create dataflows
11 - Load dataflows to Lakehouse
12 - Create notebooks
13 - Build visuals and AI models with notebooks
14 - Build data pipelines
15 - Create datamarts
16 - Build models in the datamart
17 - Build SQL queries and visual queries
18 - Create and use datasets
19 - Add DAX measures and select tables

4. Create a Report in Power BI

20 - Autocreate a report in Fabric
21 - Create a report from scratch
22 - Promote or certify your report

Conclusion

23 - Fabric resources