[rajivayyangar]

As a data scientist (startup / Yahoo) turned product manager (4 startups), I've used a variety of stacks in the past - from plain SQL, to Mode, to Mixpanel, Looker, Interana, and Hive.

Recently we started using PopSQL (https://popsql.com) and love it.

When I don't have a dedicated data team, my philosophy is:

1) Make it difficult to get wrong answers

- Don't use Google Analytics. It's too easy to generate incorrect charts, and too difficult to verify them.

- Have a limited sandbox of reports for non-SQL writers

- Keep the SQL close to the report, so it's easy to verify the underlying query.

- Push people to learn even basic SQL

2) Make it quick and easy to ask iterative questions - PopSQL is way faster than Mode. Like 20x faster.

3) For metrics that matter (e.g. KPIs), instrument them directly and even build a custom analytics dashboard if it's important. (beware dashboard clutter! https://twitter.com/andrewchen/status/1193619877489192961 )

[netcraft]

$20/user/month seems incredibly expensive for an editor that we would have traditionally paid a one time cost for. I assume this has the saving and sharing of queries built in, but that is a lot of money for some storage. Are there other major benefits I am not seeing? (It is not my intention to attack you or make you defend this product, I am just curious if I am missing something - there are a lot of similar products with similarly questionable value propositions)

[rajivayyangar]

Saving, shared queries, easy link sharing, and basic charts with some intelligence. It also has excellent query UX (auto-complete, etc.).

Most of all, it's really fast. It fundamentally depends on your DB of course, but PopSQL doesn't add any extra bloat the way Mode does.

[llampx]

It seems that Metabase does everything that PopSQL Enterprise does, but for free.