Organisation Executive view of project plans and progress

Within my organisation, we have up to 20+ projects in various stages of their lifecycle going at any one time.  Each project has activities relevant to specific departments within the organisation an...