by Gil Raviv | Nov 23, 2016 | Uncategorized
In case you missed this important functionality in Excel 2016, today’s short blog post is written to raise some attention to a wonderful feature. You can write VBA code or PowerShell scripts to automate the creation of queries, change their M...
by Gil Raviv | Nov 16, 2016 | Uncategorized
Following my last post here, Imke Feldmann, author of THE BICCOUNTANT, proposed a refined version for the solution. While my original solution is simpler for users who are reluctant of manipulating Power Query (M) expressions, Imke’s solution is simpler for...
by Gil Raviv | Nov 15, 2016 | Popular
Follow Me In today’s blog post we will learn a neat Power Query trick that is extremely useful in improving refresh time on certain Web API calls (Like Yahoo Finance, Quandl and Twitter). Whenever you use Power Query to import data from a Web API that accepts...
by Gil Raviv | Oct 16, 2016 | Facebook Insights, Power BI, Power Query, Sentiment Analysis
Are You Ready for the Debate? Today is the US Presidential debate. It is also a perfect opportunity to hone our analytical skills and answer some of the most intriguing questions of this unprecedented race. According to CNN (here) we should...
by Gil Raviv | Jun 19, 2016
So what is Power Query? You do work with Excel, or Power BI, right? Did you know that there is an amazing new feature in Excel and Power BI that allows you to do magic in your data, avoid repetitive manual work and save you time and money? The tool is called Power...
