Querying thousands of data points from the DHIS2 Analytics WEB API

Need to create a big report/output with possibly thousands of data points spread across multiple dataelements, inidcators & location using the analytics API.
The report needs to be on an external platform/portal.

Have any of you worked on a similar requirements?

Even if you haven’t what would you suggest be the best strategy to approach the solution?