Use variables to improve performance and troubleshooting

Use variables to improve performance and troubleshooting

Preview unavailable

You must log in or sign up to view this lesson.

LoginSign up

Microsoft Fabric - Data Engineering & Analytics Professional

Buy nowLearn more

Getting Started

  • Microsoft Fabric Program Brochure
  • View Trainer Profile

Get started with Microsoft Fabric

  • Introduction to end-to-end analytics using Microsoft Fabric
  • Understand data warehouse fundamentals
  • Understand data warehouses in Fabric
  • Data teams and Microsoft Fabric
  • Enable Microsoft Fabric
  • Fabric Lakehouse
  • OneLake
  • Data Factory
  • Data Flow – Gen 2
  • Understand Data pipelines
  • Real-Time Intelligence in Microsoft Fabric
  • Lab Exercise- Explore Real-Time Intelligence in Fabric
  • Power BI Workspace Administration– Modelling, Visualization & reporting
  • Data Activator – Real-time insights and automation
  • Fabric Monitor hub
  • Data Governance in Fabric with Purview Compliance Manager

Ingest Data with Microsoft Fabric

  • 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
  • Orchestrate Process and data movement
  • Understand pipelines
  • Use the Copy Data activity
  • Use pipeline templates
  • Run and monitor pipelines

Implement a Data Warehouse with Microsoft Fabric

  • Get Started with data warehouses in Microsoft Fabric
  • Prepare data for analysis and reporting
  • Secure a Microsoft Fabric Data warehouse
  • Monitor a Microsoft Fabric Datawarehouse
  • Load data into Microsoft Fabric
  • Query a data warehouse
  • Explore data load strategies
  • Use data pipelines to load a warehouse
  • Load and transform data with Dataflow Gen2

Implement a Lakehouse with Microsoft Fabric

  • Get Started with Lakehouses in Microsoft Fabric
  • Explore end to end analytics with Microsoft Fabric
  • Work with Delta Lake tables in Microsoft Fabric
  • Explore and transform data in a lakehouse
  • Organize a Fabric lakehouse using Medallion Architecture
  • Lab Exercise - Organize your Fabric lakehouse using a medallion architecture
  • Describe Medallion Architecture
  • Implement a Medallion Architecture in Fabric
  • Considerations for managing your lakehouse

Work with Semantic Models in Microsoft Fabric

  • Add measures to Power BI Desktop models
  • Create simple measures
  • Create compound measures
  • Create quick measures
  • Compare calculated columns with measures
  • Design scalable semantic models
  • Lab Exercise - Design a scalable semantic model
  • Choose the best storage mode
  • Configure semantic models for large data
  • Work with relationships
  • Write DAX for readability with complex calculations
  • Lab Exercise - Create DAX Calculations in Power BI Desktop
  • Create dynamic calculation elements
  • Optimize a model for performance in Power BI
  • Use variables to improve performance and troubleshooting
  • Reduce cardinality
  • Optimize DirectQuery models with table-level storage
  • Create and manage aggregations
  • 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
  • Enforce Power BI model security
  • Lab Exercise: Enforce model security
  • Restrict access to Power BI model data
  • Restrict access to Power BI model objects
  • Apply good modeling practices
  • Work with Power BI Workspace and Co-Pilot
  • Manage Power BI workspaces
  • Collaborate using Power BI shared datasets
  • Enhancing Reports with Copilot

Implement Real-Time Intelligence with Microsoft Fabric

  • Get Started with Real - Time Intelligence
  • 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
  • Work with Real -Time data in a Microsoft Fabric Eventhouse
  • Get started with an eventhouse
  • Materialized views and stored functions
  • Use Real -Time Eventstreams
  • Components of eventstreams
  • Eventstream sources and destinations
  • Eventstream transformations
  • Create Real Time Dashboards
  • Get started with real-time dashboards
  • Lab Exercise - Get started with Real-Time Dashboards in Microsoft Fabric-
  • Advanced features
  • Real-Time Dashboard best practices

Administer and Govern Microsoft Fabric

  • Administer a Microsoft Fabric environment
  • Understand the Fabric Architecture
  • Understand the Fabric administrator role
  • Manage Fabric security
  • Govern data in Fabric
  • Secure data access in Microsoft Fabric
  • Lab Exercise - Secure data access in Microsoft Fabric
  • Understand the Fabric security model
  • Configure workspace and item permissions
  • Secure a Microsoft Fabric data warehouse
  • Lab Exercise - Secure a warehouse in Microsoft Fabric
  • Explore dynamic data masking
  • Implement row-level security
  • Implement column-level security
  • 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

Manage & Monitor Microsoft Fabric Evironment

  • Manage a Microsoft Fabric Environment
  • Monitor activities in Microsoft Fabric
  • Understand monitoring
  • Use Microsoft Fabric Monitor Hub
  • Take action with Microsoft Fabric Activator