Visão Geral

O Curso DP-600T00 Microsoft Fabric Analytics Engineer, ensina análises de ponta a ponta usando o Microsoft Fabric, incluindo o trabalho com lakehouses, Spark e Delta Lake. Os participantes aprenderão sobre ingestão de dados, transformação e inteligência em tempo real. O curso aborda pipelines, segurança e otimização de modelos com o Power BI. Este treinamento para Microsoft Fabric Analytics Engineer prepara você para lidar com dados em escala. Adquira experiência com este curso de certificação DP-600.

Curso DP-600T00 Microsoft Fabric Analytics Engineer é voltado para profissionais de dados que desejam dominar o Microsoft Fabric para construir soluções de análise de ponta a ponta. Este curso aborda desde a ingestão, modelagem e transformação de dados até a criação de relatórios e dashboards em Power BI, utilizando todas as capacidades analíticas unificadas da plataforma Microsoft Fabric. O curso oferece uma abordagem prática e guiada para que os alunos desenvolvam habilidades técnicas e estratégicas essenciais ao papel de um engenheiro de análise.

Objetivo

Após realizar este Curso DP-600T00 Microsoft Fabric Analytics Engineer, você será capaz de:

• Implementar soluções Dataflow para ingestão e transformação de dados no Fabric, incluindo integração com Spark
• Acesse fontes de dados externas, configure a autenticação e otimize a entrada de dados para Lakehouses da Fabric
• Aprenda técnicas para carregar dados em Lakehouses do Fabric como arquivos ou tabelas Delta
• Entenda e utilize os recursos de pipeline do Fabric, incluindo a atividade Copiar Dados e modelos pré-criados, para orquestrar fluxos de dados
• Projetar e criar lakehouses Fabric, ingerir dados de forma eficiente em vários formatos e consultar dados usando SQL
• Aplique os princípios da arquitetura do medalhão no ambiente Fabric para um gerenciamento de dados eficaz
• Analisar dados armazenados em lakehouses do Fabric diretamente do Power BI usando os recursos do DirectLake
• Configurar e utilizar o Spark dentro do Fabric, escolher cenários adequados para notebooks e trabalhos do Spark e manipular dados por meio de quadros de dados do Spark
• Entenda e gerencie o Delta Lake e as tabelas delta no Fabric usando o Spark para gerenciamento e transformações eficientes de dados
• Diferencie data warehouses de lakehouses, trabalhe com data warehouses no Fabric, implemente estratégias de carregamento de dados e crie pipelines usando T-SQL.

Publico Alvo

• Engenheiros de dados
• Engenheiros de análise
• Especialistas em BI
• Profissionais de dados que trabalham com Power BI e Azure Synapse
• Analistas que desejam expandir suas habilidades com a plataforma Microsoft Fabric

Pre-Requisitos

Antes de participar deste curso, recomenda-se que o aluno tenha:

• Conhecimento básico em Power BI
• Familiaridade com conceitos de modelagem de dados
• Conhecimentos em SQL
• Experiência anterior com ferramentas de ETL ou plataformas de análise de dados é um diferencial

Materiais

Conteúdo Programatico

Get started with Microsoft Fabric

• Introduction to end-to-end analytics using Microsoft Fabric
  • Describe end-to-end analytics in Microsoft Fabric
• Get started with lakehouses in Microsoft Fabric
  • Describe core features and capabilities of lakehouses in Microsoft Fabric.
  • Create a lakehouse.
  • Ingest data into files and tables in a lakehouse.
  • Query lakehouse tables with SQL.
• Use Apache Spark in Microsoft Fabric
  • Configure Spark in a Microsoft Fabric workspace
  • Identify suitable scenarios for Spark notebooks and Spark jobs
  • Use Spark to connect to data soueces and ingest data
  • Use Spark dataframes to analyze and transform data
  • Use Spark SQL to query data in tables and views
  • Visualize data in a Spark notebook
• Work with Delta Lake tables in Microsoft Fabric
  • Understand Delta Lake and delta tables in Microsoft Fabric
  • Create and manage delta tables using Spark
  • Optimize delta tables
  • Use Spark to query and transform data in delta tables
  • Use delta tables with Spark structured streaming
• Orchestrate processes and data movement with Microsoft Fabric
  • Describe pipeline capabilities in Microsoft Fabric.
  • Use the Copy Data activity in a pipeline.
  • Create pipelines based on predefined templates.
  • Run and monitor pipelines.
• Ingest Data with Dataflows Gen2 in Microsoft Fabric
  • Describe Dataflow capabilities in Microsoft Fabric
  • Create Dataflow solutions to ingest and transform data
  • Include a Dataflow in a pipeline
• Get started with data warehouses in Microsoft Fabric
  • Describe data warehouses in Fabric.
  • Understand a data warehouse vs a data Lakehouse.
  • Work with data warehouses in Fabric.
  • Create and manage fact tables and dimensions within a data warehouse.
• Get started with Real-Time Intelligence in Microsoft Fabric
  • Describe Real-Time Intelligence in Microsoft Fabric.
  • Create eventhouse databases and tables using KQL database.
  • Describe Real-Time hub in Microsoft Fabric.
  • Use KQL to query tables and create querysets.
• Get started with data science in Microsoft Fabric
  • Understand the data science process
  • Train models with notebooks in Microsoft Fabric
  • Track model training metrics with MLflow and experiments
• Get started with Data Activator in Microsoft Fabric
  • Understand Data Activator.
  • Understand triggers, conditions, and actions in Data Activator.
  • Get data from Power BI Reports and EventStreams with Data Activator.
  • Assign data and create triggers in Data Activator.
  • Interact with Real-Time Intelligence.
• Administer a Microsoft Fabric environment
  • Describe Fabric admin tasks
  • Navigate the admin center
  • Manage user access
  • Govern data in Fabric

Implement a data warehouse with Microsoft Fabric

• Get started with data warehouses in Microsoft Fabric
  • Describe data warehouses in Fabric.
  • Understand a data warehouse vs a data Lakehouse.
  • Work with data warehouses in Fabric.
  • Create and manage fact tables and dimensions within a data warehouse.
• Load data into a Microsoft Fabric data warehouse
  • Learn different strategies to load data into a data warehouse in Microsoft Fabric.
  • Learn how to build a data pipeline to load a warehouse in Microsoft Fabric.
  • Learn how to load data in a warehouse using T-SQL.
  • Learn how to load and transform data with dataflow (Gen 2).
• Query a data warehouse in Microsoft Fabric
  • Use SQL query editor to query a data warehouse.
  • Explore how visual query editor works.
  • Learn how to connect and query a data warehouse using SQL Server Management Studio.
• Monitor a Microsoft Fabric data warehouse
  • Monitor capacity unit usage with the Microsoft Fabric Capacity Metrics app.
  • Monitor current activity in the data warehouse with dynamic management views.
  • Monitor querying trends with query insights views.
• Secure a Microsoft Fabric data warehouse
  • Learn the concepts of securing a data warehouse in Microsoft Fabric.
  • Learn how to implement dynamic data masking to obscure sensitive information.
  • Learn how to configure row-level security to provide granular control.
  • Learn how to implement column-level security to protect sensitive data.
  • Learn how to configure granular permissions using T-SQL.

Work with semantic models in Microsoft Fabric

• Add measures to Power BI Desktop models
  • Determine when to use implicit and explicit measures.
  • Create simple measures.
  • Create compound measures.
  • Create quick measures.
  • Describe similarities of, and differences between, a calculated column and a measure.
• Design scalable semantic models
  • Choose appropriate storage modes for your semantic model.
  • Enable large semantic model storage format and incremental refresh.
  • Create relationships between tables in a semantic model.
  • Design dynamic elements to extend calculations in a semantic model.
• Optimize a model for performance in Power BI
  • Review the performance of measures, relationships, and visuals.
  • Use variables to improve performance and troubleshooting.
  • Improve performance by reducing cardinality levels.
  • Optimize DirectQuery models with table level storage.
  • Create and manage aggregations.
• Use tools to optimize Power BI performance
  • Optimize queries using performance analyzer.
  • Troubleshoot DAX performance using DAX Studio.
  • Optimize a data model using Tabular Editor.
• Create and manage Power BI assets
  • Create core and specialized semantic models.
  • Create Power BI Template and Power BI Project files.
  • Use lineage view and endorse data assets in Power BI service.
  • Use XMLA endpoint to connect semantic models.
• Enforce Power BI model security
  • Restrict access to Power BI model data with RLS.
  • Restrict access to Power BI model objects with OLS.
  • Apply good development practices to enforce Power BI model security.

Administer and govern Microsoft Fabric

• Administer a Microsoft Fabric environment
  • Describe Fabric admin tasks
  • Navigate the admin center
  • Manage user access
  • Govern data in Fabric
• Secure a Microsoft Fabric data warehouse
  • Learn the concepts of securing a data warehouse in Microsoft Fabric.
  • Learn how to implement dynamic data masking to obscure sensitive information.
  • Learn how to configure row-level security to provide granular control.
  • Learn how to implement column-level security to protect sensitive data.
  • Learn how to configure granular permissions using T-SQL.
• Govern data in Microsoft Fabric with Purview
  • Describe the data governance features Microsoft Fabric includes before adding Microsoft Purview.
  • Justify the addition of Microsoft Purview for robust data governance and protection.
  • Connect Microsoft Purview to Microsoft Fabric.
  • Investigate Microsoft Fabric data in the Microsoft Purview hub.