Audiqueen Analytics is a powerful module to query patients and extract test results based on several criteria and to export them to Excel. Audiqueen Analytics has a powerful tool to run studies.
A typical study would look like this:
for all patients that have received a cochlear implant in the first year of life and after 2013, I want to have a preoperative unaided audiogram and postoperative aided audiograms at 1 month, 3 months and 5 years after surgery and an aided speech audiogram at 5 years after surgery.
A Study is defined by
- Patient inclusion criteria
- One event
- Several evaluation moments before and/or after the event
- Test results at the evaluation moments
This can be shown in a matrix like this:
The matrix contains the event (here: cochlear implant), one preoperative evaluation moment and 3 postoperative moments.
The study comprises 2 test results: (1) audiometry, which is assessed at every evaluation; and
(2) speech audiometyr, which is assessed only at the 5 year postoperative evaluatioin moment.
Before you start designing studies in Audiqueen Analytics,
make sure you are acquainted with the Patient Query feature!
Create a new study
Click on Analytics and then on Manage Studies to open the Study Managment window.
This window displays the studies (now empty). You can choose to display
the ongoing studies only, or also the ones that have reached their 'Finish Date'.
You can also display studies that have been archived.
Name the study
Click on New to start designing the study.
Enter a study name, start and end date and some description. The start and end date define how long the study appears as 'actif' in the study management window. They are also used for theautomatic enrollment of patients (not yet implemented).
Click on Set Criteria to set the inclusion criteria. This opens the Patient Query screen on the Patient Filter. After setting the enrollment criteria, you can close this window with the Make Patient Filter button.
Before saving this, you can also run the query (click on Search) to get an idea of how many patients will be enrolled. Here you can also exclude a patient from the study by deselecting the checkbox.
In case you want to enroll a patient who does not fully meet the criteria, you can add him/her manually by typing the unique identifier in the field 'Add patient manually'.
Design the Study Protocol
This will create the matrix as shown above. The study pivots arount the event chosen in the inclusion criteria.
Add Time Point
First add the evaluation moments, like Preop or 1 month postop. For this, click on Add Time Point and enter the valid time window. For pre-event moments, enter a negatif value (like -90 days after the event).
This exemple shows that the preop time window is set from 180 to 0 days before the event.
Now add all the outcome types (test result types) that you want to use. Clicking on the arrow of the Add Outcome button gives you a list of all available test types. Select one, e.g. Speech Audiometry.
This builds the matrix. All fields are still red.
Now double-click on a field to define the selection criteria that apply to this particular outcome. This opens the Patient Query screen on the Result Filter. Here you can define, for instance, that the preoperative audiometry should be the last unaided in the time window.
After setting the criteria, you can close this window with the Make Result Filter button.
Before saving this, you can also run the query (click on Search) to get an idea of how many results qualify. If more than one event meet the selection criteria, several result lines my appear. Here you can also exclude a result from the study by deselecting the checkbox.
Now the field turns green to show that it is ready to be part of the study design and yield results.
You can do this for all other fields...
Now the matrix shows that the study design looks for audiometric results
at all evaluation moments and for speech audiometry at the 5 year session.
Run or Save the Study
Now you can run the study and export the results to excel (like in Patient Query) or save the study, either to be accessible for you alone or for all colleagues in you centre.
The excel book displays all results, grouped per matrix field in different worksheets