XcelanZ

  • Python
  • Power BI
    • Power Query
    • DAX
  • Excel
    • Excel Charts
    • Excel VBA
    • Excel Formulas
  • About
  • Contact
  • Python
  • Power BI
    • Power Query
    • DAX
  • Excel
    • Excel Charts
    • Excel VBA
    • Excel Formulas
  • About
  • Contact
XcelanZ

Home

Recursive Functions in Power Query

Recursive Functions in Power Query

  • Livio
  • 06, 2020
  • Power BI, Power Query
  • 1 comments

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

Read More

Creating a 5-4-4 Calendar with Power Query

Creating a 5-4-4 Calendar with Power Query

  • Livio
  • 02, 2020
  • Power BI, Power Query
  • 0 comments

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

Read More

Creating 4-5-4 Calendar with Power Query

Creating 4-5-4 Calendar with Power Query

  • Livio
  • 01, 2020
  • Power BI, Power Query
  • 4 comments

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

Read More

Collaborative Filtering from Scratch with Python

Collaborative Filtering from Scratch with Python

  • Livio
  • 11, 2019
  • Python
  • 0 comments

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

Read More

Writing a Neural Network class in Python from scratch

Writing a Neural Network class in Python from scratch

  • Livio
  • 08, 2019
  • Python
  • 0 comments

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

Read More

Building a Logistic Regression in Python

Building a Logistic Regression in Python

  • Livio
  • 07, 2019
  • Python
  • 0 comments

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

Read More

Linear Regression in Python (from scratch)

Linear Regression in Python (from scratch)

  • Livio
  • 05, 2019
  • Python
  • 0 comments

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

Read More

Implementing a simple Naive Bayes Classifier with Python

Implementing a simple Naive Bayes Classifier with Python

  • Livio
  • 05, 2019
  • Python
  • 0 comments

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

Read More

k-means clustering with Python

k-means clustering with Python

  • Livio
  • 05, 2019
  • Python
  • 0 comments

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

Read More

Download Stock Data into Power BI using Python

Download Stock Data into Power BI using Python

  • Livio
  • 03, 2019
  • Python
  • 1 comments

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

Read More

Post navigation

← Older posts

connect with me

Search this site

Search for:

Tags

4-4-5 Calendar 4-5-4 Calendar 544 Calendar algorithms bar chart chart charts clustering collaborative filtering combinations Combiner Functions convert to roman Correlation Data Modelling data science DAX Dot Plot excel excel charts Finance Fixed Length CSV Histogram kmeans Linear Regression List.Zip M machine learning naive bayes neural networks panel chart Pareto Analysis Power BI power query Power Query Sumproduct Python Recursive Function roman Slow Changing DImensions spam filter SQL Statistics sumproduct trigonometry vba visuals
  • Legal

connect with me

XcelanZ © 2018