Learning Microsoft Fabric: A Data Analytics and Engineering Preview

Learning Microsoft Fabric: A Data Analytics and Engineering Preview

1h 30mIntermediate2023-09-15

Authors

Gini von Courter

Gini von Courter

Teaching computer classes on Microsoft Office for 20+ years

Helen Wall

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 LookMicrosoft CopilotPower BIBusiness AnalysisData EngineeringProject ManagementData AnalysisData ScienceBusiness Analysis and StrategyBusiness Software and ToolsMicrosoft

Concepts

Introduction

  • Reshape how your entire team uses data with Microsoft Fabric

Overview

  • Why Fabric matters
  • What is Fabric
  • Enable the Fabric preview

Building Workspaces and Lakehouses

  • OneLake and Lakehouses
  • Create a workspace
  • Create a Lakehouse for Power BI data
  • Explore the Lakehouse
  • Add users to a workspace

Flows in Fabric

  • Create dataflows
  • Load dataflows to Lakehouse
  • Create notebooks
  • Build visuals and AI models with notebooks
  • Build data pipelines
  • Create datamarts
  • Build models in the datamart
  • Build SQL queries and visual queries
  • Create and use datasets
  • Add DAX measures and select tables

Create a Report in Power BI

  • Autocreate a report in Fabric
  • Create a report from scratch
  • Promote or certify your report

Conclusion

  • Fabric resources
40,000 Toman