Attendees: alice.gagg2 Clare Wright Jon Howes, Fiona Muchet, Chad Atkinson
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
Based on Hicom’s response have filtered out Grade is NULL from Application Count Dashboard. Current filter excludes ‘In Progress’, 'Application withdrawn before submission' and Grade IS NULL. The Vacancies will still show though with an application count of 0.
Added additional filters to Applications Dashboard, Round Type and Derived Round Type (need a better name). Derived Round Type uses a combination of Staff Group, Offer Round Name and Specialty Name. There is a taxonomy on a spreadsheet for review. Also moved the filter view to enable filters to be more readable. If both are useful will apply to other workbooks.
After conversation with Alice, there is an issue with the Staff Group field where it is showing recruitment offices as well as Staff Groups. To be raised with Hicom.
Previous Actions -
Fiona’s access to dashboard
Additional filters for Fill rate dashboard - Offer round type (derived) -medical, Academic etc required?
cross over application detail - Need to document details and write a ticket for this.
Competition ratios - TIS21-6675 - Getting issue details... STATUS -in progress
Questions from Data Analytics Team
Application Count NULL Grades - These will not be counted as applications but the vacancies will still show with a NULL grade and with a 0 count.
Is this desirable or is this misleading and should be excluded until there are some applications? - Not required. Remove them completely
Round Grouping for Filters:
Stand-alone rounds, e.g. R1- F2 Stand-alone 2025 (UKFPO), 2025 ICM ONLY Round:
Should these be grouped or kept separate, i.e. ‘Foundation’ and ‘Medical’ respectively?
Are these predictable, i.e. the same stand alone rounds will happen every offer year, or will these change each year depending on circumstance?
If the latter of the above, how can these be grouped? ICM is a new round done as a trial for this year. going forward round name can have a set naming convention so that we can use the offer round to group correctly
Regional ‘All Other Rounds’:
Can these/should these be grouped?
If so, how?
Fill Rate dashboard - 2 different views for Region-wise summary? which would be needed.
Q&A / Feedback
Add Comment