Learning Microsoft Fabric
1h 29mIntermediate2025-05-21
Authors

Ginger Grant
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 can help you? In this course, join instructor Ginger Grant as she covers the essentials of Microsoft Fabric: its architecture, data integration functionalities, storage options, advanced analytic features, and more. Get a step-by-step overview of how to add sample data to the Fabric environment, exploring various components such as OneLake, lakehouses, and SQL databases. Along the way, gather insights on techniques for transforming data, using data shortcuts, and leveraging AI skills within Fabric.
Learning objectives
Analyze the architectural components of Microsoft Fabric by comparing and contrasting different data storage solutions (OneLake, lakehouses, and warehoused) to determine the most appropriate use case for each data management approach.
Create comprehensive data integration strategies by designing and implementing data pipelines that effectively gather, transform, and load data from multiple sources using Microsoft Fabric's advanced data movement and shortcut capabilities.
Evaluate the performance and functionality of SQL databases within the Fabric ecosystem by critically assessing configuration options, monitoring performance metrics, and applying appropriate optimization techniques.
Apply AI-enhanced data exploration techniques by implementing chat functionality within lakehouses and warehouses, enabling advanced data interaction and insights generation.
Synthesize the core Microsoft Fabric capabilities by developing a holistic understanding of how different Fabric components interconnect, demonstrating the ability to select and utilize the most appropriate tools for complex data management and analysis scenarios.
Learning objectives
Analyze the architectural components of Microsoft Fabric by comparing and contrasting different data storage solutions (OneLake, lakehouses, and warehoused) to determine the most appropriate use case for each data management approach.
Create comprehensive data integration strategies by designing and implementing data pipelines that effectively gather, transform, and load data from multiple sources using Microsoft Fabric's advanced data movement and shortcut capabilities.
Evaluate the performance and functionality of SQL databases within the Fabric ecosystem by critically assessing configuration options, monitoring performance metrics, and applying appropriate optimization techniques.
Apply AI-enhanced data exploration techniques by implementing chat functionality within lakehouses and warehouses, enabling advanced data interaction and insights generation.
Synthesize the core Microsoft Fabric capabilities by developing a holistic understanding of how different Fabric components interconnect, demonstrating the ability to select and utilize the most appropriate tools for complex data management and analysis scenarios.
Skills covered
Microsoft FabricBusiness AnalysisData EngineeringProject ManagementData AnalysisLearningData ScienceBusiness Analysis and StrategyBusiness Software and ToolsMicrosoft
Concepts
Introduction
- The power of Microsoft Fabric
- Walk-through of course resources
Microsoft Fabric Architecture
- Weaving your way through Microsoft Fabric
- Review Fabric components
- Organizing workspaces
- Challenge - Create a workspace
- Solution - Create a workspace
Lakehouses, Warehouses, and AI
- Detailing your lakehouse
- Sorting out warehouses
- Differences between lakehouses and warehouses
- Adding chat functionality to your lakehouse and warehouse
- Challenge - Adding data to your lakehouse
- Solution - Adding data to your lakehouse
Adding Data to Fabric
- Transforming data in pipelines with Dataflow Gen2
- Gathering data from different sources with the COPY command
- Diving into OneLake
- Challenge - Implementing pipelines
- Solution - Implementing pipelines
SQL Database in Fabric
- Leveraging SQL database in Fabric
- Using SQL database in Fabric
- Monitoring SQL database performance
- Challenge - Create SQL database inside of Fabric
- Solution - Create SQL database inside of Fabric
Continuing Your Fabric Learning Journey
- Further your knowledge with Fabric