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 in determining the quality of the project under development. From these insights, a QA Manager can decide whether to release a project or keep it on hold. This is where a QA dashboard come in handy.

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)

QA dashboard