Microsoft Fabric Analytics Engineer

Outline

• Introduction to end-to-end analytics using Microsoft Fabric
  • Explore end-to-end analytics with Microsoft Fabric
  • Explore data teams and Microsoft Fabric
  • Enable and use Microsoft Fabric
  • Module assessment
• Get started with lakehouses in Microsoft Fabric
  • Explore the Microsoft Fabric lakehouse
  • Work with Microsoft Fabric lakehouses
  • Explore and transform data in a lakehouse
  • Exercise - Create a Microsoft Fabric lakehouse
  • Module assessment
• Use Apache Spark in Microsoft Fabric
  • Prepare to use Apache Spark
  • Run Spark code
  • Work with data in a Spark dataframe
  • Work with data using Spark SQL
  • Visualize data in a Spark notebook
  • Exercise - Analyze data with Apache Spark
  • Module assessment
• Work with Delta Lake tables in Microsoft Fabric
  • Understand Delta Lake
  • Create delta tables
  • Optimize delta tables
  • Work with delta tables in Spark
  • Use delta tables with streaming data
  • Exercise - Use delta tables in Apache Spark
  • Module assessment
• Orchestrate processes and data movement with Microsoft Fabric
  • Understand pipelines
  • Use the Copy Data activity
  • Use pipeline templates
  • Run and monitor pipelines
  • Exercise - Ingest data with a pipeline
  • Module assessment
• Ingest Data with Dataflows Gen2 in Microsoft Fabric
  • Understand Dataflows Gen2 in Microsoft Fabric
  • Explore Dataflows Gen2 in Microsoft Fabric
  • Integrate Dataflows Gen2 and Pipelines in Microsoft Fabric
  • Exercise - Create and use a Dataflow Gen2 in Microsoft Fabric
  • Module assessment
• 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 assessment
• Get started with Real-Time Intelligence in Microsoft Fabric
  • What is real-time data analytics?
  • Real-Time Intelligence in Microsoft Fabric
  • Ingest and transform real-time data
  • Store and query real-time data
  • Visualize real-time data
  • Automate actions
  • Exercise - Explore Real-Time Intelligence in Fabric
  • Module assessment
• Get started with data science in Microsoft Fabric
  • Understand the data science process
  • Explore and process data with Microsoft Fabric
  • Train and score models with Microsoft Fabric
  • Exercise - Explore data science in Microsoft Fabric
  • Module assessment
• Administer a Microsoft Fabric environment
  • Understand the Fabric Architecture
  • Understand the Fabric administrator role
  • Manage Fabric security
  • Govern data in Fabric
  • Module assessment
• Introduction to end-to-end analytics using Microsoft Fabric
  • Explore end-to-end analytics with Microsoft Fabric
  • Explore data teams and Microsoft Fabric
  • Enable and use Microsoft Fabric
  • Module assessment
• 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 assessment
• 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 assessment
• 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
  • Exercise: Query a data warehouse in Microsoft Fabric
  • Module assessment
• Monitor a Microsoft Fabric data warehouse
  • Monitor capacity metrics
  • Monitor current activity
  • Monitor queries
  • Exercise - Monitor a data warehouse in Microsoft Fabric
  • Module assessment
• 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
  • Exercise: Secure a warehouse in Microsoft Fabric
  • Module assessment
• Add measures to Power BI Desktop models
  • Create simple measures
  • Create compound measures
  • Create quick measures
  • Compare calculated columns with measures
  • Check your knowledge
  • Exercise - Create DAX Calculations in Power BI Desktop
• Design scalable semantic models
  • Choose the best storage mode
  • Configure semantic models for large data
  • Work with relationships
  • Write DAX for readability with complex calculations
  • Create dynamic calculation elements
  • Exercise - Design a scalable semantic model
  • Module assessment
• Optimize a model for performance in Power BI
  • Introduction to performance optimization
  • Review performance of measures, relationships, and visuals
  • Use variables to improve performance and troubleshooting
  • Reduce cardinality
  • Optimize DirectQuery models with table level storage
  • Create and manage aggregations
  • Check your knowledge
• Create and manage Power BI assets
  • Create reusable Power BI assets
  • Manage development lifecycle for Power BI assets
  • Use lineage view and endorse data assets
  • Manage a Power BI semantic model using XMLA endpoint
  • Exercise: Create reusable Power BI assets
  • Module assessment
• Enforce Power BI model security
  • Restrict access to Power BI model data
  • Restrict access to Power BI model objects
  • Apply good modeling practices
  • Exercise: Enforce model security
  • Module assessment
• Administer a Microsoft Fabric environment
  • Understand the Fabric Architecture
  • Understand the Fabric administrator role
  • Manage Fabric security
  • Govern data in Fabric
  • Module assessment
• Secure data access in Microsoft Fabric
  • Understand the Fabric security model
  • Configure workspace and item permissions
  • Apply granular permissions
  • Exercise: Secure data access in Microsoft Fabric
  • Module assessment
• 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
  • Exercise: Secure a warehouse in Microsoft Fabric
  • Module assessment
• Govern data in Microsoft Fabric with Purview
  • Govern data in Microsoft Fabric
  • Why use Microsoft Purview with Microsoft Fabric?
  • Govern data in the Microsoft Purview hub
  • Module assessment