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, right? Did you know that there is an amazing new piece of Excel that allows you to do magic in your data,...
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
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 data to Excel or Power BI...
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...
