Transform multiline records into a table
In today's post, there is a nice Power Query trick to transform multiline record data into a table in Excel. I intend to use this trick quite soon on my next...
Author: Gil Raviv
Blogger at https://datachant.com , Ex-Microsoft Senior Program Manager in Excel team, Power Query / Power BI expert, Seasoned Product and Software Engineering Manager.
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...
#PowerQuery: New Calendar Template with Categories and better Recurring calc
I have updated the Calendar Template to include Categories and better calculation of recurring meetings. Note: This is no longer the official template...
My first blog, Chicago and Bye Bye Excel IL
Earlier this year, I published my first blog post on PowerPivotPro.com here. It was a big step for me as a new blogger, and Rob and Avi were very kind to let...
Star Wars – The Power (BI) Awakens
This blog post is dedicated for Power BI and Star Wars fans. The Star Wars movie is released tomorrow. For the special occasion, I created a Power BI...
Unpivot Any table in Excel 2016
My Unpivot series just got published on Office Blogs here. Enjoy reading...
My Calendar Insights in Excel 2016
This week we have announced on Office Blogs the release of 3 new Excel templates that harness advanced data analytics technologies in Excel 2016: Power Query...
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...
