Latest Power BI and AI articles from RADACAD team
In the last post, the process of using Cognitive services Text analytics has been presented. In this post, I will show how to user pre-built AI using some predefined machine learning algorithms in Power BI Service in Data flow. I will follow the same example I show in the Azure ML Studio and Power Read more about AI in Dataflow, Power BI Service, Auto Azure ML – Part2[…]
In the previous article, I explained the importance of Conditional formatting and mentioned that having a table with no color coding is not a proper way of giving information to your users. In this article, as the second step; I’m going to show you how to use DAX combined with conditional formatting to only Read more about DAX and Conditional Formatting Better Together: Find The Biggest and Smallest Numbers in the Column[…]
Among all the functions in DAX; the behavior of ALL function still seems mysterious for many. Many people, don’t use it at all and end up writing a very complicated calculation for a scenario that only one simple expression can do the same job. Some people, use it, but don’t exactly know how the function Read more about Now You See Me! Use cases of ALL DAX Function in Power BI[…]
About the book; Quick Intro from Author Azure Machine learning has been introduced in 2014. By seeing a demo in the SQL PASS Summit, I get interested in this product. From that time, I start to work with and demonstrating in different conferences. After a while, I start to write some weblog post about it. Read more about Book: Azure Machine Learning Studio: An Unleashed Guide[…]
One of the most common transformations in Power Query is the Remove Duplicates. This transformation is used in many scenarios, one of the examples, is to create a dimension table with unique IDs in it, so can be used as the source of a one to many relationships to fact tables in the relationship diagram Read more about Remove Duplicate Doesn’t Work in Power Query for Power BI? Here is the Solution![…]
In previous posts, I have explained how to create a machine learning scenario using Azure ML components. One of the main advantages of using Azure ML is the ability to create a web service from it. That means the created model can be used in other services via an API URL and Password. In this post, I will show Read more about Azure ML Part 10, Create Web service from Models[…]
I have given many presentations and talks about Data Visualization, and still, I am amazed by how many visualizations I see which is not following the basic rules. In this article, I want to focus on table visual. A table is a visual that most of us are using it on many occasions, in fact, Read more about Show Me the Biggest Number! Conditional Formatting in Power BI[…]
In previous articles, I explained what is the Dataflow and where to use it, I also explained how to create a dataflow, and what is the common data model. In this article, I’m explaining one of the differences between Dataflow and the Power Query in Power BI Desktop, which is Linked Entities and Computed Entities. Read more about Linked Entities and Computed Entities; Dataflows in Power BI Part 4[…]
I have written some articles about advanced use cases of time intelligence but never wrote about it for beginners. as the time intelligence is an important part of many BI solutions, I decided to write about it from the beginning. In this article, first I explain what time intelligence is, and what are the requirements Read more about Basics of Time Intelligence in DAX for Power BI; Year to Date, Quarter to Date, Month to Date[…]
Workspace version 2 has been available in Power BI Service for more than 6 months now. The new version introduced in August 2018, however, still many people don’t know what it is, and what is the difference of that with the old version, and the most important question: Should you create the new workspace in Read more about Workspace V2 of Power BI: What Are Advantages Vs Old Version?[…]