"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.
Prerequisites
You should be familiar with basic data concepts and terminology.
COURSE OUTLINE
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