More on the Trend Calculation


One of the most useful aspects of the KPI is the ability to report a trend – that is, the value of a KPI compared to its value in the past.  This is a really useful way to determine whether you are making progress or not.


I had a chance to meet with Bogdan Crivat – a friend of mine from when we worked together on Visual C++ – and a couple of his colleagues on the SQL Server Analysis Team.  They really helped me understand a little bit more about how time dimensions worked. 


Below is a video that touches on how time dimensions are applied to our Code Coverage KPI. 



The MDX query and results from the video are shown below:


Codecoverage_kpi_trend1


MDX results:


Codecoverage_kpi_trend2


Since we don’t have any previous weeks of data for our code coverage, our KPI reports an upwards trend even with a measly 1.36% of code coverage.  As our project matures and more code coverage data is published from our tests, this trend will become more meaningful.


Another thing that came out of my conversation with Bogdan is some more insight into how to data mine VSTS data.  Look for another post on this shortly.


Thanks!


Eric.

Comments (4)

  1. Rob Caron says:

    David Lemphers blogged about a brainstorm he had recently to use Team Foundation Server to create…

  2. Optikal says:

    Have you tried using Camtasia to take the video’s?  That always produces clear videos for me.

  3. Dylan Smith on Database Unit Testing – Not quite there yet…

    David L. on Team Foundation Server…it’s…

  4. MSDNArchive says:

    I use Camtasia and the videos are crystal clear on my computer.  However, when I upload them to YouTube, they convert them to flash format.  Somewhere along that process the videos become blurry.  I’ll probably end up hosting these videos somewhere else.  Using YouTube was a fun experiment, but it doesn’t seem to work that well for these types of videos.