Program Reporting -Consolidation across different tools and methodologies

Question

Hello. Our team needs to provide Program level dashboard reporting for Sr. Leadership. The challenge is all our projects are run and managed off of different toolsets and different methodologies.

We have Agile projects within different tools, waterfall, and hybrid projects in multiple tools. Is there software that can pull information from various systems/processes to create one organized dashboard? 

Thanks in advance.

Answer 1

This is the main reason why senior management looks for a dashboard in the first place as all the metrics that they are looking for in which they would base a lot of their decisions on is spread across multiple systems and they are trying to consolidate the information in real-time is difficult if not next to impossible.

The simplest approach is to do an MS Excel data export/dump in a consolidated spreadsheet and run queries and create reports from there. As an approach, it is relatively simple to get the concept up and running and fine-tune the actual requirements from your senior management as to what information they need and displayed and in what time period they need it.

However, in the long run this approach can be time-consuming if you do not automate some of the processes.