What are some ways to make a slow query or dashboard faster?

Technical