I've been doing a lot of work with PowerPivot where I connect to databases. My normal development cycle is as follows: Connect to a view or table, pulling in ALL columns Work through my data scenario until I've worked out
We use PowerPivot to display key information in dashboards, some of which can be refreshed right up to the current second. Naturally, one of the first questions asked when looking at the reports (particularly if they get printed) is “When
One of the things that used to drive me crazy about working with PivotTables in PowerPivot’s initial (2008) release was summarizing dates by month. With a standard PivotTable, we can use the built in Group functionality to group dates by
In a discussion about PowerPivot yesterday, one of my friends stated that it wasn’t really useful since you couldn’t perform write-back using PowerPivot. To him this is a very important piece in the Excel budgeting process. Now, I agree that
Last week I was working through creating some more DAX measures. And while I was successful, I still don't feel that I've really truly wrapped my head around how they work. (I notice that Dick Moffat feels similarly, too.) The
Over the last couple of days I've been trying to build some stuff with PowerPivot and I've come up with some other things that I would find pretty helpful. Here's one of them. One of the big challenges I found
After all my evangelizing (or complaining if you like), I think it's important to acknowledge when someone does/announces something that addresses my concerns. Post titles are the first things that come up in search engines. So if someone is searching
Yesterday Rob Collie made a post on his blog about sizing considerations for PowerPivot implementations on Sharepoint. The main thrust of the post was directed at end users and making sure that their server farms have adequate resources to efficiently
I am an information worker. A big part of my job is to provide our staff and team members with useful information so that they can perform better in their jobs roles. In addition to this, as the Controller of
Background I've been pretty up front with the productivity gains that I saw when I embraced VBA years ago. In fact, my About Me page on my website spells it out pretty clearly: In the fall of 2002, the resort's
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
