EtusivuHae koulutuksiaImplementing a Data warehouse with Microsoft Fabric – Applied Skills Workshop

Implementing a Data warehouse with Microsoft Fabric – Applied Skills Workshop


Koulutusmuoto

Remote


Kesto

1 päivä


Hinta

1146 €

Explore the data warehousing process and learn how to load, monitor, and query a warehouse in Microsoft Fabric.

You should be familiar with basic data concepts and terminology.

Module 1: Get started with data warehouses in Microsoft Fabric Data warehouses are analytical stores built on a relational schema to support SQL queries. Microsoft Fabric enables you to create a relational data warehouse in your workspace and integrate it easily with other elements of your end-to-end analytics solution.

  • Introduction
  • 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
  • Knowledge check
  • Summary

Module 2: Load data into a Microsoft Fabric data warehouse Data warehouse in Microsoft Fabric is a comprehensive platform for data and analytics, featuring advanced query processing and full transactional T-SQL capabilities for easy data management and analysis.

  • Introduction
  • Explore data load strategies
  • Use data pipelines to load a warehouse
  • Load data using T-SQL
  • Load and transform data with Dataflow Gen
  • Exercise: Load data into a warehouse in Microsoft Fabric
  • Knowledge check
  • Summary

Module 3: Query a data warehouse in Microsoft Fabric Data warehouse in Microsoft Fabric is a comprehensive platform for data and analytics, featuring advanced query processing and full transactional T-SQL capabilities for easy data management and analysis.

  • Introduction
  • 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
  • Knowledge check
  • Summary

Module 4: Monitor a Microsoft Fabric data warehouse A data warehouse is a vital component of an enterprise analytics solution. It's important to learn how to monitor a data warehouse so you can better understand the activity that occurs in it.

  • Introduction
  • Monitor capacity metrics
  • Monitor current activity
  • Monitor queries
  • Exercise - Monitor a data warehouse in Microsoft Fabric
  • Knowledge check
  • Summary