Joins with Power BI

In this article, I will show you how these joins can be done using Power BI’s Power Query and also in R using dplyr.

SCD Implementation with Temporal Tables in Power BI

SCD is usually an important part of any data warehouse implementation. SQL Server 2016 gave us temporal tables to leverage; have a look!

Power BI RS: Setting Data Refresh in Trigger Mode

Using the Power BI Report Server database can do a lot of things you can’t do in Power BI Services, one of them is to set a triggered data refresh on the report data set.

How to Create a Control Chart in Power BI

In this article, I will be showing you how you can build a dynamic control chart in Power BI that helps your team pinpoint any outliers or processes out of control.

Implementing K-Nearest Neighbor Classification Algorithms Using DAX

KNN Algorithms with DAX. Implementing K-Nearest Neighbor Classification Algorithms Using DAX. The horizontal axis represents the sales quantity

Three Things You Can do to Improve the Design of Any Power BI Report

For almost all of them, there are some workarounds you can do to make your development and the life of a typ - ical user easierHow usage of a style guide, icons and a landing page can advance your Power BI game

Advance DAX Tutorial: Basket Analysis 2.0

Explore the potential of products through customer purchase behaviour in Power BI