Uncategorized Archives

Tips for the DP-700 exam

2025-05-21 Ben Comments 0 Comment

Since I recently passed the DP-700 exam, I thought it might be helpful to share some tips to help others in preparing and hopefully succeeding in the exam and earning this nice badge! What is the DP-700 Exam Implementing Data Engineering Solutions Using Microsoft FabricThis DP-700 exam measures your ability to design and implement data engineering solutions on Microsoft Fabric. Why I’m Sharing This I felt pretty good about how this exam went. I managed to finish with plenty of…

Read More Read More

Keep history of usage metrics in Power BI

2025-04-15 Ben Comments 3 Comments

Power BI recently released a new report that allows us to monitor usage metrics in workspaces. This report is a great improvement compared to the previous version. However, it only contains usage data for the last 30 days. So, if you want to build historical usage metrics, you’ll need to create your own dataset. In this post, we’ll use a Fabric capacity to build a history of usage metrics in Power BI, but we don’t need all the workspaces we…

Read More Read More

Export Fabric notebook to PDF

2024-09-02 Ben Comments 0 Comment

As of now exporting Fabric notebook to PDF is not directly supported so here is a simple workaround to export Fabric notebook to PDF. Export Fabric notebook to PDF: Alternatively, you can export the notebook as a .ipynb file and open it using Anaconda. From Anaconda, you should be able to export the notebook as a PDF, assuming you have installed the necessary packages, such as mkteverx.

Fabric is it really new?

2023-05-30 Ben Comments 0 Comment

Following Microsoft’s recent unveiling of Fabric, a ton of videos have flooded the internet, making it hard to keep pace, and even though I was part of the private preview I wanted to take some time to digest all the information before sharing my first thought about Fabric’s new release. While there are already plenty of blogs or tutorials about Fabric I also noticed that there were some claims about Fabric just being a rebranding or just a new way…

Read More Read More

One Hot Encoding in Power BI

2023-03-15 Ben Comments 0 Comment

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…

Read More Read More

Time to be mentored

2022-12-06 Ben Comments 0 Comment

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…

Read More Read More

Chi-square test in Power BI

2022-08-23 Ben Comments 7 Comments

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…

Read More Read More

Poisson Cumulative Distribution in Power BI

Poisson Distribution in Power BI with DAX

2021-09-15 Ben Comments 6 Comments

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…

Read More Read More