Cyan Dashboard

An awesome Dashboard
Explore the codes »

View Demo · Report Bug · Request Feature

Table of Contents

1. Cyan Dashboard
   • Features
   • Data Used
2. Getting Started
   • Running the Dashboard
   • Testing the Dashboard
3. Scrum Team Details
License

Cyan is a dashboard that shows insights regarding drug prescription. It serves to help members of the clinical commissioning group:

• Assess local needs
• Rank priorities and develop strategies to meet the public's medical needs
• Distribute the NHS budget given to their CCG a) Buying services on behalf of the population from providers including hospitals, clinics, community health bodies, etc
• Ensuring the services and pathways in which medicines are utilized are set to standards that provide cost-effective use of resources, reduced risks associated with medicines use, and improved patient outcomes

Features

All the features displayed on the dashboard:

• Average actual cost
• Description of the max quantity item
• Percentage of the top prescribed drug among all the prescriptions
• Number of unique items in the data
• A bar chart depicting the total prescribed items per primary care trust(PCT)
• A table with a dropdown filtering the BNF data per PCT.
• A creatinine clearance calculator acting as a clinical support tool for physicians
• Details about the purpose of the dashboard
• Percentage of infection treatment drug out of all infection treatments
• A search box that filters the drug by name or BNF code and displays it in the form of a table.
• A bar chart visualizing the total number of prescribed antibiotics for each GP practice in a selected PCT.

Logic

• Creatinine clearance calculator considerations:-
  
  1. Cockcroft-Gault Formula-
     CrCl,mL/min = (140 - age)(weight,kg)(0.85 if female)/(72 * Cr, mg/dL)
     
  2. Age- 12 to 70 years.
     
  3. Body weight formula's-
  • Adjusted body weight (ABW), kg = IBW, kg + 0.4 × (actual body weight, kg – IBW, kg)
  • Ideal body weight (IBW), kg (male) = 50 + [ 2.3 × (height, inches – 60)]
  • IBW, kg (female) = 45.5 + [ 2.3 × (height, inches – 60)]
    
  4. Body weight ranges-
  • Body Mass Index (BMI) <18.5 - Underweight
  • BMI 18.5-24.9 - Normal weight
  • BMI >= 25 - Overweight/Obese

Data Used

(click on the blue text to know more)

The data that drives the data dashboard is the practice level prescribing data provided by NHS Digital- NHS Digital Practice level prescribing data: more information.

The BNF codes for the required classes of drugs:-

1. Antibacterial drugs - Openprescribing.net.BNF 5.1: Antibacterial Drugs | OpenPrescribing.
   
2. Antifungal drugs - Openprescribing.net.BNF 5.2: Antifungal drugs | OpenPrescribing.
   
3. Antiviral drugs - Openprescribing.net.BNF 5.3: Antiviral drugs | OpenPrescribing.
   
4. Antiprotozoal drugs - Openprescribing.net.BNF 5.4: Antiprotozoal drugs | OpenPrescribing.
   
5. Antihelmentic drugs - Openprescribing.net.BNF 5.5: Anthelmintics | OpenPrescribing.
   

The Glossary of terms - NHS Digital Practice level prescribing - glossary of terms.

Reference resource - Creatinine calculator -

1. The formula - Cockcroft, D.W. and Gault, H. (1976). Prediction of Creatinine Clearance from Serum Creatinine. Nephron, 16(1), pp.31–41.
   

2. Age range -
   a. Pierrat, A., Gravier, E., Saunders, C., Caira, M.-V., Aït-Djafer, Z., Legras, B. and Mallié, J.-P. (2003). Predicting GFR in children and adults: A comparison of the Cockcroft-Gault, Schwartz, and Modification of Diet in Renal Disease formulas. Kidney International, 64(4), pp.1425–1436.
   b. Willems, J.M., Vlasveld, T., den Elzen, W.P., Westendorp, R.G., Rabelink, T.J., de Craen, A.J. and Blauw, G.J. (2013). Performance of Cockcroft-Gault, MDRD, and CKD-EPI in estimating prevalence of renal function and predicting survival in the oldest old. BMC Geriatrics, 13(1).
   

3. Body weight formula- McCarron, M.M. and Devine, B.J. (1974). Clinical Pharmacy: Case Studies. Drug Intelligence & Clinical Pharmacy, 8(11), pp.650–655.
   

4. Body weight ranges -
   a. Brown, D.L.,Masselink, A.J. and Lalla, C.D. (2013). Functional Range of Creatinine Clearance for Renal Drug Dosing: A Practical Solution to the Controversy of Which Weight to Use in the Cockcroft-Gault Equation. Annals of Pharmacotherapy, 47(7-8), pp.1039–1044. doi:10.1345/aph.1s176.
   b. Winter, M.A.,Guhr, K.N. and Berg, G.M. (2012). Impact of Various Body Weights and Serum Creatinine Concentrations on the Bias and Accuracy of the Cockcroft-Gault Equation. Pharmacotherapy: The Journal of Human Pharmacology and Drug Therapy, 32(7), pp.604–612.
   

Additional resources -

1. BNF Online-MedicinesComplete Digital Medicines Information Suite.
   
2. Practice level prescribing dataset used in the dashboard -NHS Digital Practice Level Prescribing December 2019.

(back to top)

Getting Started

Instructions for setting up the dashbaord:
conda install flask
conda install flask-sqlalchemy
conda install nose2
conda install markdown
conda install selenium
download the chrome-webdriver
git clone https://github.com/eedrobup/cyan.git
cd cyan

Running the Dashboard

Open terminal and run the following commands:
cd cyan
python run.py

Testing the Dashboard

cd cyan
nose2

Code Coverage report

This is code coverage report for the current version of the dashboard

..
----------------------------------------------------------------------
Ran 17 tests in 166.425s

OK
Name                                       Stmts Miss  Cover
-------------------------------------------------
app_init_.py                               12      1    92%
app\database_init_.py                0      0  100%
app\database\controllers.py       43       1    98%
app\database\models.py            22       0  100%
app\tests\test_database.py        27       1    96%
app\tests\test_frontend.py      130     19    85%
app\tests\test_view.py                16      1    94%
app\views_init_.py                    0      0   100%
app\views\controllers.py            52      5    90%
config.py                                      10      0   100%
run.py                                             2      2        0%
-------------------------------------------------
TOTAL                                       314    30      90%

(back to top)

Scrum Team Details

• Alix Har Linkedin
• Franklin Rajadurai Linkedin
• Halimah Fetuga Linkedin
• Tech Onn Ding Linkedin
• Nishat Girkar Linkedin
• Pubordee Aussavavirojekul Linkedin

(back to top)

License

The cyan dashboard is free and open source software licensed under MIT.
It is subject to only the condition that the copyright notice and the permission notice be included in all the copies and other portions of the software.

MIT
Copyright(c) cyan