Demo - https://tabanalytics.data.england.nhs.uk/#/projects/1272
Application Count Dashboard - https://tabanalytics.data.england.nhs.uk/#/views/ApplicationsDashboard_17322697220340/ApplicationCounts
Fill Rate Dashboard - https://tabanalytics.data.england.nhs.uk/#/views/FillRateDashboard/FillRates
Previous Actions -
Questions from Data Analytics Team
For the Dashboard :
Should we clean up Preference Region in the back end or leave it as it appears in the data. For eg if Preference Region = “London and Kent, Surrey and Sussex” should we make it just “Kent Surrey and Sussex” ? or “Other”
Should all NULL Grades be excluded from Application Counts no matter the status?
For Offer Year 2025-2026, why for some specialties is there already a ‘Round 2’ present? Why do some specialties have a Round 2 but not a Round 1?
Cross Over Application calculation Question:
To calculate if an applicant is a cross over applicant or not we only look at those applicants who have applied for more than one specialty within the same OfferYear+OfferRound. So Cross over applcant = Applicant who has applied to more than one Offeryear+Offer Round is this correct?
For Applicant ID = 5154
Only for Offer year 2024-2025 in "2024 Medical Round1" the applicant is Crossover applicant , in other offer years eg 2023-2024 the same applicant is not a cross over applicant. Is the right in assuming?
Application Counts Questions:
As not all records have a status of ‘Applied’, for Application Counts an ApplicationID with any status except ‘In Progress’, 'Application withdrawn before submission' is considered to be an application. Are there any other statuses which should not be included?
Application Status of ‘Longlist Unsuccessful’ produces a record with a NULL Grade. Is this expected? Should those with this status be excluded from Application Counts completely or just those with NULL Grades?
Should all NULL Grades be excluded from Application Counts no matter the status?
Q&A / Feedback
Add Comment