Load Time for Dashboard with Column Sum Metrics

Hello,

I have created about 30 datatables to display on our website all using sql queries. I have them all linked to a dashboard page where I am using the column sum shortcode to display the metric to click to obtain the report. The problem is that the page takes a very long time to load as it appears to be fetching all data for all 30 reports in order to display the metrics. Any ideas on how this can be done with improved speed?

Here is an example of the shortcodes I am using on the dashboard page:
[wpdatatable_sum table_id=7 col_id=57]

Thanks,
Rob