News for hackers. Stuff that matters.
Re:Ask HN: What does your BI stack look like? by rajivayyangar on Tuesday November 12, 2019 @01:01PM (#21516345)
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 )

Re:Ask HN: What does your BI stack look like? by netcraft on Tuesday November 12, 2019 @02:55PM (#21517494)
$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)
Re:Ask HN: What does your BI stack look like? by rajivayyangar on Tuesday November 12, 2019 @04:30PM (#21518365)
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.

Re:Ask HN: What does your BI stack look like? by llampx on Thursday November 14, 2019 @12:33PM (#21537381)
It seems that Metabase does everything that PopSQL Enterprise does, but for free.