Data Skills Portfolio

This data skills portfolio includes data analysis and patient survey to determine which pharmacy should be closed based on ethical issues and business needs. The data analysis includes complaints received from customers and the proportion of each complaint for each pharmacy. The patient survey analyzes the average ratings given by patients for the facilities provided by each pharmacy. Based on the analyses, it is recommended to close Wickham Avenue due to the danger to patient's life.

DATA SKILLS
PORTOFOLIO

Table of Contents
INTRODUCTION...........................................................................................................................3
1. Data Analyses..............................................................................................................................3
2. Analyses based on Patient Survey...............................................................................................6
Recommendation.............................................................................................................................7
REFERENCES................................................................................................................................8
APPENDICES.................................................................................................................................9

INTRODUCTION
The field of pharmacy (filed) is connected to medicines. In which you get an opportunity to serve
people along with career. Well nowadays, students get a lot of options to make a career. But the
medical line is such that one always gets lots of job scopes. This project report consists of data
analyses and portfolio of complaints received and patient survey. It is based on recommendation
regarding which pharmacy should be closed in line with British Operations wider business needs.
1. Data Analyses
Data analysis is the process of extracting information from data. It involves several steps,
including setting up data sets, preparing data for processing, implementing models, identifying
key findings, and creating reports. The goal of data analysis is to find actionable insights that can
inform decision making. Data analysis can include data mining, descriptive and predictive
analysis, statistical analysis, business analysis, and big data analysis (Gelman and et.al., 2013).
In this case; two types of data is given; complaints received and patient survey. All the
complaints are based on ethical practice by each pharmacy. Ethics is a branch of conduct /
behavior that defines the concept of right and wrong within society. The ethics defined by
different societies are very similar. This concept is simple because every human being is
different from each other so sometimes it can also be a cause of conflict. Both ethics and
aesthetics are sub-branches of a branch of philosophers called ecology. The concept of morality
is mainly based on the culture and religion of a society (Hair and et.al., 1998).
Below is the analysis of complaints received from customers:
Problem Generating Complaints WICKHAM
AVENUE
TOPSIDE
STREET
DEERWAY
ROAD
A. The customer's prescription was not there when they
went to collect it 3 3 44
B. The customer was given the wrong prescription drugs 15 0 7
C. The customer was given too few prescription drugs 15 11 9
D. The customer feels they were advised incorrectly about
non-prescription drugs 9 16 13
E. The customer was told to take too many/too few
prescription drugs 13 21 49

F. The customer was told to take too many/too few non-
prescription drugs 16 16 33
G. The customer says the advice they were given was
dangerous 9 7 1
H. The advice given to the customer made them feel worse 1 12 7
I. A doctor had given them the wrong prescription and the
pharmacy wouldn't change it 6 3 5
J. The pharmacist thought s/he knew better about the
customer's medication 6 5 5
K. Other people in the pharmacy were sneezing and
coughing 5 0 1
L. Other people in the pharmacy were making a lot of noise 12 1 9
M. The pharmacy is a long way from public transport
options 22 3 0
132 98 183
The above table shows category wise number of complaints received from each pharmacy. The
report indicates Deerway road has received maximum number of complains compared to other
pharmacies. Topside Street has lowest number of complaints received, but these data’s are not
enough to decide which pharmacy performs well and which one bad. To get rid of this situation,
all the complaints have given weightage according to damage to customer based on problem
generated. For instance; problem generated through wrong prescription drugs have highest
weightage equivalent to 1; because it can result in loss of life of customer and on the other hand
long way location of pharmacy from public transport options doesn’t have direct impact on
patient so it has given 0.2 wightage (Daley, 1993). All the three pharmacies have different
number of complains, hence it is converted into proportion for each complain. Below is the
comparison of each pharmacies based on proportion of complain received with reference to total
number of complains:

2%
11%
11%
7%
10%
12%7%
1%
5%
5%
4%
9%
17%
WICKHAM AVENUE
A B C D E F G H I J K L M
3%11%
16%
21%16%
7%
12%
3% 5% 1% 3%
TOPSIDE STREET
A B C D E F G H I J K L M
24%
4%
5%7%27%
18%
1%
4%
3% 3%
1%
5%
DEERWAY ROAD
A B C D E F G H I J K L M
Interpretation: After comparing all three pharmacies; it was found that, maximum percentage of
complain received by Wickham Avenue is in category F category, which implies “The customer
was told to take too many/too few non-prescription drugs”. This category has wieghtage
equivalent to 0.4 out of 1. Hence, it is not under critical situation. Second pharmacy has
maximum percentage of complain in E (22%) category which is “The customer was told to take

too many/too few prescription drugs” and having weightage equivalent to 0.6 which is higher
than first pharmacy. At the end, third pharmacy also shown 27% complains in same category.
Therefore, after analyses of pie chart result of all three pharmacies it was found that, Deerway
Road is under most vulnerable condition compared to other two (Sillup and Porth, 2008).
Further analyses:
A
(0.3) B (1) C
(0.6) D
(0.4) E
(0.6) F
(0.4) G (1) H
(0.4) I
(0.7) J
(0.5) K
(0.6) L
(0.3) M
(0.2)
0.000%
5.000%
10.000%
15.000%
20.000%
25.000%
30.000%
WICKHAM AVENUE
TOPSIDE STREET
DEERWAY ROAD
Interpretation: The above chart shows weightage wise categories; for instance, category B, G
and I have higher number of chance to danger of life. Hence, above chart shows that, Deerway
Road has least chance of any problem; which can danger the life of patient. While, Wickham
Avenue shown two high chance of danger to life out of three (Category B and I). Therefore,
based on these analyses, Wickham Avenue is in most vulnerable condition, as it has highest
probability of danger to patient’s life and hence violates ethical issues (Adobor, 2012).
2. Analyses based on Patient Survey
This survey is based on average rating based on facilities provided to patient by three
Pharmacies. The result of ratings based on scale 1 to 4; has been given below:

Wickham Avenue 2.42
Topside Street 2.22
Deerway Road 2.94
The average ratings shown in the above table includes whole rating of facilities provided by the
pharmaceutical firms to patients. The result shows that Deerway Road has highest rating given
by patients. The problem with these analyses is unequal number of respondents in each case of
Pharmacy; for instance Wickham Avenue has 902, Topside Street has 1254 respondents and
Deerway Road has only 540 respondents; but still average rating has been taken as base for
comparison (Appendices).
Recommendation
Based on the analyses of Patient survey and complain; Deerway Road found standing out of
league and hence cannot be closed. Now there’s two choices; weather to close Wickham Avenue
or Topside Street. Part 2 of analyses suggest to close Topside based on rating but part 1 of
analysis suggests closing Wickham based on danger to patient’s life (Santoro and Gorrie, 2005).
So, decision based on data is not possible here, other factor required to be considered here.
Therefore, to break this tie, ethical issue has been prioritize over rating method and it is
recommended that Wickham Avenue should be closed based on danger to the life of patients
(Corrigan and Tutton, 2004).

REFERENCES
Books and Journals
Adobor, H., 2012. Ethical issues in outsourcing: the case of contract medical research and the
global pharmaceutical industry. Journal of Business Ethics, 105(2), pp.239-255.
Corrigan, O. and Tutton, R. eds., 2004. Genetic databases: Socio-ethical issues in the collection
and use of DNA. Psychology Press.
Daley, R., 1993. Atmospheric data analysis (No. 2). Cambridge university press.
Gelman, A., and et.al., 2013. Bayesian data analysis. CRC press.
Hair, J.F., and et.al., 1998. Multivariate data analysis (Vol. 5, No. 3, pp. 207-219). Upper Saddle
River, NJ: Prentice hall.
Santoro, M.A. and Gorrie, T.M., 2005. Ethics and the pharmaceutical industry. Cambridge
University Press.
Sillup, G.P. and Porth, S.J., 2008. Ethical issues in the pharmaceutical industry: an analysis of
US newspapers. International Journal of Pharmaceutical and Healthcare Marketing.

APPENDICES
Average ratings calculation:
Wickham Avenue Average
ratings
The length of time that I had to wait to be seen was reasonable 1.68
I felt confident that the pharmacist understood my medication 2.59
The pharmacist explained the treatment / health advice in a way that I could
understand 2.46
I was given enough privacy when my medication was discussed 3.16
The pharmacy was clean 3.04
All of the non-prescription products that I needed were available 2.40
I was treated with dignity at all times 2.24
Other people in the pharmacy were well behaved and friendly 2.01
I would recommend this pharmacy to a friend 2.59
There is another British Operations pharmacy that I can reach within an easy
distance if this one closed 1.89
The pharmacy is close to other shops that I also use when I go to collect my
prescription 2.60
Overall average rating: 2.42
Topside Street Average
ratings
The length of time that I had to wait to be seen was reasonable 3.29
I felt confident that the pharmacist understood my medication 1.87
The pharmacist explained the treatment / health advice in a way that I could
understand 1.97
I was given enough privacy when my medication was discussed 1.42
The pharmacy was clean 1.67
All of the non-prescription products that I needed were available 1.87
I was treated with dignity at all times 2.50
Other people in the pharmacy were well behaved and friendly 2.03
I would recommend this pharmacy to a friend 1.99
There is another British Operations pharmacy that I can reach within an easy
distance if this one closed 2.80
The pharmacy is close to other shops that I also use when I go to collect my
prescription 3.05
Overall average rating: 2.22
Deerway Road Average
ratings
The length of time that I had to wait to be seen was reasonable 3.22

I felt confident that the pharmacist understood my medication 2.98
The pharmacist explained the treatment / health advice in a way that I could
understand 2.46
I was given enough privacy when my medication was discussed 3.44
The pharmacy was clean 2.78
All of the non-prescription products that I needed were available 3.44
I was treated with dignity at all times 3.02
Other people in the pharmacy were well behaved and friendly 3.08
I would recommend this pharmacy to a friend 3.18
There is another British Operations pharmacy that I can reach within an easy
distance if this one closed 1.5
The pharmacy is close to other shops that I also use when I go to collect my
prescription 3.25
Overall average rating: 2.94