> Given billions of rows of data across a few tables, how do you best make sense of it?

Your inquiry won't go anywhere until you describe the problem you're trying to solve. Be specific, if only for a single example problem.

I say this because there's no generic solution to accessing a large database -- the solution depends on the goal.