Converting column types, and merging columns are common transformations in Power Query. It is so easy to perform these transformations through the Query...
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...
Get ready to be amazed :) This is the fourth post in the series The Definitive Guide to Unpivot with Power Query in Excel. In this series we walk you...
(Originally published here) The demo I will share with you today is something that I was itching to try for a while. Before I joined Microsoft and Excel team,...
In this walkthrough we will show step-by-step how to turn web traffic logs (W3C Extended Log File Format) into a powerful security analytics workbook. To watch...
This is my first blogpost on DataChant. My still-secret place to chant about data analytics. My name is Gil Raviv. I am a senior program manager in Microsoft...