So a few months ago I ran into an old friend from my Software Architects days who now runs the BI practice at another local consulting firm here in Chicago. I’ve always been a bit of a nerd when it comes to data and analytics, and as he started to describe this cool new thing called PowerBI to me, I got this idea. What if we found a way to use PowerBI to slice, dice, and analyze TFS data, specifically VSO?! We needed to figure it out, then share it with the world, because how cool would that be?!
Sadly, we quickly discovered that there was no VSO connector available yet for PowerBI, but that didn’t stop us. We figured out that we could use the Office 365 Power BI tools against an on-premise TFS database and do some pretty neat analytics. To make sure it was something that anyone following along at home could recreate, we even used the data from the publicly available Brian Keller ALM demo image. We started by pulling in work item data, and created a few dashboards, the first being a basic work item overview dashboard:
Once we created a few charts, the fun began. We could select work item types, teams/areas, and watch the data change. For instance, by simply clicking on a team (Devices), all of the charts on the page would refresh with the portion of them relevant to the selected team visible.Cool right? As someone who often managed a product portfolio in TFS, the ability to see the big picture and drill in with a matter of a click or two is really valuable!
Now imagine the ability to show scatter graphs to highlight patterns in your data, geo spatial coordinate data to map out where certain events are happening, the possibilities are endless. Obviously there is a lot more to share about the capabilities of PowerBI and TFS. So fast forward to today. Tom and I just wrapped up our TFS + PowerBI webinar, and recorded it. So if you missed it, watch the full video here to find out more about PowerBI and how it can be used to drill into TFS data. You can also get a copy of our slide deck here.
And stay tuned over the next few weeks for exciting announcements on how PowerBI will be capable of connecting to VSO!