Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Ask HN: What does your BI stack look like?

news.ycombinator.com

Post reply on HN
Print view View original

151–160 of 181 posts

Re: Ask HN: What does your BI stack look like?

#151

Post by johnx123-up »

mazameli wrote: post #77
seveibar wrote: post #13

Postgres -> Metabase I believe this is the best combination of cheap/powerful for early-stage startups. My very non-technical cofounder is able to use metabase's simple GUI interface to create graphs/insights (even joining and aggregating across tables!), and for anything complex I can step in a give a helper SQL query. We have around 10M records we aggregate around for daily insights. Metabase can also be run as a p…

UX guy from Metabase here. Glad to hear it's working well for you. Happy to answer any questions folks might have.

Can you please compare it with Superset?

Re: Ask HN: What does your BI stack look like?

#152

Post by pknerd »

seveibar wrote: post #13

Postgres -> Metabase I believe this is the best combination of cheap/powerful for early-stage startups. My very non-technical cofounder is able to use metabase's simple GUI interface to create graphs/insights (even joining and aggregating across tables!), and for anything complex I can step in a give a helper SQL query. We have around 10M records we aggregate around for daily insights. Metabase can also be run as a p…

Looks interesting but I would like to know how is it different than Apache Superset. What is the concept of "Question" here? Is it about some "official terminology" for a "SELECT" query? Any video demo?

Re: Ask HN: What does your BI stack look like?

#153

Post by sphix0r »

We built our own tool at Datastreams (https://datastreams.io) to collect data. We currently collect several thousands of events per second, mainly web data.

Events are mainly streamed to one of the following: Cloud buckets(S3, etc), HDFS, SQL-db or Cassandra.

Most clients use one of the following visualization tools: PowerBI, Qlik or Tableau.

Our clients are mid to enterprise size.

Disclaimer: I work at Datastreams

Re: Ask HN: What does your BI stack look like?

#155

Post by LunaSea »

asati wrote: post #97

Postgres (read replica) -> Redash Segment -> Amplitude (but using it less and less) I am surprised no one mentioned https://redash.io/ till now (a lot cheaper than looker/mode/Periscope with all the basic functionality that you might need).

Redash is far too expensive for what it does imo. Haven't used the other solutions though.

Re: Ask HN: What does your BI stack look like?

#156

Post by Bienno »

dwl285 wrote: post #28

If you have a data team: Stitch / Segment -> BigQuery -> Dataform -> BigQuery -> Looker I work with many companies helping them set up their data stack, and from what I've seen this is pretty much the optimal set up. These tools all require very little maintenance, are relatively cheap (compared to the man power required to set these things up from scratch internally), and scale well as companies grow and complexity…

How would you pipeline data sources that don't have a native connector in Stitch / Segment without using too many engineering resources?

Re: Ask HN: What does your BI stack look like?

#158

Post by sails »

johnx123-up wrote: post #151
mazameli wrote: post #77

Earlier quoted context omitted.

UX guy from Metabase here. Glad to hear it's working well for you. Happy to answer any questions folks might have.

Can you please compare it with Superset?

Worlds apart, superset provides powerful visualisation capabilities, but is very difficult to use/setup/maintain (although they just launched as a company [0], so perhaps that will change).

Metabase is a very easy to use data exploration, data vis and reporting tool designed to give insights into data in an easy/self service way for mostly non-technical users.

I've POC'd both, and would recommend Metabase or redash unless you really know what you need out of superset

[0] https://preset.io/blog/2019-10-09-series-a-announcement/

Re: Ask HN: What does your BI stack look like?

#159

Post by sails »

pknerd wrote: post #152
seveibar wrote: post #13

Postgres -> Metabase I believe this is the best combination of cheap/powerful for early-stage startups. My very non-technical cofounder is able to use metabase's simple GUI interface to create graphs/insights (even joining and aggregating across tables!), and for anything complex I can step in a give a helper SQL query. We have around 10M records we aggregate around for daily insights. Metabase can also be run as a p…

Looks interesting but I would like to know how is it different than Apache Superset. What is the concept of "Question" here? Is it about some "official terminology" for a "SELECT" query? Any video demo?

I replied to that question here based on my experience: https://news.ycombinator.com/item?id=21523076
Post reply on HN