Robust Queries: Convert column types and merge columns without referencing column names
Converting column types, and merging columns are common transformations in Power Query. It is so easy to perform these transformations through the Query...
Search Results for: power bi
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...
Transform ANY nested table to Pivot Table with function query
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...
Excel for Security Analysts – Intro
(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,...
Excel for Security Analysts – Episode 1
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...
Hello World
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...
