Explore o processo de warehousing de dados e aprenda a carregar, monitorizar e consultar uma warehouse no Microsoft Fabric.
O presente workshop auxilia na preparação para o exame DP-600: Implementing Analytics Solutions Using Microsoft Fabric (beta).
Objetivos
Os participantes aprenderão a:
- Dar os primeiros passos em data warehouses no Microsoft Fabric
- Carregar dados num data warehouse do Microsoft Fabric
- Consultar um data warehouse no Microsoft Fabric
- Monitorizar um data warehouse do Microsoft Fabric
Destinatários
Profissionais que pretendam implementar um data warehouse com recurso ao Microsoft Fabric
Pré-Requisitos
Os participantes deverão estar familiarizados com terminologia e conceitos básicos de dados.
Programa
- Introduction to end-to-end analytics using Microsoft Fabric
- Get started with data warehouses in Microsoft Fabric
- Load data into a Microsoft Fabric data warehouse
- Query a data warehouse in Microsoft Fabric
- Monitor a Microsoft Fabric data warehouse
- Secure a Microsoft Fabric data warehouse
Introduction to end-to-end analytics using Microsoft Fabric
- Explore end-to-end analytics with Microsoft Fabric
- Data teams and Microsoft Fabric
- Enable and use Microsoft Fabric
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
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
Query a data warehouse in Microsoft Fabric
- Query data
- Use the SQL query editor
- Explore the visual query editor
- Use client tools to query a warehouse
Monitor a Microsoft Fabric data warehouse
- Monitor capacity metrics
- Monitor current activity
- Monitor queries
Secure a Microsoft Fabric data warehouse
- Explore dynamic data masking
- Implement row-level security
- Implement column-level security
- Configure SQL granular permissions using T-SQL
