I've used this strategy with a read only replica. It also protects the database from long running and inefficient queries. Highly recommend doing this if you have the budget for it.

This is how PowerBI, from Microsoft, works. It copies the data into local RAM (or on a cloud machine that also runs the dataviz)