Subject Code : NIT3171
Assignment Task:

You are hired as a Business analyst for a company who manages multiple clinics around Australia. Your mission is helping these medical organization’s business growth. Your manager has provided you with one of these clinic’s data, so you can prepare a full report of descriptive, predictive and prescriptive details. The report should show the current business finding, strength, weakness, and the possible development approaches. 

The report should include, but not limited, the following details:

  • Descriptive

  1. The statistical details of data, such as patients’ cities, ethnic background, gender and age.

  2. The statistical details of data, such as the highest 10 descriptions, drugs, and reasons.

  3. Divide the medicine into three types {antibiotic, chronic, pain relief}, for instance: Keflex is anti-biotic, Diaformin is chronic, and Buscopan is for pain relief. Find the estimated percentage of each type.

  4. Draw a graph showing the highest cities that patients come from. Group this as per year (2015 -2019)

  5. Find the percentage of patients who use private health insurances

  6. Find the average of all diabetic patients (type 1 & 2). Draw the binomial distribution showing the number of diabetics in every city.

  7. What are the cities (suburbs) that host less than 20% of diabetics? 

  • Predictive

  1. Predict the annual income for 2020

  2. Cold and Flu relate to Winter. Abstract the data related to these two diseases, ignore the year and focus on the month instead. Provide a non-linear formula that helps developers predict the future number of cold and Flu cases in each month.

  3. study at least three associations to find if there are any associations between diseases such as obesity and heart diseases, between diabetes and hypertension, and so on.

  • Prescriptive

  1. Write at least one page suggesting some management and procedures to improve the annual revenue. This can be gained by hiring specialists, nurses, dietitians, psychologist ..etc. This depends on the patient’s cases that you found in the data. Also, provide a suggestion for hiring staff, for instance, the staff ethnic background, language and gender. This is also possible by increasing the employee’s hours, from part-time to full-time. Study the possibilities of establishing a small pharmacy inside the clinic or opening another clinic branch in another area.     

  2. Divide patients into three different categories {regular, irregular, rare}. Suggest a minimum number of visits per month for each category. Find the possible attributes that may increase the patient’s regularity, such as ethnicity, age, gender and city. 

  3. If the average visit for {Regular} visitors was ψ / year, what is the probability of having (ψ – 10)/year visits.

 

This NIT3171 - Business Analytics has been solved by our Business Analytics Experts at UniLearnO. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.

 

  • Uploaded By : Mia
  • Posted on : February 03rd, 2019
  • Downloads : 327

Whatsapp Tap to ChatGet instant assistance