DWH Datawarehouse

Owned by Testify
Last updated: Oct 31, 2023
1 min read

Table of Contents

Our data warehouse enables an independent and high-performance evaluation of the collected data from Testify. An excerpt of the productive database is made available, which provides selected tables or columns and numerous prepared tables. After agreement and number of data points, the update interval can be configured on our part.

Processed data

The prepared data can be divided into topics:

Checklist Analysis

  • Checklist Analysis

  • Checklist Checks

  • Checklist Process Activities

  • Checklist CustomField

  • Periodic Assignment Analysis

  • Scoring Analysis

Issue Analysis

  • Issue Analysis

  • Issue Process Activities

  • Issue Category Hierarchy

  • Issue Custom Field

Check Result Analysis

  • Check Result Analysis

  • Statistical Result Analysis

  • Check Collection

Equipment Analysis

  • TestEquipment Analysis

  • TestEquipment Custom Field

Process Mining

  • Process Mining Sections

  • Process Mining Check Results

Other

  • Translations: For translating user-defined wording within Testify.

 

These tables contain all the relevant information for each topic. Thus, the checklist analysis includes data points such as:

  • Test Object Type,

  • test object,

  • checklist,

  • status,

  • Created on,

  • Completed on,

  • Assigned on,

  • Number of total checks,

  • Number of negative checks,

  • ...

Retrieving the table:

Tables can be retrieved as usual:

select * from [test-tenant_dwh].Reporting_ChecklistAnalysisResult