T: 051 401 9111 info@ufs.ac.za www.ufs.ac.za

USERMIX 2013

DR JEANETTE BUYS

FocusIT Data Analyst

Tertiary Education

April 21, 2023

T: 051 401 9111 info@ufs.ac.za www.ufs.ac.za

IT DATA ANALYST

Aim: Highlight the advantage for both research and service delivery to dedicate an IT data analyst to assist with structuring and analysing data

Definition - IT data analyst•A computer software engineer•Understand relational database structures

Focus points - role players•Tertiary education•Service delivery•Research•Technology •Data

EYES ON TERTIARY EDUCATION'S

• Training

• Knowledge

• Experience

• Research

• Tools

EYES ON SERVICE DELIVERY

• Patients • Staff

– doctors – nurses– therapist

• PIS– meditech

EYES ON RESEARCH

• Thinkers • Proven ideas • Pre- and post- graduate

students• Availability to clinical

data and statistics • Electronic data

EYES ON TECHNOLOGY

• Computers

• Network

• Software

• Support

EYES ON DATA

• Patient files

• CEO

– Economics

– Data analysis

• IT data analyst

– Clinical data structuring

– Creative data extraction

– Adhoc queries

EYES ON NEEDS

Standard Meditech system dataNon-standard (customer defined) data

Departmental module (DM)•Clinical Summaries•Diagnostic findings•Therapeutic summaries•Technologist summaries•Clinic Consultations summaries

Linked with database capabilitiesLinked with ICD10 data section

EYES ON STRUCTURING

PHAmedication

Analysis

LAB / OETest

Results

MRIPatient’s age,

and home town

DMDepartmental

Results

• Gather data• Extract data• Structural system design• The bigger picture

CLINICAL EXAMPLES

EYES ON IDEAS

Post-grad

-2nd and 3rd years students-Research module includes a research project-Clinical Supervision-Starting point-Patient files

Post-grad (M.Med)

-The research component of the M.Med. programme comprises two sections- Research Methodology and - Comprehensive Mini-dissertation (Research Report):

-Detailed clinical study data-Logs

I am supervising a study group again and this time they would like to derive paediatric Asthma incidence / prevalence from script records for Asthma Medication... Would it be possible to get from Meditech prescription data for asthma meds over the last 5 years or so which would allow them to at least look at rates of prescription of Asthma meds in children? Is it possible to get Province wide data?

My students need a listing of asthma medications, salbutamol and budesinide, for patients aged 6 to 16 years seen at Dr De Waal's (Paediatric Asthma Clinic) from 2008 to 2012.

Is it possible to get regional and social economic data?

PRE-GRAD: PAEDIATRIC EXAMPLE

EYES ON ASTHMA

EYES ON PCI• EPR• Replace the patient’s paper file

POST-GRAD: UROLOGY EXAMPLE (SPECIAL STUDIES)

• Data screens are user defined

EYES ON FORMAT

• All data can be exported to Excel, etc.• Users can download data from menus• Data can be dates, lookups, numbers, y/n• First and follow-up data

EYES ON COMPLEXITY

• Cross module reports- MRI contains demographic information- DM/LAB/PHA contains clinical data

• A fragment NPR report - Link data between modules

EYES ON EXPERIENCE

• Registrars and Interns• Logs

EDUCATION: TRACK EXPERIENCE

SERVICE DELIVERY

GENERAL DEPARTMENTAL STATISTIC

SERVICE DELIVERY: NUCLEAR MEDICINE

CODING SCREENS – DM & ADM

• Important tool for hospital and departmental analysis• Use the same fields throughout all departments

ICD10 EXAMPLE

ADVANTAGES

T: 051 401 9111 info@ufs.ac.za www.ufs.ac.za

EYES ON ADDED VALUE

Service Delivery

•Epidemiology•Coding•Infection control•Stock control

Research

•E-files•Starting point•Numbers•Combined data

T: 051 401 9111 info@ufs.ac.za www.ufs.ac.za