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 webinar on April 9th - Lifecycle Analytics with TFS 2013 and Office 365

by Angela 16. March 2015 13:34

More and more businesses that I work with rely on software for their growth and success, today more than ever before. But businesses often feel a lack of control and visibility around their software processes, and fail to achieve the agility and efficiencies needed to succeed.

Microsoft has revolutionized software Application Lifecycle Management with a robust and highly collaborative toolset focused on transparency, quality, and efficiency. Visual Studio ALM provides a powerful collaboration and automation platform in Team Foundation Server (TFS), while offering a wide variety of interfaces to TFS including Visual Studio, Microsoft Test Manager, cross-platform development tooling such as Eclipse, and Office.

Microsoft Power BI is a complete self-service business intelligence solution that can be used to visualize the patterns and trends in your TFS data.

Please join us for this free online webinar to learn how to harness the powerful integration and reporting capabilities available in this suite of Microsoft tools to not only manage your software ALM, but to improve it!

Key Experiences:

· Overview  of Visual Studio ALM

· Overview of Power BI

· Capturing the right data in TFS

· Applying analytics and business intelligence to inspect and improve your processes

When:   Thursday, April 9th from 11:00 AM – 12:30 PM

Register Now

Presenters:

clip_image002Angela Dugan is the Microsoft ALM Practice Manager for Polaris Solutions.  She has been working in the software industry for 16 years, is a certified scrum master, and a Microsoft ALM MVP.

clip_image004Tom Jaskula is the Data Analytics Practice Manager for Peters & Associates and is the president of the Chicago BI PASS chapter.   He has been architecting and implementing solutions using Microsoft SQL Server and Microsoft Business Intelligence products for 16 years.

Tags:

ALM | Application Lifecycle Management | VS 2013 | Visual Studio | Visual Studio 2013 | Team Foundation Server | TFS 2013 | SQL Server | SQL Server 2012 | Business Intelligence | Office 365 | o365 | PowerBI

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