Data Skills Portfolio: Analyzing Medical Center Data and Trends

This data skills portfolio analyzes data from multiple medical centers (Kirkwood, Broadleaf, and Sycamore) based on patient complaints and survey responses. The project begins with an introduction and then analyzes key trends in the data, noting the limitations of comparing centers with unequal scales. Visualizations are provided to illustrate the number of complaints and survey results, followed by an expansion of the data to show percentages, making comparisons more straightforward. The analysis identifies specific areas of concern for each medical center, such as appointment accessibility, phone booking issues, and diagnostic service availability. Best practices for each center are highlighted, and management recommendations are provided to address identified issues. The project concludes by acknowledging the limitations of the data and the need for managers to make decisions based on the majority of the population to improve outcomes. The data analysis includes identifying the percentage of complaints, survey data interpretation, and recommendations for each medical center to improve patient care and operational efficiency. The analysis also includes a list of references used.

Data Skills Portfolio

Table of Contents
INTRODUCTION...........................................................................................................................3
Task 1: Key Trends..........................................................................................................................3
Task 2: Visuals................................................................................................................................4
Task 3: Expand Data........................................................................................................................5
Task 4: Best Practice.....................................................................................................................10
Task 5: Management......................................................................................................................10
Task 6: Data Limitations...............................................................................................................11
CONCLUSION..............................................................................................................................11
REFERENCES..............................................................................................................................12

INTRODUCTION
Data given in the context of a range of complaints including surveys have been employed
to evaluate and contrast the characteristics and limitations of every medical treatment center, and
views have been shared on the basis of areas where they function effectively and those needing
management intervention.
Task 1: Key Trends
In the data given for Complaints obtained throughout 01 July 2020 and 31 Aug. 2020;
pattern analyses are not feasible unless data is collected for monthly and therefore there's no link
among data over such a span of time. However, the trend reveals that there is a significant
difference in the figures of reports reported between three medical centers namely the Kirkwood
Medical Center, Breadleaf Medical Center as well as Sycamore Medical Center; this again raises
a concern when contrasting such medical centers due to the uneven scale of these centers. Then,
there are data surveys of 3 medical centers owned by NW-Kent Medical Practices Group. In
this, three medical centers are ranked in four separate sections; strongly disagreed, strongly
agreed, disagreed and agreed. The queries posed by clients, same as in case of the
complaints issued. Perhaps, the contrast of all three centers is not feasible due to the irregular
scale of medical center (Heeneman and de Grave, 2017).

Task 2: Visuals
1 2 3 4 5 6 7 8 9 10 11 12 13
0
50
100
150
200
250
Number of Complaints
Kirkwood Medical Centre Broadleaf Medical Centre Sycamore Medical Centre
Survey Data
1 2 3 4 5 6 7 8 9 10 11 12 13
0
5
10
15
20
25
30
Kirkwood Medical Centre
Strongly Disagree Disagree Agree Strongly Agree

1 2 3 4 5 6 7 8 9 10 11 12 13
0
50
100
150
200
250
300
350
400
Broadleaf Medical Centre
Strongly Disagree Disagree Agree Strongly Agree
1 2 3 4 5 6 7 8 9 10 11 12 13
0
20
40
60
80
100
120
Sycamore Medical Centre
Strongly Disagree Disagree Agree Strongly Agree
Task 3: Expand Data
No. of Complaints

1 2 3 4 5 6 7 8 9 10 11 12 13
0%
5%
10%
15%
20%
25%
30%
Percentage of complaints
Kirkwood Medical Centre Broadleaf Medical Centre Sycamore Medical Centre
Interpretation: The graph described demonstrates the percentages of reports generated from each
medical treatment center. The data have been extended to measure the percentages to make the
distinction of irregular scales of medical centres simpler. The finding suggests that
here, Broadleaf Medical Center has obtained maximum concerns about accessibility of
appointments, challenges in making phone bookings, and lengthy wait times for patients. In
additament to this, patients often worry about the maximum loss of privacy scale at the Broadleaf
Medical Center reception counter.
The second largest complaint is reported in Sycamore Medical Center; in fact, with "No
Diagnostics Services Available;" that's the only health centre to have a grievance. Other 2 centres
had a 0 per cent grievance (Read, 2017).
Kirkwood Medical Center gets the minimum complaints. The maximum complaints, that is 19
percent of all the complaints, was issued for deficient customer services.
Survey Data

1 2 3 4 5 6 7 8 9 10 11 12 13
0%
10%
20%
30%
40%
50%
60%
70%
Kirkwood
Strongly Disagree Disagree Agree Strongly Agree
1 2 3 4 5 6 7 8 9 10 11 12 13 14
0%
10%
20%
30%
40%
50%
60%
70%
Broadleaf
Strongly Disagree Disagree Agree Strongly Agree

1 2 3 4 5 6 7 8 9 10 11 12 13 14
0%
10%
20%
30%
40%
50%
60%
70%
Broadleaf
Strongly Disagree Disagree Agree Strongly Agree
1. Appointments at medical centre are always readily available
The Broadleaf Medical Center has highest patients, nearly 52 per cent, who firmly deny that
appointees are readily accessible at that same medical centre. And in Kirkwood, just 31 per cent
of the patient strongly disagreed, which is the lowest of the 3 health centers.
2. Booking medical appointments using the telephone are normally done with relative ease
Also, Broadleaf has quite a maximum customer of about 50 per cent who will be firmly opposed
to making appointments over the telephone at such a centre. Whereas, 36% of Kirkwood's patient
and 44% of Sycamore's patient are firmly opposed to making phone bookings simple.
3. Client can usually be treated by a care practitioner within 10 minutes of my booked
appointment period.
Patients in Broadleaf will not be treated by a care practitioner within ten min. There is less risk at
the Sycamore Medical Center that patients will not be treated by a professionals within ten min.
4. Diagnostic services (along with phlebotomy, MRI scan, Ct scan as well as ECG) are
available.
Diagnostic facilities are not provided at Sycamore Community Center; they are accessible at
other health centers.
5. Repeat prescriptions done on time

In Broadleaf; repetitive orders are not delivered on time; although in most medical facilities the
full length of prescriptions is reproduced on time.
6. Administrative personnel behaviour and behavioural skills are normally strong
Broadleaf has been the only care facility where the patients are satisfied with the professionalism
of the management personnel and strong listening skills.
7. Popular spaces, such as waiting rooms and a toilets unsanitary conditions
At Sycamore Medical Center, patients found common places unhygienic, whereas other medical
facilities provide common hygienic places.
8. Emergencies (on-the-day) services are readily accessible;
Emergency services are easily accessible in Kirkwood. Whereas in the Broadleaf, its Thirty per
cent probability that appointments were n’t accessible; and also, in Sycamore, becomes 42 per
cent probability that emergency visits are not accessible.
9. Discussing with the receptionist is accomplished in a comfortable comfortable setting.
Sycamore provides full protection when talking to the receptionist, whereas the Broadleaf
Medical Center does not have privacy.
10. Massive disabled parking space readily accessible
Kirkwood does not have enough disabled spaces for customers.
11. Decent public transport availability to medical practitioners
With decent public transit, Broadleaf promotes accessibility to medical practise; while in most
medical facilities, patients found it impossible to find transportation services to reach medical
practise.
12. Twelve. Workers are professional to have excellent customer services.
Broadleaf offers good patient care to patients, although most treatment facilities have struggled
to offer such resources to their patients.

13. Patients are sometimes misdiagnosed
Under the case of Sycamore, patient is hardly ever misdiagnosed; but at other side, Broadleaf
still has a 27 per cent risk of misdiagnosing the patient, whereas Kirkwood has a highest chance
of misdiagnosing the patients.
Task 4: Best Practice
Kirkwood Medical Centre
One such medical centre offers excellent laboratory facilities and offers the patient with repeated
medications on schedule. Emergency services are requested immediately and much
of reasonable time is still easily accessible for those other treatments.
Broadleaf Medical Centre
This has excellent personnel, diagnostic facilities and adequate handicapped spots is accessible
here as well. Besides that, there is clear connectivity to the medical facility by public transports.
Sycamore Medical Centre
This medical center is fantastic at the provision of medical practitioners; adequate handicapped
parking spaces and proper diagnosis of the patients.
Task 5: Management
Kirkwood Medical Centre
This healthcare centre needs the enhancement of its sanitation in open rooms, the provision of
adequate disabled spaces and the correct diagnosis for the patients.
Broadleaf Medical Centre
Centered on evaluates; it has been observed that this healthcare organization has a shortage of
practitioners, owing to though there are typically lengthy waits and complicated appointments to
be made easily accessible. It is suggested that this healthcare centre hire additional medical
personnel to fulfill gaps and offer timely care to patients.
Sycamore Medical Centre

It is highly advised that such medical centre should concentrate on delivering diagnostic care and
offer adequate guidance to its personnel here about whether to handle and diagnose patients
appropriately.
Task 6: Data Limitations
The statistics are constrained in regards of the scale within each medical centers and decisions
cannot be made on the basis of patient scores, as the interpretation of patients could be distinct.
However, decisions centered on the majority of the population to fulfil the highest demands
should be made by managers in order to produce better outcomes.
CONCLUSION
On the basis of aforementioned analyses, this can be inferred that data could only be
contrasted if size of population remains equal or there is just a small variation
in size/scale of population. The distinction can be made with abnormal population density by
translating data to percentages. However, the results cannot best reflect the final findings.

REFERENCES
Books and Journals:
Heeneman, S. and de Grave, W., 2017. Tensions in mentoring medical students toward self-
directed and reflective learning in a longitudinal portfolio-based mentoring system–an
activity theory analysis. Medical Teacher, 39(4), pp.368-376.
Read, T.E., 2017. Clinical skills passport: a method to increase participation in clinical skills by
medical students during a surgery clerkship. Journal of surgical education, 74(6),
pp.975-979.