Get & Transform Data in Excel 2016
Explore cool ways to transform you data in Excel 2016 based on Power Query technology
Sentiment Analysis in Power BI & Excel
I have recently published interesting articles on Sentiment Analysis in Power BI. Read more here:...
Date: 08/15/2016
Power Query List.Accumulate, List.Generate, Matrix Multiplication and Nested Loops
In case you missed my blog, I have three new useful articles for you: Learn how to unleash the...
Date: 06/03/2016
Facebook Insights, Excel, Power BI, Presidential Election & Ghostbusters
Hi everyone. For some reason, I can still blog here. Which is great, because you get to see this...
Date: 04/12/2016
Facebook Page Insights with Power BI Dekstop
It appears that I still have permissions to blog here :) Hello everyone. I have posted a new...
Date: 02/12/2016
Good bye TechNet, hello Data Chant
This is my last post here on TechNet, as I am leaving Microsoft this week, and move to Chicago. You...
Date: 12/27/2015
Star Wars - The Power (BI) Awakens
Are you a Power BI Jedi and Star Wars fan? I published a blogpost on datachant.com that will help...
Date: 12/17/2015
My Calendar Insights In Excel 2016
Just a short update on a new series of blogposts that I started on datachant.com. The new series...
Date: 12/09/2015
Use VBA to enable Fast Combine in Excel 2016
As some of you probably know, in Excel 2016 we have added new Object Model interfaces to light up...
Date: 11/25/2015
Split and Unpivot Comma-Separated Values
This article was moved to DataChant.com. You can read it here.
Date: 11/08/2015
Unpivot ANY nested table and load to Power BI Desktop
This post moved here.
Date: 10/18/2015
Transform ANY nested table to Pivot Table with function query
This blog post was moved here.
Date: 10/18/2015
Transform a nested table to PivotTable
This post was moved here.
Date: 09/27/2015
Back to School - Transform class schedule to PivotTable (Power Query)
This article has moved here.
Date: 09/14/2015
Transform already-pivoted tables to PivotTable (The Definitive Guide to Unpivot with Power Query in Excel)
This post was moved here.
Date: 08/27/2015
Excel for Security Analysts - Episode 2
In today's episode on Excel for Security Analysts, we will import SSH logs to Excel. To read...
Date: 08/04/2015
Excel for Security Analysts Series
Excel for Security Analysts is a series of blog posts for Security, Data and BI analysts. In this...
Date: 07/30/2015
Transform multiline records into a table
This post was moved here.
Date: 07/26/2015
Excel for Security Analysts - Episode 1
This blog post was moved here.
Date: 07/16/2015
Excel for Security Analysts
The demo I will share with you today is something that I was itching to try for a while. Before I...
Date: 07/16/2015
LinkedIn, Power Query and a follow up on PowerPivotPro post
Two months ago I published my first blog post on PowerPivotPro.com. In that post I demonstrated how...
Date: 07/08/2015
Hello World!
Hello World! My name is Gil Raviv. I am a Senior Program Manager in Excel team. In the past two...
Date: 07/02/2015