[avdempsey]

You might check out Redash or Caravel. They're both open source, you host them yourself, and have a bunch of dashboard and access control functionality.

Caravel in particular has some great exploration tools. You can build queries either by hand or by using visualization specific drag and drop. Caravel is getting regular updates from the AirBnB team too.

If you want more power I recommend using a Jupyter notebook and Python. There's also Rodeo which is like R Studio for Python.