There are a lot of similar terminologies and words when working with Fabric. We have Data Lake, Delta Lake, OneLake, and Lakehouse, and the list continues. I found it confusing for some to understand the differences between them. Although explaining these terms and their differences requires many different blog articles, having one place for a Read more about Microsoft Fabric Glossary[…]
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[…]
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[…]
Microsoft Copilot is utilized in different technologies in Microsoft; in Microsoft Fabric, one of the places that you can use Copilot is in the Data Warehousing workload, which will guide you through your SQL commands and enhance your SQL coding experience. I’ll show you how the Copilot in the Data Warehouse works in this article Read more about Copilot in Fabric Data Warehouse: Magic in T-SQL[…]
Microsoft Fabric runs some workloads under the Spark engine, but what is it really? In this article, I’ll take you through the question of what Spark is, What benefits it has, how it is associated with Fabric, what configurations you have, and other things you need to know about it. Video What is Spark? Apache Read more about What is Spark in Microsoft Fabric?[…]
The Lakehouse or Warehouse comes with a default Power BI Sematic model, which can be used for reporting and analytics. However, you can also build and use a customized semantic model. There are significant differences when using the semantic model in real-world analytics projects. In this article, I’ll explain the difference between these two, which Read more about Power BI Default Semantic Model or Custom; A Guide for Using in Fabric Environment[…]
Time travel is now available in Fabric Warehouse, which was previously only possible in Lakehouse. This means that you can all be Dr. Strange and use your time stone to travel through time and look at a snapshot of the data at that point in time. It is an amazing feature, and it is so Read more about Time Travel in Fabric Warehouse: Query Snapshots of the Data at Any Point in Time[…]
The structure of storing data in OneLake for the Lakehouse tables is interesting. The commonly used structure is called the Delta Lake Table structure. In this article and video, you will learn what this structure is, how it works, and what the difference is with Parquet, and you will see some related demos. Video What Read more about Delta Lake Table Structure Demystified in Microsoft Fabric[…]
Microsoft Fabric offers an end-to-end SaaS analytics solution; however, the world is using all kinds of data sources in its implementation. Mirroring is a new functionality in Fabric that allows customers to keep their data wherever they are, but then they can use Fabric analytics solutions with the same speed and performance as if their Read more about Mirroring Snowflake in Fabric: Supercharged Analytics at No Extra Costs[…]
There has been a lot of hype recently about Generative AI and Copilot in Microsoft. Microsoft Fabric incorporates many of those features, and one of the areas it has been added to is the Dataflow Gen2 in Microsoft Fabric, or we can also call it Power Query in Power BI Service Dataflows. In this article Read more about Copilot in Power Query in Power BI Service and Microsoft Fabric Dataflow Gen2[…]