0

A Little Story about How PowerBI Got into My TFS

by Angela 9. April 2015 14:29

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:

image

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!

image

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!

Tags:

ALM | Application Lifecycle Management | Microsoft Office | MSDN | o365 | Office 365 | PowerBI | SDLC | SQL Server | TFS | TFS 2013 | TFS Service | Visual Studio | Visual Studio 2013 | VS 2013 | VSOnline

0

Free Training When You’re Snowed In, What’s Not To Love

by Angela 2. January 2014 12:15

So it’s been snowing in Chicago, a LOT. I am in Oak Park, specifically, and holy moly did we ever get dumped on. Here, in case you think I’m being a big baby, this was my back deck at 7am this morning and it’s STILL snowing quite hard. There’s almost 10 inches of snow on those chairs right now, and there’s a pergola over them!

WP_20140102_07_54_12_Pro

Anyway, that’s not my point. My point is that I get to work from home this week, thank goodness, and ran across a great set of training classes on Microsoft Virtual Academy to fill some time. It’s free, yes FREE, and there are a LOT of technologies to choose from including ALM.  Although I’ll admit the ALM stuff is pretty light and scarce, and mostly focuses on 2012, so I’ll be nagging some folks about that soon. But there are also classes on Azure, HTML 5, even licensing!

Here is the current list of tools and technologies covered:

image

Clicking on Visual Studio I find a lot of great classes to get me up to speed on Windows development, HTML 5, you name it! What you see below is just the first few that came up, it’s a LONG list.

image

Best part is you can build up a nice little wish list since you may not have time to take everything today. So build a training plan, or several, and save the classes you like and take them at your own pace. Easy!  I already had one started from a while ago, but need to go back through and update it with some new classes, obviously :-P

image 

So dig in by starting here. And get some of those Microsoft certifications knocked out while you’re trapped in your house by snowmageddon.

Powered by BlogEngine.NET 2.7.0.0
Original Design by Laptop Geek, Adapted by onesoft