DP - 602T00 : Implement a data warehouse with Microsoft Fabric
This course covers the data warehousing process, teaching you how to load, monitor, and query data warehouses within Microsoft Fabric. Learn to effectively manage and analyze large datasets to support business intelligence and decision-making.
Instructor
DP - 602T00 : Implement a data warehouse with Microsoft Fabric
Curriculum
Master DP-602T00: Implement a Data Warehouse with Microsoft Fabric Training. Gain hands-on skills to design, build & manage modern data solutions.
DP - 602T00 : Implement a data warehouse with Microsoft Fabric
The DP - 602T00 : Implement a data warehouse with Microsoft Fabric course teaches participants how to implement data warehouses using Microsoft Fabric, focusing on data storage, ETL processes, and optimizing query performance for analytics. Microsoft Fabric is an end-to-end analytics platform that provides a single, integrated environment for data professionals and the business to collaborate on data projects. Fabric provides a set of integrated services that enable you to ingest, store, process, and analyze data in a single environment.
Audience Profile:
The primary audience for this course includes:
Data Analysts
Data Engineers
Microsoft Fabric users
Prerequisites:
Familiarity with basic data concepts and terminology.
Course Outline:
Module 1: Get Started with Data Warehouses in Microsoft Fabric
Understand data warehouses in Microsoft Fabric.
Differentiate between a data warehouse and a data lakehouse.
Work with data warehouses in Fabric.
Create and manage fact tables and dimensions in a data warehouse.
Module 2: Load Data into a Microsoft Fabric Data Warehouse
Learn various strategies to load data into a data warehouse in Microsoft Fabric.
Build a data pipeline for loading the warehouse.
Load data into a warehouse using T-SQL.
Load and transform data with dataflow (Gen 2).
Module 3: Query a Data Warehouse in Microsoft Fabric
Query a data warehouse using the SQL query editor.
Explore the functionality of the visual query editor.
Connect and query a data warehouse using SQL Server Management Studio.
Module 4: Monitor a Microsoft Fabric Data Warehouse
Monitor capacity unit usage with the Microsoft Fabric Capacity Metrics app.
Track current activity in the warehouse with dynamic management views.
Analyze querying trends using query insights views.
The DP - 602T00 : Implement a data warehouse with Microsoft Fabric course teaches participants how to implement data warehouses using Microsoft Fabric, focusing on data storage, ETL processes, and optimizing query performance for analytics. Microsoft Fabric is an end-to-end analytics platform that provides a single, integrated environment for data professionals and the business to collaborate on data projects. Fabric provides a set of integrated services that enable you to ingest, store, process, and analyze data in a single environment.
Audience Profile:
The primary audience for this course includes:
Data Analysts
Data Engineers
Microsoft Fabric users
Prerequisites:
Familiarity with basic data concepts and terminology.
Course Outline:
Module 1: Get Started with Data Warehouses in Microsoft Fabric
Understand data warehouses in Microsoft Fabric.
Differentiate between a data warehouse and a data lakehouse.
Work with data warehouses in Fabric.
Create and manage fact tables and dimensions in a data warehouse.
Module 2: Load Data into a Microsoft Fabric Data Warehouse
Learn various strategies to load data into a data warehouse in Microsoft Fabric.
Build a data pipeline for loading the warehouse.
Load data into a warehouse using T-SQL.
Load and transform data with dataflow (Gen 2).
Module 3: Query a Data Warehouse in Microsoft Fabric
Query a data warehouse using the SQL query editor.
Explore the functionality of the visual query editor.
Connect and query a data warehouse using SQL Server Management Studio.
Module 4: Monitor a Microsoft Fabric Data Warehouse
Monitor capacity unit usage with the Microsoft Fabric Capacity Metrics app.
Track current activity in the warehouse with dynamic management views.
Analyze querying trends using query insights views.
SpireTec solutions is the latest technology enabled I.Tmanagement training company specialized in offering 1500+ courses with the state of art training facilities backed by a team of industry experts in various domains with assuring best quality services.
Since SpireTec provides 24X7 training and support for your training needs is very adaptable to your time availabilities and offers customized training programs according to your availability and time zones of your contingent.
Because SpireTec aims for the personal & professional growth of you as individual & corporate as a whole, providing training on the latest and updated versions in the designated domains.
It is preferable but not mandatory to have domain experience in the area of your interest in which you want to opt training, supported by good English communication skills, a good Wi-Fi and computer or laptop system in case you want remote training.
Spire Tec aims and ensure to offer finest and world-class training to the participants by giving them a proper counselling and a guided career path by our industry experts which leads guaranteed success for you in the corporate world.
We offer online training (1-1, Group training), Classroom training, Onsite training with state of art facilities.
We use cookies
Some cookies are essential for this site to function and cannot be turned off. Others are set to help us
understand how our service performs and is used, and to support our marketing efforts.
Learn more in our
Terms &
Privacy Policy.
Live Online Training (Duration : 8 Hours)
