Patient Pathway Analysis Tool – Update

Update on my Patient Pathway Analysis work for NHS England RightCare.

Advertisements

Data Science Project – Patient Pathway Analysis

This is a short piece on a project I'm developing at NHS England, using Python to analyse patients' inpatient care and determining where a Clinical Commission Group's (CCG) patients are being treated significantly differently to those patients in its peer group CCGs (similar 10 CCGs as determined by NHS Rightcare Methodologies). While not traditional 'data … Continue reading Data Science Project – Patient Pathway Analysis

HOW TO… Excel: Create a hierarchical series of drop down boxes

As a result of prodding around the excel subreddit I found a query from user innocuous_gorilla about creating drop downs that are dependent upon each other. Due to working at NHS England where we have a massive array of organisation types and hierarchies, I quickly learnt how to do this! For example, in NHS England … Continue reading HOW TO… Excel: Create a hierarchical series of drop down boxes

HOW TO… VBA: Compare VBA Combo Box Values with Their Lists

Preamble So, a recent issue I’ve had using VBA to create UserForms to handle data input is data validation. Throughout my UserForm I’ve included a variety of Combo Boxes that contain lists of information the user can select. In most instances I would like the user to have inputted exactly one of the options within … Continue reading HOW TO… VBA: Compare VBA Combo Box Values with Their Lists

Analytics and Ethics

Upon the enlightening release of the Cambridge Analytica exposé that revealed the company's underhanded tactics it utilises to influence and manipulate people with a combination of data analytics, espionage, and 'honeypotting', I think it's incredibly important to discuss how the analytical community needs to ensure a commitment to honest and unbiased analytics, and ethically sourced … Continue reading Analytics and Ethics

HOW TO… Excel: Create a Dynamic Data Range for a Chart

Continuing the theme of automatically updating charts, we’re going to look at how to make a chart deal with a dynamically changing data range. This is useful for situations where you have multiple measures that each have a different number of independent variables (the variables plotted on our x-axis, which was the month of the … Continue reading HOW TO… Excel: Create a Dynamic Data Range for a Chart