This class offers a comprehensive understanding of implementing a data warehouse using Microsoft Fabric, a powerful platform for data and analytics. Participants will gain practical knowledge in setting up, managing, and optimizing a data warehouse, ensuring seamless integration with other analytics tools. The curriculum covers essential topics like data loading, querying, monitoring, and securing your data warehouse, providing a well-rounded education in modern data warehousing techniques.
Designed for professionals seeking to enhance their data management skills, this course equips learners with the expertise to handle complex data environments efficiently. By the end of the course, attendees will be proficient in using Microsoft Fabric to support robust data analytics solutions, driving better business insights and decision-making.
Audience Profile
This course is ideal for data professionals, including data engineers, data analysts, and database administrators, who are looking to deepen their understanding of data warehousing and analytics using Microsoft Fabric. It is also suitable for IT professionals responsible for managing data infrastructure and ensuring data security within an organization.
Prerequisites
You should be familiar with basic data concepts and terminology.
Course Outline
Module 1: Get started with data warehouses in Microsoft Fabric
- 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
- Exercise - Analyze data in a data warehouse
Module 2: Load data into a Microsoft Fabric data warehouse
- Explore data load strategies
- Use data pipelines to load a warehouse
- Load data using T-SQL
- Load and transform data with Dataflow Gen2
- Exercise: Load data into a warehouse in Microsoft Fabric
Module 3: Query a data warehouse in Microsoft Fabric
- Use the SQL query editor
- Explore the visual query editor
- Use client tools to query a warehouse
- Exercise: Query a data warehouse in Microsoft Fabric
Module 4: Monitor a Microsoft Fabric data warehouse
- Monitor capacity metrics
- Monitor current activity
- Monitor queries
- Exercise - Monitor a data warehouse in Microsoft Fabric
Module 5: Monitor a Microsoft Fabric data warehouse
- Explore dynamic data masking
- Implement row-level security
- Implement column-level security
- Configure SQL granular permissions using T-SQL
- Exercise: Secure a warehouse in Microsoft Fabric
