Live Business Metrics Dashboard Build

I need help turning the data that sits across my tech stack into a single, always-on dashboard inside MCP. Right now our numbers are scattered in Pipedrive, Xero, Google Sheets, Google & Meta Ads, SharePoint, a custom quotation tool, and WhatsApp Business. Pulling them manually is slowing decisions; I want the figures to be streaming in real time. The board should focus on three headline areas: Sales performance, Customer engagement, and Marketing effectiveness. I picture clean graphs and charts that refresh automatically rather than static tables. If you have ideas for additional drill-down views, great—just keep the overall experience visual and intuitive. Key things I expect from you • Connect each data source to MCP (API, webhook or other suitable method) • Model the data so the same metric means the same thing, no matter which system it originated from • Build the dashboard layout, favouring graphs and charts for the core KPIs • Set up automated refresh so figures stay live without manual intervention • Provide a short hand-over guide so my team can tweak or add widgets later Acceptance criteria 1. All listed sources feed the dashboard with no more than a 5-minute delay. 2. Sales, engagement and marketing KPIs render as line, bar or pie charts (not tables). 3. Filters for date range and campaign/channel work across every widget. 4. Documentation lets a non-technical user add a new metric following the same structure. I’m open to leveraging pre-built MCP connectors or writing custom scripts—use whatever keeps the solution maintainable. Let me know what similar dashboards you’ve built, what approach you’d take first, and an estimated timeline for each integration.