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...
Following my last post here, Imke Feldmann, author of THE BICCOUNTANT, proposed a refined version for the solution. While my original solution is simpler...
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...
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...
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...
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...
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...
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...
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...