Surprised nobody here mentioned Mode Analytics. Unlike Looker or Tableau, it requires users to know SQL. That said: if you're an org where the business people

Surprised nobody here mentioned Mode Analytics. Unlike Looker or Tableau, it requires users to know SQL. That said: if you're an org where the business people know SQL or are willing to learn--Mode is clean, simple, and super powerful. My company had a great experience with this. Our COO was super proficient with Excel. I showed him basic SQL, he loves it and has learned quickly. The jump from Excel power user to SQL user is totally doable, and probably most people making custom reports are already at least in the former category! Additionally, a few of us have substantial Pandas experience: Mode makes it trivial to go from SQL to a Jupyter like notebook w Pandas, Matplotlib, seaborn etc all already there--no need for Python version or dependency hell. Zero devops at any layer below the raw datastore (MySQL / Redshift / etc). It's really nice. You write code purely against open standards--SQL, pandas etc. Looker uses a proprietary query language, LookML. I am not tempted to go learn it.