### Browsed byCategory: Uncategorized

One Hot Encoding in Power BI

## One Hot Encoding in Power BI

In a recent post where I described how to implement multiple linear regression in Power BI, I had to perform one hot encoding to make my categorical variable usable by the model. So I decided to make another short post to explain what is hot encoding and how to implement it in Power BI using Power Query. Why do need to perform Hot Encoding? In machine learning or statistical algorithms, many models require to have only numerical input variables. So…

Time to be mentored

## Time to be mentored

Recently Paul Rendal has offered one more to mentor people in 2023. Nikola Ilic also mentioned that he was Paul’s mentee in 2020. Today Nikola is by far one of the top bloggers around Power BI and if he’s there today it is of course because of his expertise, hard work, and dedication to the community and also as he’s said himself because he had mentors to help him grow and Paul Rendal was one of them! So let’s talk…

Chi-square test in Power BI

## Chi-square test in Power BI

In this post, we will see how we can implement the Chi-square test in Power BI using DAX only.There are three main types of chi-square tests but in this post, we will focus only on the chi-square test for independence. What is Chi-square? A chi-square test for independence compares two variables (which can hold multiple values) in a contingency table to see if there is a relationship between each other. In other words, it tests to see whether distributions of categorical variables differ from each other. Another…

Poisson Distribution in Power BI with DAX

## Poisson Distribution in Power BI with DAX

In statistics, a Poisson distribution is a probability distribution that is used to show how many times an event is likely to occur in a fixed interval of time or space. In other words, it is the distribution for the counts of events that occur randomly in a given interval of time. It was named after French mathematician Siméon Denis Poisson. In this post, I’m going to describe how to implement the Poisson Distribution in Power BI with DAX. The Poisson distribution can be applied…