In essence, i am running a medical clinic and will need a tool to monitor the following:
1. Staff performance carrying out the medical testing. - some tests obviously fail and some pass; therefore need to monitor "staff performance" - monitor the staff numbers e,g, how many tests they perform and which tests.
2. Performance of the pathology laboratories - need to monitor the turnaround times based on the laboratory drop off times and also the time the results are produced.
3. performance of the clinic(s) - this will monitor which tests are more popular compared to other services/tests. - in addition, how does the clinic compared to the other clinics? month vs month, year vs year, test vs test etcetc
data measured will be: - client details (name, dob, address, ID #, ethnicity,) - test details (service level, type of test). - laboratory turnaround times (drop off time, result time)
ideally be based in something like Google Sheets (database) and Google Forms (for data entry) - will be using the database for analysis (data visualisation) and producing reports.