Our UAT teams have several hundred scripts which require specific data for each scenario. the scenarios or “test personas” can be reused in future changes and development and the associated data is continuously refreshed.
The suite of scripts are in place but not automated / batch job. The business periodically ask for test data to meet their tests and I would like to give them the ability to self-serve.
To start with I would like to get them a Report where they can complete the following:
- select which test data records they need using checkboxes.
- if they need to run the full suite (obvious performance issues!) they can do so with 1 click
- there is a description on the each scenario but maybe a potential to have further filters on common searches within the data.
- the data could be exported to excel for their use.
- the ability to define how many records (SELECT TOP 100) need to be returned in the resulting data.
- the ability by myself to continuously add and edit new scenarios within the test data report.
Screen mockup included.
Are there any OOTB or Template Reports on PowerBI / Tableau examples that would meet such a requirement? Maybe a web application needs to be developed?
Any feedback appreciated.