What is Power Query?
So what is Power Query? You do work with Excel, or Power BI, right? Did you know that there is an amazing new feature in Excel and Power BI that allows you to...
Tag: Excel
How many Facebook friends congrat me on birthdays – Find out with Excel Power Query
I know that this is not one of the most important questions to ask, but inspired by my recent birthday, I am sharing this workbook that answer the following...
Faster Matrix Mulitplication
As a followup for our recent Matrix Multiplication post here, I would like to share with you a faster query for Matrix Multiplication (Faster only relative to...
Nested Loop with List.Generate in Power Query
Recently I shared a Matrix Multiplication Power Query technique here, and explained how to use List.Generate as the core step of the multiplication. It was...
Power Query List.Accumulate – Unleashed
Following a reader's request, today we will unleash the power of List.Accumulate. The official documentation on List.Accumulate here was very confusing for...
DataChant is 6 month old
Thank you for following my blog. I wanted to write something personal today to celebrate the blog's 6 month milestone. I started this blog 6 months ago after...
Analyze Linkedin Company Page with Excel and Power BI
Update: LinkedIn restricted the use of the company search APIs. You need to be a LinkedIn partner to be able to follow this article. Your company's page on...
Analyze Facebook Insights with Excel
Update 6/6/2016: Due to a Facebook bug here, it is not possible to read private Insights from your page, luckily the public metrics are still available. So...
How the new Facebook like buttons: love, haha, wow, sad and angry affect your Power Query reports
Few days ago Facebook introduced 5 new response buttons to enrich our engagement options. Clicking the "like" button is no longer the only option on Facebook,...
