From the course: Microsoft Fabric Analytics Engineer Associate (DP-600) Cert Prep by Microsoft Press
Unlock this course with a free trial
Join today to access over 25,600 courses taught by industry experts.
Monitoring and managing data warehouses - Microsoft Fabric Tutorial
From the course: Microsoft Fabric Analytics Engineer Associate (DP-600) Cert Prep by Microsoft Press
Monitoring and managing data warehouses
- [Presenter] Managing a data warehouse in Microsoft Fabric involves a continuous cycle of integrating and transforming data, ensuring data quality and proper schema management, securing data, monitoring performance, and ensuring compliances. Fabric provides a robust set of tools that helps automate and streamline these tasks, making it easier to manage complex data environments. By leveraging these tools, you can ensure that the data warehouse remains reliable, secure, and optimized for delivering actionable insights to your organization. We can also manage the data warehouse by data integration and transformation. This process involves using specialized tools known as ETL tools to bring data together from different sources and making sure it is in a consistent format before storing it in data warehouses. Extract means pulling data out from various systems. Transform means cleaning and converting that data into usable…
Contents
-
-
-
(Locked)
Understand relational databases and SQL fundamentals8m 47s
-
Lab: SQL commands to understand relational databases25m 17s
-
(Locked)
Design and implement data warehouses in Microsoft Fabric14m 38s
-
(Locked)
ETL data into the Microsoft Fabric data warehouse7m 14s
-
(Locked)
Load data using data pipeline, Dataflow Gen2, and T-SQL7m 21s
-
(Locked)
Monitoring and managing data warehouses6m 50s
-
(Locked)
Lab: Create a data warehouse and load and ingest data into it16m 23s
-
(Locked)
-
-
-
-
-
-
-