High Level Design

Overview

Understanding the status of a project in the QA lifecycle is essential to properly managing the release of that project. Also obtaining an overview of progress occurring in the various stages of development is key determining the quality of the project under development. From these insights, a QA Manager can decide whether to release a project.

Dashboard Example (sample data)

Click on the image to open and interact with the dashboard:

Quality Assurance Project Status - Software Dashboard

Goals

Track and monitor Quality Assurance  IT Projects

Objectives

  • Be able to act on projects who are not meeting their goals

KPIs Architecture

Objectives KPIs Measures Data Source
Be able to act on projects who are not meeting their goals Percentage of Test Cases Passed

 

Formula:

Number of Test Cases Passed / Total number of Test Cases

Percentage of Test Cases Failed

 

Formula:

Number of Test Cases Passed / Total number of Test Cases

TestCasesFact,

StatusDim,

ProjectDim

Number of Test Cases in Progress

 

Formula:

Count of Test Cases in Progress

TestCasesFact.,

StatusDim,

ProjectDim

 Data Requirements

# Source Table Name Table Details (Type, #Rows, Key field/s)
1 [QA System] TestCaseFact Contains annual salary data acquired from vendors providing industry HR data.
2 [QA System] ProjectDim Contains our companies list of positions and payings across our departments, with history.
3 [QA System] StageDim Contains the list positions, departments and level within the organization.
4 [QA System] TesterDim Contains the list of testers
5 [QA System] TestTypeDim Contains list of Test Type
6 [QA System] StatusDim Contains the list of possible test case status

Data Modeling (Elasticube Design)