How to make Dashboard of Dashboards without keeping datatables open in memory?

[#1]

I have a 500 item dataset, each one made up of about 500,000 data points. I want to make a report from each sub dataset and present the overall results of the 500 items with all of the resolution. The trival way is to make a dashboard/app of multiple datatables, but even if hidden they still take up memory and this is not an option. The end dashboard should give insights to notice issues within sub datasets and be able to open up specific points.
Any suggestions?

[#2]

Column Switchers might help with some of the issues you are facing.