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:
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)
