‘DIY BI’ e-Book Launches Tomorrow!
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
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
I know that this comes with limited notice but… as many of you know I'm currently in Sydney, Australia, and I'll be in Melbourne in a couple of days for Excel Summit South. Well, as it happens, I'm actually staying
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.)
One of the cool features in Excel 2013’s Power Query is being able to load to the Data Model (PowerPivot) directly. But Excel 2010 doesn’t appear to have this feature. Interestingly, you can still load Power Query directly to Power
Date formats in Power Query are one of those little issues that drives me nuts… you have a query of different information in Power Query, at least one of the columns of which is a date. But when you complete
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.