Category: Data Warehouse

Microsoft Fabric Mirroring – Copy Job – SAP Integration – Interview with Wilson Lee from Microsoft

Posted on by Reza Rad

Microsoft Fabric has been moving fast — and nowhere faster than in data integration. Between Microsoft Fabric Mirroring, Copy Job, Open Mirroring, and SAP integration, there is a lot to unpack. I recently sat down with Wilson Lee, Principal Product Manager at Microsoft, who leads the entire data movement area — including Mirroring, Copy Job, Read more about Microsoft Fabric Mirroring – Copy Job – SAP Integration – Interview with Wilson Lee from Microsoft[…]

SCD Type 2 in Microsoft Fabric and Power BI

Posted on by Reza Rad

In the previous article, I explained SCD (Slowly Changing Dimension) and its different types. In this article, I’ll show you how to implement SCD Type 2 (one of the most common types) using Microsoft Fabric and Power BI. This article includes using Lakehouse, Dataflow, Warehouse, Data Pipeline, SQL Stored Procedures, Power BI Semantic model, and Read more about SCD Type 2 in Microsoft Fabric and Power BI[…]

SCD: Slowly Changing Dimension, an Ultimate Guide

Posted on by Reza Rad

If you want to use Power BI, Microsoft Fabric, or any other data analytics tools, one of the key concepts to understand when working with a data warehouse system is the SCD (Slowly Changing Dimension). I will do this in a series of at least two articles. The first one (this one) will be on Read more about SCD: Slowly Changing Dimension, an Ultimate Guide[…]

What is Microsoft Fabric Data Warehouse?

Posted on by Reza Rad

Microsoft Fabric, an end-to-end Saas cloud-based analytics platform, has many workloads and objects. One of the Objects is called Data Warehouse, or in short, Warehouse. In this article, I’ll explain what the Data Warehouse in Microsoft Fabric is and how it works, and I will show you an example of it in action. Video Microsoft Read more about What is Microsoft Fabric Data Warehouse?[…]