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

ChicagosNext Hackathon is May 2nd and 3rd –Get Ready to Rock

by Angela 2. April 2015 10:20

image

Have you been seeing the buzz about Chicagos Next Hackathon?  It’s a fantastic way to rub elbows with some amazing local community leaders, to collaborate with some of the most talented folks in Redmond, and to team up with other passionate techies from the area to do something good. No, something great! 

You see, ChicagoNext is a Not For Profit. And they are looking for you, whether your passion is U/X, development, QA, DevOps, your help is needed! So join the fun, roll up your sleeves, and build something awesome in just a single weekend with a fantastic group of technologists. This is also the weekend before the Microsoft Ignite conference (May 2nd/3rd), so you may already be in town if you’re not a local!

 

More details from the site:

Get your skills, apps and ideas in front of serial entrepreneurs with ChicagosNext while helping our community.

ChicagosNext is a Non Profit technology hackathon event that brings together a diverse group of local, regional, national and international (yes, international) tech talent with an entrepreneurial spirit. The goal is to build the next app that creatively solves issues within our local neighborhood using Azure and supporting Microsoft Technologies. Local Chicago Community Leaders (several other NFP, education and community organizations) will be sharing their issues and struggles that you can solve with technology.

At the end of it all, one team will be chosen to have their idea presented at the Finalist Pitch.

Interested in learning more? Check out our podcasts! Check out our Schedule! 

You can also follow @ChiNextHack on Twitter for more news!

Tags:

ASP.NET | Azure | Cloud Computing | DevOps | Microsoft

0

It’s THAT Time Again! ThatConference Call for Speakers is Open for Just 2 Weeks

by Angela 31. March 2015 08:30

I can’t believe it is going to be our 4th year. Seriously. Craziness.

I still remember that fateful day almost 6 years ago. I was driving out to Detroit for a conference and I get a call from my buddy Clark. He’s telling me about this crazy idea to create a conference for everyone. It would have family stuff, include all kinds of technology, and it would be in a freaking water park in Wisconsin! What was not to love? And most importantly, did I want to help?? I had over a year at that point before the the kickoff of the inaugural ThatConference. It seemed like a lifetime away, and yet here we are. Every year I flop down on my bed after the last session and think GOD THAT WAS A LOT OF WORK, and then volunteer for next year because I can’t imagine NOT being involved in something this great. On to my point before I start getting all misty eyed. WHAT?

Call for speakers has just opened for ThatConference 2015. We’re going to be bigger, awesomer, geekier, and yes awesomer is a word because I said so! Smile We need great speakers. We need you. We need your KIDS to submit. I know, who knew? Last year we had an astounding number of geeklets presenting, leading open spaces, and coming up with some amazing ideas for this coming year. I am personally so stoked to see what the kids have ins store for US this year. No technology is off the table. No talk related to anything that anyone in the tech community would be interested in is off the table. Personally I plan to submit talks around not just TFS, and agile, but around fear and how many of us battle imposter syndrome. So be creative.

Next, please, check out our conference site, check out speakers and sessions from previous years, and then submit something that moves you. Here is a preview of our speaker submission “rules of the road”:

 

Tips for making your abstract epic:

  • Counselors have roughly 60 minutes to teach their fellow campers.
  • Descriptive and edgy titles are best. Bonus points for Summer Camp Geek references.
  • Make sure your abstract description contains enough detail so we know what you're going to talk about. Don’t worry if you make any mistakes we will have the opportunity to fix it later.
  • Try not to pull any switch-a-roos last minute and talk about something completely unrelated. Campers don't like that. If something changes, please work with That Conference.
  • We can't make too many promises but if there are issues with the final speaker schedule we will do our very best to accommodate you.

Do:

  • Be passionate about your chosen topic.
  • Feel free to submit more than one abstract. We have to maintain a balance across all of the tracks and their topics. It will just help us and potentially you.
  • Consider how your presentation is relevant to all technologists, but don’t feel constrained to avoiding a talk on one specific programming language, platform or technology.
  • Consider what discussions could be sparked by your presentation. That Conference is all about meeting people and discussing ideas; consider what people will talk about after your presentation.
  • Explain what benefit your presentation will bring to the audience.
  • Tell a story.
  • Show real world examples, especially your own experiences, to support your ideas. Show code samples or demonstrate product capabilities only where appropriate.
  • Make sure you can keep the documented session time limit.
  • Stay near the stage or podium after your presentation, encourage the audience to come up and discuss the presentation with you.
  • Please invite the audience to discuss your talk with you face to face rather than just at the end. Better yet, continue the conversation in our Open Spaces.
  • Respect our anti-harassment policy.

Don’t:

  • Use your presentation to specifically promote the superiority of one platform, language or technology over all others. Instead talk about pros and cons of the demonstrated subject, and invite the audience to share their own experiences related to your discussion.
  • See your presentation as a platform to market your company or product.
  • Include unnecessary animation or sound effects in your presentation that will distract from your content.

 

So seriously, don’t wait! Submit your talk, or talks, TODAY and don’t miss the opportunity to be a part of something truly awesome: https://www.thatconference.com/

Tags:

Agile | ALM | Application Lifecycle Management | personal growth | technology | development | Windows Phone | Visual Studio | ThatConference | Team Foundation Server | Scrum | SQL Server | Mobile development | Cloud Computing

0

ALM User Groups Welcome Gary Pedretti Back as a Presenter Next Month

by Angela 26. March 2015 13:23

On April 8th, we’ll be welcoming Gary Pedretti back to the ALM user group! Trust me on this, Gary’s presentations are NEVER to be missed. I hope you can make this one. RSVP Now to Attend

 

Session details:

King Tut Architecture: Pyramids, Patterns, and Tests

Mike Cohn introduced the Testing Pyramid in his 2009 book, Succeeding with Agile, as a model for thinking about tests and test automation - focus, ROI, TCO, etc. - when developing a software product.  It’s been a powerful visual for guiding teams to craft test suites that are sustainable and effective, regardless of whether they automate or not.

But what if we thought about it as application design or architectural guidance? Building a product that is well covered by tests, in the ratios described in the Testing Pyramid, requires specific designs and architecture.

In this talk we'll cover modern techniques and patterns that allow for architecture and development to be guided by the Testing Pyramid. We’ll also address the “Am I only doing this for testability, not for value delivered?” question.  The audience will leave with new ways to think about the Testing Pyramid, new patterns for developing a well-tested application, and new ways for architects, testers, and coders to work in a cross-functional manner.

Speaker Bio

With over sixteen years of experience, Gary works closely with companies nationwide to help them achieve their goals in delivering business value through software. He is an agile software development trainer, coach, and practitioner, as well as a curriculum developer, application architect, and software craftsman.

Gary is a strong believer in the “see one, do one, teach one” road to craft and mastery, which led him to become a Professional Scrum Trainer for Scrum.org. Over the past five years he has trained thousands of students on Scrum - coders, testers, UX specialists, BAs, DBAs, PMs, managers, and C-suite executives - using experiential, immersive courses.

Gary's technical skills and experience include enterprise and application architecture, ALM, build and deployment automation, web development, database modeling and development, and test automation.

You can find Gary at www.GaryPedretti.com and on Twitter @GaryPedretti

 

Location:Microsoft-Chicago 200 E Randolph, 2nd Floor, Chicago

Agenda:6:30pm Dinner, 7:00pm Presentation

You are not currently registered to attend. RSVP Now to Attend

Tags:

ALM | Agile | Application Lifecycle Management | Automated Testing | Scrum | Architecture

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

0

Setting Default Values on a Readonly work item field in TFS 2013

by Angela 4. March 2015 14:07

It’s actually a bit more complicated than that… What I was trying to do was set the Assigned To field on a NEW work item to a particular person, and then lock it in.  So new work items of a specific type can only ever be assigned to a particular person… The Assigned to dropdown would only ever get the full list of team members after it was transitioned away from the New state.

I tried a lot of things that felt like they SHOULD have worked. It appeared that I could do either set a field default, or make it read-only, but not both.  Here are the things I tried:

  1. I tried setting the field itself to both have a default value and be read-only at the field definition level, but it appears as a read-only blank field.
  2. I tried setting the field to have the default value, then added a WHEN clause to the field to set it to read-only when System.State = new. It appears as a read-only blank field.
  3. I tried setting the field to be read-only, then added a WHEN clause to set the field Default value during the transition into the new state (see below). It appears as a read-only blank field.
  4. I tried setting the field to have the default value, then set the field to read-only during the transition into the new state (see below). It appears as a read-only blank field.
  5. I tried setting the Assigned to field to be both set with a default value, and set to read-only in the New transition. Nothing was set at the field level. It appears as a read-only blank field.

Is read-only always processed before default value rules are set regardless of how you do it? I wasn’t sure, and I did run across the order of operations docs and it does not address read-only. :: SIGH::

If I remove the Read-only rule from every approach, the field defaults properly, making me think what I want to do is just not supported.  After scouring a lot of MSDN documentation, I have no reason to think otherwise but when I find out for sure I’ll let you know. Anyone see something else I am doing wrong? Or know for sure if it is supported or not? If so, please let me know! It’s kind of driving me crazy.  In the meantime, I did think of a workaround.   Instead of making the field read-only, I reduced the valid choices in the drop down while the item is in the new state to the one person it can be.  Not exactly read-only, but they can't change it to another value so it is effectively read-only...

<FieldDefinition name="Assigned To" refname="System.AssignedTo" type="String" syncnamechanges="true" reportable="dimension">
  <ALLOWEXISTINGVALUE />
  <ALLOWEDVALUES expanditems="true">
    <LISTITEM value="[project]\Analysts" />
  </ALLOWEDVALUES>
  <DEFAULT from="value" value="Joy" />
  <VALIDUSER />
  <WHEN field="System.State" value="New">
    <ALLOWEDVALUES expanditems="true">
      <LISTITEM value="Joy" />
    </ALLOWEDVALUES>
  </WHEN>
</FieldDefinition>

0

Chicago Code Camp returns to IIT in Chicago in 2015

by Angela 3. March 2015 17:42

So did you hear that Chicago Code Camp is returning to IIT in Chicago?! Very exciting news. And a much shorter commute for me Smile 

What is Chicago Code Camp? Really?! I hope that isn’t a serious question. It’s a fantastic 1-day event! Here is the blurb from the website, because I don’t know that I can sum it up much better than this:

Chicago Code Camp is a community event where developers learn from fellow developers. The one day polyglot code camp's goals are for developer to share ideas, learn from one another, and then develop upon topics of interests that were discovered during events. Our topics from previous years included development (and/or trending practices) in .net, java, open sourced frameworks, web, mobile, cloud, robotics, testing, soft skills, agile and scrum practices, and more.

Sessions range from informal talks and panel discussions to formal presentations. There will be a mix of presenters – some experienced speakers with years in the industry, some that may be speaking in public for the first time, as well as students and first time developers. We are expecting to see people from throughout Midwest region and beyond.

2015 will be our 7th year of Chicago Code Camp and we are happy to return to the City of Chicago and to the Illinois Institute of Technology.

Call for speakers is OPEN so be sure to submit your best ideas! And keep in mind that we do get a lot of submissions, and voting is blind, so bonus points for very detailed submissions and creative content.

 

Lastly, and most importantly because this is a community supported event, there are also sponsorship opportunities. If you are looking to support the community, maybe even use the opportunity to do some networking, advertising, and recruiting of some great local talent, this is a great one to consider! Sponsorship opportunities start at just $500. Find out more on the Sponsors page.

 

 

***********UPDATE**********

Registration is now open, and the event is, as it always has been, completely FREE!

Tags:

.NET | Agile | ALM | Application Lifecycle Management | Azure | C# | Chicago Code Camp | Cloud Computing | DevOps | Mobile | Mobile development | Release Management | SDLC | Team Foundation Server | Testing | TFS 2013 | Visual Studio | VS 2013

0

Polaris Solutions Holding an ALM Lunch and Learn on Agile Testing Success in St Louis Next Month

by Angela 24. February 2015 14:39

    Our St Louis office is holding a Lunch n Learn at the local Microsoft office in March. Agile testing is a challenge for most software teams, especially larger organizations with well-established QA groups and processes. Learn from one of our resident agile testing experts at the free event!

    More details:

    Description: If you are either planning to or are already practicing agile software development, Team Foundation Server (TFS) and Microsoft Test Manager (MTM) offer you a powerful platform to successfully plan, manage and execute agile testing.

    During this free lunch session we will cover in detail the different testing capabilities offered by TFS 2013 and MTM for Scrum and Agile methodologies, and will also share what we have learned from helping our clients as they implemented and matured their agile testing practices.

    Key Experiences:

    • The evolved role of testing in Agile Projects

    • Iteration test planning techniques

    • Test tracking with TFS and MTM

    • Different approaches to bug management

    • Test automation Do’s and Don’ts

    • Testing metrics that are worth measuring

    • Exploratory testing strategies

    • Best practices & lessons learned in the field

      Complimentary lunch will be provided to registered attendees.

      Presenter: Alejandro Ramirez is a Software Quality professional and Senior Consultant with Polaris Solutions. He has over 17 years of experience working in software in development, testing, and IT governance. His experiences range from small businesses, startups and non-profits, to Fortune 500 corporations in a variety of fields. He is certified in ITIL and Lean. He is also a blogger, speaker, mobility champion, and helps companies incorporate ALM strategies to continuously deliver valuable software.

      When: Tuesday, March 24, 2015 from 11:30 AM to 12:30 PM (CDT)

      Where: Microsoft Corporation, 3 Cityplace Drive Suite 1100 Creve Coeur, MO 63141

       

      Register for this Polaris Solutions event today!

      0

      A Hidden Gem in the MTM Test Plan Selection Dialog–Sorting and Filtering

      by Angela 19. February 2015 10:13

      By which I mean “hidden”.

      Every once in a while I run across a little nugget of goodness in a product I have been using for ages and just never noticed. They are not always ground breaking discoveries, but saving even a few seconds or a few clicks on something I do quite often adds up right?  So here is today’s face palm moment. Apparently you can filter and sort the MTM Test Plan selection dialog. The what now you ask?

      THIS GUY.

      image

      Now in my sample project there are not a ton of Test Plans, but for more mature client projects I end up with dozens and dozens of plans. I’ve seen projects with almost 100 Test Plans, which can happen quite quickly when you have really large organizations with many teams in a single Team project, using a Declarative Model for test release planning. But there is a better way! 3 features that will make your life easier:

      1) Adding more columns to the visible fields. Right-click in the header and you’ll notice you can check and uncheck fields to change the items you are can use to filter and sort. Once the field appears you can also drag it left and right to rearrange the fields. Many other lists in MTM work this way, not sure why it never occurred to me to try this.

      image

       

      2) You can click a column header, as expected, to sort by any of the visible fields. I assume no additional explanation or screen shots are required for this one…

      3) If you hover near the end of a column, the filter option will appear, showing you the available filter options.  Now you can filter by some of the most common things you might want to like state, Area Path (Team), etc.

      image

      Cool right? Seriously, how did I not notice these things were possible, ever?! ::face palm::

       

      Hope this was a helpful tip! And if it is not because you already knew, then why the heck didn’t you tell me? Winking smile

      1

      DevOps with Chef and Azure Coming to the Chicago ALM User Group this Month

      by Angela 4. February 2015 17:12

      When: Wednesday, February 18, 2015 from 6:30 PM to 9:00 PM
      Where:Microsoft-Chicago 200 E Randolph, 2nd Floor, Chicago

      What: Wouldn’t it be great to remove the “it works on my machine” scenario? Don’t you have better things to do with your time then manually configure systems? In this live, hands-on demonstration Matt will introduce you to the concepts of Infrastructure as Code and Automation; show you how we to use Chef  to develop and test system configuration locally, and then deploy them to a production environment in Microsoft Azure. Learn more about Chef on their blog, website, and Twitter!

      Who: Matt Stratton is a solutions architect at Chef, where he demonstrates how Chef’s automation platform provides speed and flexibility to clients’ infrastructure. He is devoted to concepts like Continuous Delivery and Infrastructure as Code, and his license plate actually says “DevOps”. He is also a host of the Arrested DevOps (arresteddevops.com) podcast. It’s a great podcast, and I am not just saying that because I have been on it :)

      Matt has over 15 years experience in IT operations, ranging from large financial institutions such as JPMorganChase and dot coms, including Apartments.com. He has given presentations at Microsoft-sponsored events, CAMP IT, and various local groups within the Chicagoland area.He lives in Chicago and has an unhealthy obsession with Doctor Who, Firefly, and Game of Thrones.

      Agenda:6:30pm dinner 7:00pm Presentation

      RSVP Now to Attend

      Feel free to invite coworkers or friends who would be interested in this talk, just make sure they pre-register! Security requires it, and then I can order the right amount of food. You can park in the Aon center for a discounted rate after 6pm, but your best bet may be SpotHero if you choose to drive. I’ve seen $10 parking a block away using their service.

      Tags:

      ALM | Application Lifecycle Management | Azure | Cloud Computing | DevOps | development | Deployment | Deployment Planning | Continuous deployment | Chef | Continuous Delivery

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