We can host this training at your preferred location. Contact us!

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

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

Upcoming Trainings

Join our public courses in our New Zealand facilities. Private class trainings will be organized at the location of your preference, according to your schedule.

Classroom / Virtual Classroom

10 August 2024