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