Recently I’ve been working with a customer on getting a simple way of displaying resource information. In truth I started with manipulating data in Excel using VBA, but quickly realised that there was a better way to do this using PowerBI.
The end result (or rather the 1st iteration) is a report which has the capability of filer by date, resource, project type, project area, and project name, and displays the work for each resource. It’s a cool report and didn’t take too long to develop (compared to VBA at least!).
If you’re using Office365, then PowerBI is free, though of course there is a paid for version which isn’t expensive and gives some additional features.
Since writing the report, Microsoft have produced a PowerBI content pack for Project Online which makes things easier, though the content pack concentrates on Projects, work, issues etc but doesn’t include resource work in a time-phased way (as this report does). My fellow MVP Paul Mather has done an excellent job of blogging the out of the box content pack experience…