I’m a region staff officer and I’d like to use some data to inform our course content and programme for 2026.
It’s easy to measure my team’s “output” based on the number of qualifications we award. But it’s much harder to measure our “outcomes”. For example, whether our qualified staff end up running any activities.
There are various queries I’d like to run against the SMS database which would really help. For example… for each person with a given qualification, how many “cadet-days” of activity have they supported as a “Director” and/or “IC”, broken down by year/quarter, and event category.
I work in enterprise/government IT and often in data related roles, so I have a very clear idea of what I’d like to do. I’ve tried asking the BADER team directly (and offered my help to the VSDT on several occasions) but always been ignored.
Before I ask for anything through the CoC, I wanted to know what options may be available. For example I believe that Wing/Region Training Officers have access to Power BI, but I’m uncertain which datasets are available.
Separately / relatedly, I often need to email people who hold a specific qualification. This involves a lot of copying and pasting from the “qualification list” area of SMS. I use a macro to speed this up but it’s still a massive pain. Does anyone have a better approach for this?
Any tips appreciated, thanks!