Latest Power BI and AI articles from RADACAD team
The first article in this series looked at to use the RANKX function in a calculated column to apply ranking to your data. This article will show how you can use the RANKX function in a calculated measure. The PBIX file used for this article can be downloaded here. I will use the same 10-row data-set and Read more about How to use RANKX in DAX (Part 2 of 3 – Calculated Measures)[…]
One of the features of Power BI Service is usage metrics report on a dashboard or report. The usage metrics report will give you an analysis of how many times the content is viewed or share, through which platforms, and by which users. You can also create your own monitoring report based on the model Read more about Usage Metrics or Do It Yourself Power BI Monitoring Report[…]
Very exciting feature that is added in the most recent version of Power BI Desktop March 2018 is Report Page Tooltips. This is a specific type of tooltip which can be a report itself. which this feature you can have your drill down report designed separately, and then with hovering on a chart, you can Read more about Report Page Tooltip – Revolution in Visualization of Power BI[…]
Before machine learning, we need to go through two main processes: Data preparation and Data wrangling. Data preparation is about the collecting data from resources, integrate and load data in one resource, that is so like ETL (extract, transform, and load process) [2]. According to [2], Data wrangling is when we loaded the data and Read more about Data Wrangling in Power Query[…]
How to use RANKX in DAX (Part 2 of 3 – Calculated Measures) When I first started to play with DAX, one of the functions that seemed to confuse me more than it should, was how to add ranking to my data. It didn’t seem to matter what the data was, if I followed the Read more about How to use RANKX in DAX (Part 1 of 3 – Calculated Columns)[…]
In the last Post, the explanation about machine learning and what is descriptive analysis has been provided. In this post, I am going to provide some overview of the Predictive and Prescriptive analysis Predictive Analysis Another analysis in machine learning in predictive analysis. Predictive analysis is about supervised learning. That means we want to Read more about Business Understanding for Machine Learning – Predictive and Prescriptive Analysis[…]
I normally post about machine learning topics. this post is mainly about the conference that we organized in February 2018. What is Difinity Difinity Name: Data +Infinity Difinity Location: Auckland, New Zealand When normally Happen: February Difinity Conference: Is a Microsoft Data Platform Conference in New Zealand, Auckland that has been held in 2017 Read more about Difinity Conference[…]
Business Understanding Business understanding is the main and first step for doing machine learning in any platform or languages. Not all business problem can be addressed by machine learning approaches. There are some proposed categories for machine learning such as “Supervised Learning” and “Un-Supervised Learning”. Supervised Learning is about when we identify both input and Read more about Business Understanding for Machine Learning – Descriptive Analysis[…]
Power BI leverages a very powerful method of sharing named Power BI Embedded. This method of sharing is important because of mainly two specific features of it. With this method, you can share Power BI content in your custom application, and you can share it with your custom application users, regardless if they have Power Read more about Power BI Embedded; Power BI in a Custom Application[…]
One of the great features of Power BI Desktop is the ability to import your entire Power Pivot Excel model into it. This is an awesome feature, because you can import the entire model including tables, relationships, calculations, and hierarchies into the Power BI. This is a great migration feature from Excel to Power BI. Read more about Power BI Issue Fix: Import from Excel Workbook Contents; Password Protection Failure[…]