USERMIX 2013 DR JEANETTE BUYS

T: 051 401 9111 [email protected] www.ufs.ac.za

Focus IT Data Analyst Tertiary Education

May 1, 2020

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 T: 051 401 9111 [email protected] www.ufs.ac.za

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 data Non-standard (customer defined) data • • • • • Departmental module (DM) Clinical Summaries Diagnostic findings Therapeutic summaries Technologist summaries Clinic Consultations summaries Linked with database capabilities Linked with ICD10 data section

DM Departmental Results

EYES ON STRUCTURING

• Gather data • Extract data • Structural system design • The bigger picture LAB / OE Test Results MRI Patient’s age, and home town PHA medication Analysis

CLINICAL EXAMPLES

EYES ON IDEAS

Post-grad - 2 nd and 3 rd 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

PRE-GRAD: PAEDIATRIC EXAMPLE

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?

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

Service Delivery • Epidemiology • Coding • Infection control • Stock control T: 051 401 9111 [email protected] www.ufs.ac.za

EYES ON ADDED VALUE

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

T: 051 401 9111 [email protected] www.ufs.ac.za