Visualization requirements: Interactive dashboard using Tableau for a testing report.
- or -
Post a project like this$$
- Posted:
- Proposals: 4
- Remote
- #2002267
- Expired
Description
Experience Level: Intermediate
Please find below the requirement details:
Visualization requirements: Interactive dashboard for a testing report.
Dash 1. Over all Release Status. The contents are as follows
(a) Total Number of Scripts in the release. (the count can be taken from column name 'Name', available in excel sheet 'Overall Testing Progress Report.xlsx')
(b) Count of Over all script execution status: Passed,Failed,Blocked,Not Completed,Not Started,Not Delivered,Out of Scope.
(the count can be taken from column name 'Status', available in excel sheet 'Overall Testing Progress Report.xlsx')
(c) Percentage of Over all script execution status: Passed+Failed,Passed,Failed,Blocked,Not Completed,Not Started,Not Delivered.(Formula: Status/(Total Number of Scripts in the release – Out of Scope)
(d) Percentage of Out of Scope.(Formula: Status/(Total Number of Scripts in the release).
Note: Export data view for the above to excel sheet format.
Dash 2. Cycle & Sprint wise execution status:
(a) Count of Over all script execution status (Passed,Failed,Blocked,Not Completed,Not Started,Not Delivered,Out of Scope) with respect to each Sprint and Cycle.
(the details can be taken from column names 'Cy Name,Sprint Details,Status', available in excel sheet 'Overall Testing Progress Report.xlsx')
(b) Percentage of status for (a) above.
Note: Export data view for the above to excel sheet format.
Dash 3. User Story Vs Script status:
(a) Scripts status per user story. Count can be obtained column names 'User Story JIRA, Name, Status', available in excel sheet 'Overall Testing Progress Report.xlsx')
Note: The 'Name' column has a prefix of value 'User Story JIRA'.
Note: Export data view for the above to excel sheet format.
Dash 4. Defect Status:
(a) Count & Percentage of defect status with respect to each Sprint.(the details can be taken from column name 'Key, Status, Sprint', available in excel sheet 'Defects lists with User Story JIRA.xlsx')
(b) Count & Percentage of defect priority with respect to each Sprint where status is not Closed/Done. (the details can be taken from column name 'Priority, Status, Sprint', available in excel sheet 'Defects lists with User Story JIRA.xlsx')
(c) Count of Scripts ( Failed & Blocked) linked to each defect status (with respect to Cycle & Sprint).
(the details can be obtained (may be sheet Join/Blend) from sheets 'Defects lists with User Story JIRA.xlsx' & 'Overall Testing Progress Report.xlsx')
Note: Export data view for the above to excel sheet format.
PFA the data sheets attached.
Could you please confirm if the draft version for the requirements is possible by Monday(7/5/2018) ?
Thanks
Nayant
Visualization requirements: Interactive dashboard for a testing report.
Dash 1. Over all Release Status. The contents are as follows
(a) Total Number of Scripts in the release. (the count can be taken from column name 'Name', available in excel sheet 'Overall Testing Progress Report.xlsx')
(b) Count of Over all script execution status: Passed,Failed,Blocked,Not Completed,Not Started,Not Delivered,Out of Scope.
(the count can be taken from column name 'Status', available in excel sheet 'Overall Testing Progress Report.xlsx')
(c) Percentage of Over all script execution status: Passed+Failed,Passed,Failed,Blocked,Not Completed,Not Started,Not Delivered.(Formula: Status/(Total Number of Scripts in the release – Out of Scope)
(d) Percentage of Out of Scope.(Formula: Status/(Total Number of Scripts in the release).
Note: Export data view for the above to excel sheet format.
Dash 2. Cycle & Sprint wise execution status:
(a) Count of Over all script execution status (Passed,Failed,Blocked,Not Completed,Not Started,Not Delivered,Out of Scope) with respect to each Sprint and Cycle.
(the details can be taken from column names 'Cy Name,Sprint Details,Status', available in excel sheet 'Overall Testing Progress Report.xlsx')
(b) Percentage of status for (a) above.
Note: Export data view for the above to excel sheet format.
Dash 3. User Story Vs Script status:
(a) Scripts status per user story. Count can be obtained column names 'User Story JIRA, Name, Status', available in excel sheet 'Overall Testing Progress Report.xlsx')
Note: The 'Name' column has a prefix of value 'User Story JIRA'.
Note: Export data view for the above to excel sheet format.
Dash 4. Defect Status:
(a) Count & Percentage of defect status with respect to each Sprint.(the details can be taken from column name 'Key, Status, Sprint', available in excel sheet 'Defects lists with User Story JIRA.xlsx')
(b) Count & Percentage of defect priority with respect to each Sprint where status is not Closed/Done. (the details can be taken from column name 'Priority, Status, Sprint', available in excel sheet 'Defects lists with User Story JIRA.xlsx')
(c) Count of Scripts ( Failed & Blocked) linked to each defect status (with respect to Cycle & Sprint).
(the details can be obtained (may be sheet Join/Blend) from sheets 'Defects lists with User Story JIRA.xlsx' & 'Overall Testing Progress Report.xlsx')
Note: Export data view for the above to excel sheet format.
PFA the data sheets attached.
Could you please confirm if the draft version for the requirements is possible by Monday(7/5/2018) ?
Thanks
Nayant
Ritesh M.
0% (0)Projects Completed
-
Freelancers worked with
-
Projects awarded
0%
Last project
6 May 2024
India
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies