5. Training Resources

Articles
Graphing the Lead Time and Cycle Time - Part 3

When the data for creation date, start date, and end date are good, we can aggregate the data in a graphical format. This article will demonstrate how to write a simple query to show the trends of these lagging metrics.  

Addressing incorrect data before graphing Lead Time and Cycle Time - Part 2

When aggregating lead time and cycle time graphically, it is important to ensure correct data is present in the required date fields that mark the appropriate workflow status required for computing the lead time and cycle time metrics. This article explains how to perform some diagnostics before aggregating data in the graphs using the task module.

Creating the Report for computing the Lead Time and Cycle Time - Part 1

One of the frequent questions that the Agile Project teams face is computing the cycle and Lead time.  Depending upon the team's practices, this computation may be applied for Requirements, Tasks, or Defects. This article addresses how to create a report for lead time and cycle time based on tasks.

Custom Report of Test Sets, Test Cases, and Test Steps

One of our customers recently asked about creating a report that brought the test set, test  case, and test step in a specific format to help them with their test planning.  This KB article explains how this can be done.

 

Creating a Link to the Spira Artifact Item in ESQL

One of the customers recently asked about including a link as an additional column in the tabular report so that it is easy for the receiver to directly access the link instead of navigating through the system. This article provides the query to accomplish this request as part of their query.

EVM - Leading Indicators for Forecasting

In a series of EVM articles, part 1, part 2, and part 3, we discussed about implementing the earned value management (EVM) lagging indicators. In this article, we will discuss the forecasting metrics.

Implementing EVM - Schedule and Summary of Task Based Cost Metrics in Spira - Part 3

This is the final extension to the Earned Value Management. The main difference here is that the the task module contains the details of the costs that needs to be aggregated and added to the cost of time at the blended rate. 

Implementing EVM - Schedule and Cost Metrics in Spira - Part 2

This is an extension of the earlier EVM article on implementing schedule metrics alone. In this article, let us explore adding cost metrics, such as the cost variance and the cost performance index, with summarized costs tracked at the release level.

Implementing EVM - Schedule Metrics in Spira

Recently, an attendee in a conference asked me how Spira can support the earned value management (EVM) for project tracking. The question came up as cost is not part of the standard Spira setup. This article addresses this need. 

Accommodating New Requirement Statuses

Spira currently limits the statuses available for the requirement artifact due to the support the requirement status level automation. One request, despite infrequent, is to address how to accommodate excluding requirements at a release level or reporting on requirements in this 'required but currently unavailable' requirement status. This article addresses this requirement.   

Creating a Risk Register at Portfolio Level

A customer recently asked how to get a list of all risks across all projects within a portfolio. This article explains how to create such a report.

Purpose behind a Release Clone Option

We had a customer ask recently why this clone option at the release level in Spira did not make a copy of all the artifacts associated in the previous release. This article addresses this question.

Impact of Bulk Edit Privilege in Spira

A customer recently asked about the impact of turning off the Bulk Edit privilege in Spira. This blog addresses the specific areas this Bulk Edit privilege influences.

Formatting Dates in Custom Report in ESQL

A customer recently asked how to format the date format removing the time component in the custom report. This article address how it can be done.

Creating a Velocity Comparison Chart for Agile or Scrum Product Delivery

A customer once asked how to create a velocity comparison chart for their Scrum Team to measure planned versus actual velocity across the releases. This article addresses how this chart can be created.

Creating a Custom Graph based on a set of values in a Custom List

A customer recently asked about creating a custom graph based on a set of values in a custom list on an artifact. This article explains how this can be done. 

Implementing Sorting and Filtering on Tasks using XSLT

In one of the training sessions on reporting, a request came up on how data in the XSLT can be sorted similar to ordering results using the ORDER BY clause in ESQL. Both ESQL and XSLT offer its own power which is beyond the scope of this article. But, this article explains a simple way to sort the folders and the tasks in these folders by filtering out the tasks in the root folder and filtering tasks that do not have a name filled in.

Custom Report to pull Custom Properties with Data

A customer had a list of custom properties on the requirement artifact. Some of these custom properties on some requirement had data filled in. When they pulled a report of these requirements, some of these empty custom properties took up much of the report space. So, the customer wondered about reporting only those non-empty custom properties on the artifact. This article explains how this can be achieved.

Creating a Custom Report of Electronic Signature Approval on Test Cases

A customer once asked how to create a list of all test cases that have electronic signature approval recorded.  For example, let us say that you have electronic signature turned on for a specific transition operation in the Test Case. Then, how do we create a list of all the test cases that have electronic signature recorded? 

iRP-100: Rapise Fundamentals Certification

This article enumerates the different skills you need to be self-certified at the training course: Rapise iRP-100 fundamentals. The article includes the list of skills in a readable format as well as a downloadable spreadsheet that you can fill out.

iKD-100: KronoDesk Fundamentals Certification

This article enumerates the different skills you need to be self-certified at the training course: KronoDesk iKD-100 fundamentals. The article includes the list of skills in a readable format as well as a downloadable spreadsheet that you can fill out.

iSP-100: Spira Fundamentals Certification
This article enumerates the different skills you need to be self-certified at the training course: Spira iSP-100 fundamentals. The article includes the list of skills in a readable format as well as a downloadable spreadsheet that you can fill out.
Inflectra Training Certifications
This article contains a sample spreadsheet that describes each of the course modules for being trained on our products:
  • SpiraTeam
  • Rapise
  • KronoDesk

Please download the spreadsheet and use to help self-certify your skills and competency with our products.