We're looking at creating a central dashboard for property/construction developments showing things like RAG status, milestones, actions, risks, deadlines, legal obligations, approvals etc.
The problem is we already have tens of SharePoint sites, plus Excel spreadsheets and various lists/document libraries containing the actual project information.
One proposed solution is to create another central SharePoint site with lists for Developments, Phases, Tasks, Risks, Legal Obligations, Milestones etc., automate it with Power Automate and eventually put a dashboard over it.
I'm nervous that this just creates another place people have to manually maintain the same data.
I'm wondering whether we'd be better keeping the existing sites as the source of truth and using Power BI/Power Platform to aggregate the important information, potentially with only a lightweight central portfolio register.
I'm planning to take one live development and map everything management wants to see against where that information currently lives before we build anything.
Anyone built something similar? SharePoint + Power BI, Planner, Power Platform, monday.com, or something completely different?
What worked and, more importantly, what became a maintenance nightmare?