Quality Assurance
Project Status

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.

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)