When Ken was at the Microsoft Business Applications Summit a few weeks ago, he met Mr. J.A. Garcia who has been doing some amazing work with Power Query. We wanted to share his story about how he has been using
Miguel and I were at the Microsoft Business Applications Summit last week, and we were frequently asked for an update on the Master Your Data book (aka M is for Data Monkey version 2.0). We were told that it’s time.
It's been a long time coming, but we are putting the finishing touches on the third installment of our free 'DIY BI' series. Consequently, we are excited to announce that the Power Pivot eBook will be officially released on Tuesday,
Slobodan emailed me to describe a trick to protect Excel tables that he is using to drive data validation lists. The data validation lists are sourced from tables loaded via Power Query, and leverage a little hack to hide them
My recent post on showing the Top X with Ties inspired a discussion on ranking methods. Where I was looking to rank using what I now know as a standard competition rank, Daniil chose to use a dense ranking method
A couple of years ago, the Power Query team added Parameters as a proper object, but I kept on Creating Dynamic Parameters in Excel Power Query the same way as I always had. The reason for this is two-fold: the
In a comment on a previous post, a reader asked how you return a specific day of the next month from any given date. In other words, I've got a date of March 5 and I want to use Power
How you protect power queries is a question that will come up after you've built a solution that relies heavily on Power Query, especially if you're going to release it to other users. (This is a quick post, as I'm
Today I wanted to just make a quick announcement that we are currently working on a series of free 'DIY BI' e-Books. Free 'DIY BI' e-Books? Tell me more! Over the past few years of working with Excel an Power
This week's blog post on solving business problems with Power Query is a guest post by Alex Jankowski Does your business or work group have manual tasks that are repeated regularly, such as data re-entry, copy/paste functions, sending the same old email,
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
