HI Rivv
Alot of this i have done with custom coding and really isnt something you can do as an average admin unless you have SQL experience.
If you know how to query your database there are some great plugins to use.
I use
AD Hoc Dabase queries plugin - here
I also have custom php pages which i use for dept managers to acces which i restrict using the Links Plugin - here
There are some very people on here who can point you in the right direction but you may need professional help which is available through a moodle partner
HTH
Gary
If my post helps consider rating