The AWS RedShift integration was a really good move, as one of the reasons we did not adopt them at my previous company was the requirement that the data set fit in memory of the server.

With RedShift, you offload the actual crunching to the db that can handle billions of rows, and then visualize the results.