Use VBA to Automate Power Query scenarios in Excel 2016
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...
Tag: Excel 2016
Improve refresh time by batching Web API calls – Part 2
Following my last post here, Imke Feldmann, author of THE BICCOUNTANT, proposed a refined version for the solution. While my original solution is simpler...
Improve refresh time by batching Web API calls – Yahoo Finance example
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...
Clinton vs Trump – Whose campaign is more negative? Opponent-Mentions and Sentiment Analysis in Excel
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...
What is Power Query?
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...
Faster Matrix Mulitplication
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...
Analyze Linkedin Company Page with Excel and Power BI
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...
Watch our webcast at PASS Excel BI Virtual Chapter
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...
Analyze US Election Candidates in Excel and #PowerQuery
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...
Split and Unpivot Comma-Separated Values
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...
