Latest Power BI and AI articles from RADACAD team
The new Azure ML environment contain a Azur Notebook that you able to write the python code there. In this post, I will go through the experiment and see how we can use this environment for the aim of regression analysis. First you need to setup the environment inside azure portal as below, click on Read more about Azure ML Notebooks[…]
In the previous article/video, I explained how to create dynamic bins by choosing the count of bins in a slicer in the Power BI report. In this article, I’ll explain, how you can do it the other way around, which is by selecting the size of the bin, you will have bins and buckets dynamically Read more about Dynamic Banding or Grouping in Power BI – Using DAX Measures – Choose the Size of Bins[…]
Thanks to AI Builder in Microsoft Power Apps and Flow, now we have access to sentiment analysis, Keyword extraction and Language detection inside Microsoft Flow is now available. In this post, I am going to show how to do sentiment analysis inside Power Automate. First What is sentiment Analysis and what sort of analysis we Read more about Sentiment Analysis Application: Microsoft Power Automate, Power Apps and AI Builder[…]
Banding (or binning or grouping) is a scenario that can be implemented both statically and dynamically in Power BI. Dynamic banding means selecting the bin (or band) configuration, and the banding changes based on the user selection of the slicer. Imagine that we have a count of customers by their age groups, but then we Read more about Dynamic Banding or Grouping in Power BI – Using DAX Measures – Choose the Count of Bins[…]
One of the most common types of banding or binning is banding based on a range. Let’s say, for example, you want to have a group of customers based on their age group. The age group banding can be created in Power Query at the data transformation stage. It can be created using the Grouping Read more about Age Banding in Power BI Using TREATAS DAX Function – Relationship Based on Between[…]
TreatAs is helpful for filtering, and it doesn’t filter only based on one column, it can filter based on as many as columns you want. One of the challenges in Power BI relationships is creating a relationship based on multiple fields, I have previously explained a method you can use to create a compound key Read more about Creating Relationship Based on Multiple Fields in Power BI Using TREATAS DAX Function[…]
TreatAs is an interesting function with multiple use cases in Power BI. I thought it is good to explain it in a set of articles, the first one here is about what the TreatAs function is and how it can help to build filters and a virtual relationship between two tables. Let’s see how you Read more about Building a Virtual Relationship in Power BI – Basics of TREATAS DAX Function[…]
The scenario I am explaining today is a very specific use case, However, I have seen examples similar to this happens very often. It happens that you get a text or Excel file with values written in a flat list structure, and that needs to be changed to a table format. Usually, this process can Read more about Convert Flat List to Table in Power BI; Pivot Without a Set Key Column Using Power Query[…]
In the previous posts ( Post 1, Post 2, and Post 3) the process of analyzing the forms using the Form processing feature in AI Builder has been explained. from last month some changes happen in the Prediction module in Microsoft Power Automate that will impact the form processing experience using flow. In this post, Read more about Recent Update in Predict Module in Power Automate Predict- Part 4[…]
Sometimes, you need to create a multiplication of all sets of all pairs from two different data tables in Power BI. This action is different from Merge (Join) because there is no matching key columns and no way to relate the two tables together. However, you want to create a multiplication as a flatten table. Read more about Cartesian Product in Power Query: Multiply All Sets of All Pairs in Power BI[…]