Latest Power BI and AI articles from RADACAD team
Power Query Editor and Data Wrangler are data transformation and preparation tools in Microsoft Fabric. There are similarities between these two tools. However, there are differences, too. It is essential to know the capabilities of each tool to understand which one should be used for what purpose and scenario. In this article, this is our Read more about Data Wrangler VS. Power Query Editor – Microsoft Fabric[…]
Copy Activity is one of the most commonly used activities in Microsoft Fabric’s Data Factory Pipeline. The Copy Activity copies the data from a source to a destination. However, there is more to that rather than just a simple copy. In this article, you will learn what Copy Activity is, its rationale, how it works, Read more about Fabric Data Factory: Copy Activity is More Than Copy[…]
Microsoft Fabric is an end-to-end Analytics Software-as-a-service offering. One of the editors and tools in Microsoft Fabric is Data Wrangler. Data Wrangler is a tool that provides the ability to work with data. In this article, I will explain the Data Wrangler, how to work with it, and how it can be used with other Read more about Fabric Data Wrangler: A Tool for Data Scientist[…]
With the Microsoft Fabric announcement, There are also additional features in Power BI that makes the connection between Power BI and other Microsoft Fabric objects seamless and more profound. One of these features is the Direct Lake connection in Power BI. In this article and video, we’ll talk about the Direct Lake, how it differs Read more about Power BI Direct Lake – What is it and Why it is Important When Working With Fabric[…]
One of the interesting features of the New Card visual is the capability to add images to the Card visual.It added more context to the car visual. In this blog post, I will show some data related to cancer in New Zealand based on gender and cancer type. Now I made two changes first if Read more about New Card Visual: Add Images to the Card Visual[…]
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?[…]
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 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)[…]
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 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[…]