DP-602: Implement a Data Warehouse with Microsoft Fabric (Live Online)

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 ProfileThis 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.PrerequisitesYou should be familiar with basic data concepts and terminology.Course OutlineModule 1: Get started with data warehouses in Microsoft FabricUnderstand data warehouse fundamentalsUnderstand data warehouses in FabricQuery and transform dataPrepare data for analysis and reportingSecure and monitor your data warehouseExercise - Analyze data in a data warehouseModule 2: Load data into a Microsoft Fabric data warehouseExplore data load strategiesUse data pipelines to load a warehouseLoad data using T-SQLLoad and transform data with Dataflow Gen2Exercise: Load data into a warehouse in Microsoft FabricModule 3: Query a data warehouse in Microsoft FabricUse the SQL query editorExplore the visual query editorUse client tools to query a warehouseExercise: Query a data warehouse in Microsoft FabricModule 4: Monitor a Microsoft Fabric data warehouseMonitor capacity metricsMonitor current activityMonitor queriesExercise - Monitor a data warehouse in Microsoft FabricModule 5: Monitor a Microsoft Fabric data warehouseExplore dynamic data maskingImplement row-level securityImplement column-level securityConfigure SQL granular permissions using T-SQLExercise: Secure a warehouse in Microsoft Fabric