Training activity information
Details
Extract, prepare and process clinical data for further analysis and reporting
Type
Entrustable training activity (ETA)
Evidence requirements
Evidence the activity has been undertaken by the trainee repeatedly, consistently, and effectively over time, in a range of situations. This may include occasions where the trainee has not successfully achieved the outcome of the activity themselves. For example, because it was not appropriate to undertake the task in the circumstances or the trainees recognised their own limitations and sought help or advice to ensure the activity reached an appropriate conclusion.
Reflection at multiple timepoints on the trainee learning journey for this activity.
Considerations
- Automated Extract, Transform, Load (ETL) techniques
- Database designed for reporting purposes
- Data lifecycle, including frequency and nature of data updates
- Transforming data
- Data aggregation and reduction
- Statistical techniques
- Manual data analysis
- Governance arrangements, for example: using clinical data for secondary purposes such as management reporting, clinical audit, specialist and quality assurance
- Integration of database reporting, business intelligence or analytics tools
Relevant learning outcomes
| # | Outcome |
|---|---|
| # 9 |
Outcome
Prepare reports against information systems through the development and execution of complex and multi-staged SQL queries. |