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:...

Author: Gil Raviv 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...

Author: Gil Raviv 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...

Author: Gil Raviv 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...

Author: Gil Raviv 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...

Author: Gil Raviv 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...

Author: Gil Raviv 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...

Author: Gil Raviv 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...

Author: Gil Raviv Date: 11/25/2015

Split and Unpivot Comma-Separated Values

This article was moved to DataChant.com. You can read it here.

Author: Gil Raviv Date: 11/08/2015

Unpivot ANY nested table and load to Power BI Desktop

This post moved here.

Author: Gil Raviv Date: 10/18/2015

Transform ANY nested table to Pivot Table with function query

This blog post was moved here.

Author: Gil Raviv Date: 10/18/2015

Transform a nested table to PivotTable

This post was moved here.

Author: Gil Raviv Date: 09/27/2015

Back to School - Transform class schedule to PivotTable (Power Query)

This article has moved here.

Author: Gil Raviv 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.

Author: Gil Raviv 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...

Author: Gil Raviv 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...

Author: Gil Raviv Date: 07/30/2015

Transform multiline records into a table

This post was moved here.

Author: Gil Raviv Date: 07/26/2015

Excel for Security Analysts - Episode 1

This blog post was moved here.

Author: Gil Raviv 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...

Author: Gil Raviv 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...

Author: Gil Raviv 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...

Author: Gil Raviv Date: 07/02/2015