Recursive Functions in Power Query We are all more or less familiar about recursive functions with programming languages such as Python, but what about Power Query? Can we use recursive functions with it? The answer
Creating 5-4-4 Calendar with Power Query This post is a continuation of the my previous post about how to create a 5-4-4. Please read here on how to use this function: Creating a 4-4-5 Calendar with
Creating 4-5-4 Calendar with Power Query This post is a continuation of the my previous post about how to create a 4-4-5. Please read here on how to use this function: https://xcelanz.com/creating-a-4-4-5-calendar-with-power-query/ The M code
Collaborative Filtering is a technique used in recommender systems to make predictions about the interests of a user by collecting preferences for many users. The underlying assumption of the collaborative filtering approach is that if
Neural Networks Neural Network are computer systems inspired by the human brain, which can ‘learn things’ by looking at examples. They can be used in tasks like image recognition, where we want our model to
Logistic Regression Logistic regression is a technique which can be applied to traditional statistics as well as machine learning. It is used to predict whether something is true or false and can be used to
Linear Regression in Python In this post I wanted to show how to write from scratch a linear regression class in Python and then how to use it to make predictions. Let’s start! What is
Naive Bayes Classifier The Naive Bayes classifier is a simple algorithm which allows us, by using the probabilities of each attribute within each class, to make predictions. It makes the strong assumption that the attributes
k-means clustering with Python Today we will be implementing a simple class to perform k-means clustering with Python. Before continuing it is worth stressing that the scikit-learn package already implements such algorithms, but in my
When you need to download financial data to use into Power BI, searching for the right website or API can be a daunting task. Luckily, thanks to Python and its support into Power BI, it