RADACAD Blog

Latest Power BI and AI articles from RADACAD team

Microsoft Fabric Notebook: What and Why?

One of the objects in the Microsoft Fabric is the Notebook. If you haven’t worked with Azure Notebooks before, you might ask yourself; what is Notebook? Why should I use it? These are questions that we will answer in this article. Video What is Microsoft Fabric Microsoft Fabric is an end-to-end Data Analytics platform software-as-a-service Read more about Microsoft Fabric Notebook: What and Why?[…]

Convert Matrix data in Excel to Tabular Data in Power BI.

There is a common way of seeing data in Excel as a Matrix format; many data entries look like a matrix in many contexts, from accounting to health data. However, to better analyze data and add more calculations and charts and, in general, get more insight from data, we need to change the matrix data Read more about Convert Matrix data in Excel to Tabular Data in Power BI.[…]

Calculating the trend of a Chart using DAX ( Smoothing Moving Average)

Calculating the trend of a line chart can be possible using the Analytics tab under the format section of the chart. What if we need to store this calculation and reuse it or show it as a separate chart? Actual Chart as below The trend of the chart The first question is about calculating the Read more about Calculating the trend of a Chart using DAX ( Smoothing Moving Average)[…]

Lakehouse VS. Warehouse VS. Datamart – The Difference Between The Three Fabric Objects

Three types of objects in the Microsoft Fabric have similarities in what they can do for an analytics system. These three are; Lakehouse, Data Warehouse, and Power BI Datamart. All three objects provide storage for the data, which can be loaded into them using an ETL process and read using something like a Power BI Read more about Lakehouse VS. Warehouse VS. Datamart – The Difference Between The Three Fabric Objects[…]

Microsoft Fabric Licensing: An Ultimate Guide

Microsoft Fabric is an end-to-end data analytics Saas solution product of Microsoft. It brings many workloads in the analytics area, including Data Integration, Warehousing, Engineering, Business Intelligence, Data Science, and Real-time Analytics. It is often a question of how the pricing of this platform works. This looks expensive, and how much I should pay for Read more about Microsoft Fabric Licensing: An Ultimate Guide[…]

What is Microsoft Fabric Data Warehouse?

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?[…]

What is Data Factory in Microsoft Fabric

Microsoft Fabric is an end-to-end data analytics solution in the cloud, and one of its workloads is called Data Factory. In this article, you will learn what Data Factory is, how it works with the rest of Microsoft Fabric, and what are elements and functions of Data Factory. Video Microsoft Fabric To understand Data Factory, Read more about What is Data Factory in Microsoft Fabric[…]

Getting Started with Dataflow in Microsoft Fabric Data Factory

The Dataflow in Microsoft Fabric is an element for getting the data from the source, transforming it, and loading it into a destination. In this article and video, we will go through what Dataflow is and how it works with a simple example of it. Video What is Microsoft Fabric? Microsoft Fabric is an end-to-end Read more about Getting Started with Dataflow in Microsoft Fabric Data Factory[…]

Getting Started with Data Pipelines in Fabric Data Factory

Microsoft Fabric comes with many objects that can enhance your data analytics experience. One of those objects which comes from the Azure Data Factory is Pipeline. For those using Power Query Dataflows, you may think you already have everything you wanted there, but Pipeline certainly has more to offer and complement the experience. In this Read more about Getting Started with Data Pipelines in Fabric Data Factory[…]

Microsoft Fabric Lakehouse

Microsoft Fabric is an end-to-end Data and Analytics software-as-a-service cloud offering by Microsoft. One of the important objects of Microsoft Fabric is Lakehouse. In this article and video, you will learn what Microsoft Fabric Lakehouse is and how to create it, load data into it, and read data from it. Video What is Microsoft Fabric? Read more about Microsoft Fabric Lakehouse[…]