by Gil Raviv | Jun 7, 2016 | Popular
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 the previous ones I shared. Excel is probably not the best tool for big matrices, and you may still need...
by Gil Raviv | May 20, 2016 | Linkedin Insights
Update: LinkedIn restricted the use of the company search APIs. You need to be a LinkedIn partner to be able to follow this article. Your company’s page on Linkedin is a treasure trove of insightful data. In today’s post I will show you how to import this...
by Gil Raviv | Apr 20, 2016 | Uncategorized
Hi everyone, If you missed our post here, or want to refresh your skills on Excel, Power Query and analysis of Facebook Page Insights, check out our recorded webcast at PASS Excel BI Virtual Chapter, which walk you through the creation of an Excel report that measures...
by Gil Raviv | Mar 15, 2016 | Uncategorized
As promised here, today we will build a dashboard that analyzes Facebook Insights on US election candidates. As a teaser, here is a screenshot of a 3D Map you will be able to create when we are done: To start this tutorial, you should first follow Data...
by Gil Raviv | Jan 13, 2016 | Popular, Unpivot - The definitive guide
By now, if you read my previous posts in the series The Definitive Guide to Unpivot in Excel (all posts here), you will feel confident with the following challenge: How to split comma-separated values in Power Query. We have a table of event names, dates and...