Yes, you read that right… Power Pivot is coming to all Office SKUs and the rollout has already started for those on subscription versions of Office. This is something I've been championing (along with many others) since Power Pivot was
What is with Excel Tables and the Data Model? Believe it or not, this is not the question I started with today, it was actually "which is faster; loading from CSV files or Excel?" My initial results actually brought up
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
Last week I announced that we are working on a series of free 'DIY BI' e-Books. We've been hard at work on polishing it up, and I'm pleased to announce that the first DIY BI e-Book launches tomorrow! It will
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
One of my favourite tricks to use on a dashboard is to show the Last Refreshed Date. This is important as it lets you know how stale your data is. I think it’s even more important with Power BI, as
Today’s post isn’t of a technical nature, although it does have a pretty long technical background… I’m now at the point where I need beta testers for a new add-in I’m planning to release. What Does the Add-in Do? In
As it’s the beginning of a new year, I thought it might be interesting to show my spin on creating a custom calendar in Power Query. This topic has been covered by many others, but I’ve never put my own
This is a special post to to discuss a suggestion to improve the Pivot Table experience, especially for Power Pivot users. This week I’m at the 2015 MVP Summit in Redmond, WA. It’s a trip I’m lucky enough to make
I’m pleased to let people know that breaking Power Query via Power Pivot is a thing of the past … at least for users of Excel 2013 or higher. (Sorry, if you’re on 2010, you still need to be careful.)
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
