Apologies if this is covered somewhere but I could not find an existing article that made sense and fit my criteria.
Users have 1-4 dashboards and the reports on each dashboard draw on databases with 200,000+ rows each. The dashboard can take can several minutes to render fully and I would like to speed it up.
The database is updated once every 24 hours on a schedule but the reports aren't static. Users can filter the reports but the default unfiltered report still takes ages to load and there are several on the same tab.
I found information on dashboard caching which will improve the UX but I don't believe that will help the view to load any faster when they first log in.
What steps would you recommend to ensure the least amount of time is spent waiting for a report/chart/dashboard to load?