Secure a Microsoft Fabric data warehouse

Secure a Microsoft Fabric data warehouse

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