We have a team with around 4 to 5 concurrent major projects, 10 minor projects and about the same number of BAU projects.

Are there any tools that you use to manage and visualise your departments work and pipeline in similar situations?

I'm looking for a visual representation of resource allocation over time. Really like a product roadmap but for multiple products. At the moment I'm using a combination of MS Project & excel but wondering if there's anything else out there.