Microsoft Fabric: Getting Started Course Outline
Special Note to New Hampshire Residents
This course has not yet been approved by the New Hampshire Department of Education. Please contact us for an update on when the class will be available in New Hampshire.
"Get Started with Microsoft Fabric" is a one-day course that provides a comprehensive overview of Microsoft's Fabric data storage environment. Suitable for Data Analysts, Data Engineers, Data Scientists, and Power BI users, this course explores the various components of Microsoft Fabric, including lakehouses, Apache Spark, Delta Lake tables, Data Factory pipelines, and more.
Participants will learn how to leverage Microsoft Fabric for large-scale data analytics, data ingestion, and transformation tasks. The course also covers the creation of relational data warehouses, real-time analytics, and data science capabilities within Microsoft Fabric. Finally, it delves into the administrative aspects of Microsoft Fabric, including security and data governance.
**Special Note: Fabric Work Session for Managers**
This course is also available in a half-day format for managers wanting an overview of the new Fabric environment so that they can plan for a Fabric implementation in their organization. When taught in this format, there is less time allocated for hands-on practice, and more time for discussing implementation and governance issues.
Who Should Attend
This course is appropriate for these roles: Data Analyst, Data Engineer, Data Scientist, and Power BI users who want to explore the capabilities of Microsoft Fabric.
You should be familiar with basic data concepts and terminology.
Introduction to end-to-end analytics using Microsoft Fabric
Discover how Microsoft Fabric can meet your enterprise's analytics needs in one platform. Learn about Microsoft Fabric, how it works, and identify how you can use it for your analytics needs.
Explore end-to-end analytics with Microsoft Fabric
Data teams and Microsoft Fabric
Enable and use Microsoft Fabric
Get started with lakehouses in Microsoft Fabric
Lakehouses merge data lake storage flexibility with data warehouse analytics. Microsoft Fabric offers a lakehouse solution for comprehensive analytics on a single SaaS platform.
Explore the Microsoft Fabric Lakehouse
Work with Microsoft Fabric Lakehouses
Use Apache Spark in Microsoft Fabric
Apache Spark is a core technology for large-scale data analytics. Microsoft Fabric provides support for Spark clusters, enabling you to analyze and process data in a Lakehouse at scale.
Prepare to use Apache Spark
Run Spark code
Work with data in a Spark dataframe
Work with data using Spark SQL
Visualize data in a Spark notebook
Work with Delta Lake tables in Microsoft Fabric
Tables in a Microsoft Fabric lakehouse are based on the Delta Lake storage format commonly used in Apache Spark. By using the enhanced capabilities of delta tables, you can create advanced analytics solutions.
Understand Delta Lake
Create delta tables
Work with delta tables in Spark
Use delta tables with streaming data
Ingest Data with Dataflows Gen2 in Microsoft Fabric
Data ingestion is crucial in analytics. Microsoft Fabric's Data Factory offers Dataflows (Gen2) for visually creating multi-step data ingestion and transformation using Power Query Online.
Understand Dataflows (Gen2) in Microsoft Fabric
Explore Dataflows (Gen2) in Microsoft Fabric
Integrate Dataflows (Gen2) and Pipelines in Microsoft Fabric
Get started with data warehouses in Microsoft Fabric
Data warehouses are analytical stores built on a relational schema to support SQL queries. Microsoft Fabric enables you to create a relational data warehouse in your workspace and integrate it easily with other elements of your end-to-end analytics solution.
Understand data warehouse fundamentals
Understand data warehouses in Fabric
Query and transform data
Prepare data for analysis and reporting
Secure and monitor your data warehouse
Administer Microsoft Fabric
Microsoft Fabric is a SaaS solution for end-to-end data analytics. As an administrator, you can configure features and manage access to suit your organization's needs.
Understand the Fabric Architecture
Understand the Fabric administrator role
Manage Fabric security
Govern data in Fabric
View outline in Word