Post-16 - Analysis by Subject and Student Type

Hello everyone, after some help.

I work for a MAT and we have 15 secondary academies currently taking applications for Post-16.

I need to provide analysis as follows:
Applications per subject across the trust
The top 3 A Levels, T Levels, IB etc
A breakdown of those by internal and external students.

Whilst I can do this manually I really don’t want to have to spend time trawling through each system, exporting data, manipulating it and so on, especially as I could be asked for this at any point.

Do any of you have a system you already use? Do you know if there are plans for something like this on the MAT Dashboard (if so this would be amazing!).

Thank you