PromQL is superb for metrics alerting and graphing needs, for heavier statistical work there are better options.
A blog on monitoring, scale and operational Sanity
On a regular basis a potential Prometheus user says they need a different architecture to make things reliable or scalable. Let's look at that.
Having to maintain dashboards for every Prometheus server you have would be a bit annoying. Thankfully Grafana has a feature for this.