Unlock the power of modern data warehousing with Microsoft Fabric, a unified analytics platform designed for the era of AI and cloud-scale analytics. This comprehensive 2-day instructor-led course equips data professionals with the skills to design, implement, and manage data warehouses using Microsoft Fabric’s Lakehouse and Warehouse capabilities.
Through hands-on labs and real-world scenarios, participants will learn how to ingest, transform, and serve data efficiently using Fabric's integrated tools like Data Factory, Dataflows Gen2, and SQL Analytics Endpoint. The course also emphasizes best practices for data governance, performance tuning, and scalability in cloud environments.
What You Will Learn
- Understand the architecture and capabilities of Microsoft Fabric
- Build and manage a data warehouse using the Warehouse experience in Fabric
- Load and transform data using Dataflows Gen2 and T-SQL
- Query and analyze data using SQL Analytics Endpoint
- Optimize performance and manage compute resources effectively
- Implement data security and governance using Microsoft Purview
This course is ideal for:
- Data Engineers
- Database Administrators
- BI Professionals
- Anyone responsible for designing and implementing data warehousing solutions on Microsoft Fabric
Before attending this course, participants should have:
- A basic understanding of database concepts and T-SQL
- Familiarity with data warehousing principles
- Prior experience with Microsoft Azure or Power BI is beneficial but not mandatory
- Lesson: Describe end-to-end analytics in Microsoft Fabric
- Lesson: Understand data teams and roles that use Fabric
- Lesson: Describe how to enable and use Fabric
- Lesson: Data warehouse fundamentals
- Lesson: Understand Fabric warehouses
- Lesson: Create a data warehouse in Fabric
- Lesson: Design a data warehouse
- Lab: Analyze data in a data warehouse
- Lesson: Understand ETL (Extract, Transform and Load)
- Lesson: Stage the data
- Lesson: Different data load types
- Lesson: Create tables with T-SQL
- Lab: Load data into a warehouse in Microsoft Fabric
- Lesson: Aggregate measures by dimension attributes
- Lesson: Joins in a snowflake schema
- Lesson: DAX calculations
- Lab: Query a data warehouse in Microsoft Fabric
- Lesson: Monitor capacity metrics
- Lesson: Monitor current activity
- Lesson: Monitor queries
- Lab: Monitor a data warehouse in Microsoft Fabric
- Lesson: Explore dynamic data masking
- Lesson: Implement row-level security
- Lesson: Implement column-level security
- Lesson: Configure SQL granular permissions using T-SQL
- Lab: Secure a warehouse in Microsoft Fabric
This course is ideal for data engineers, database administrators, and BI professionals who are responsible for building or managing data warehousing solutions and want to leverage Microsoft Fabric for scalable, cloud-based analytics.
Participants should have a basic understanding of data warehouse concepts and experience with T-SQL. Familiarity with Microsoft Azure, Power BI, or cloud-based data platforms is helpful but not required.
You will work with Microsoft Fabric’s components such as Dataflows Gen2, the SQL Analytics Endpoint, the Warehouse experience, and Microsoft Purview. The course emphasizes practical usage of these tools in real-world data warehousing scenarios.
Yes, the course includes hands-on labs and guided exercises that provide practical experience in building, managing, and optimizing a data warehouse using Microsoft Fabric.
Yes, participants who complete the training will receive a certificate of completion, which can be a valuable addition to your professional development and certification portfolio.
