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

171–180 of 181 posts

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

#171

Post by seektable »

alexfromapex wrote: post #34
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…

Wow Metabase is free and open source?! Awesome, thank you!

it is licensed under AGPL. For white-label embedding it requires a commercial license: https://www.metabase.com/enterprise/pricing.html Pricing for variant with row-level security is not cheap as you might expect, so if you plan to embed reports in your web app it might be better to consider another alternatives.

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

#172

Post by seektable »

chrisacky wrote: post #88

Is there any way that we can provide BI to our customers using an OSS tool? Our databases store all our users data. I'm thinking of using something like pgsync to sync all database postgres to a new postgres and then having redash or metabase set up to connect. Alternatively using locked filters on metabase and embedded questions. All our data for our users are in postgres and they very much want BI insights. Not sur…

For his purpose you can check 'Team Sharing' feature of our BI tool (SeekTable): https://www.seektable.com/help/share-report-to-team

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

#173

Post by dinkleberg »

gavinray wrote: post #135

It covers many more bases than business intelligence, but Forest Admin. And most of its functionality is free. https://www.forestadmin.com/ It generates a very beautiful CRUD admin dashboard automatically via reflection. Allows building drag-and-drop data viz dashboards, saving commonly-used custom queries as "scopes", and even building your own HTML views if you need to get really fancy (think tracking live deliveri…

Wow, that looks incredible. I don't know why, but I've never really thought to look for admin site solutions out there, instead opting for janky in-house built ones. I'll definitely be playing around with this.

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

#174

Post by exabrial »

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?

Have you ever tried to install/setup Superset? The chances of you completing this task fall somewhere between "Next to impossible" and "Not going to happen".

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

#175

Post by dwl285 »

pcarolan wrote: post #4

Looker on top of Redshift. Events streamed in from Segment and ELT transforms managed by Airflow. Looker gives you nice visualizations and charting with RBAC and some some lightweight ETL functionality. The real advantage of Looker is their modeling layer which sits on top of your physical data and is done via a DSL called LookML. Source control is managed via a wrapper around git. The end result is that analysts can…

If you're interested in an alternative to dbt that's a little more analyst friendly, check out Dataform. A lot of teams are using Dataform between the warehouse and looker, to handle transformation logic using pure SQL, but in a more user friendly format than Airflow. Get in touch if you'd like to chat! dan at dataform.co

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

#176

Post by dwl285 »

crustacean wrote: post #45

Sorry to be that one avoids-the-question comment, but: Without design sessions to figure out your data store design (look up Kimball, Immon), and then monitoring/testing to make sure everything is running smoothly, any data stack will be hell. Badly designed data brings fatigue and rancor and unnecessary work and is a huge hard-to-quantify money suck.

IMO the right solution to this is not spending a bunch of time upfront trying to design your warehouse. You just want to adopt a tool that makes it easy to continuously refactor into more optimal formats as your warehouse scales. Happy to discuss more if you're interested! dan at dataform.co

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

#177

Post by dwl285 »

grahamdietz wrote: post #53

We use Snowplow directly into Snowflake and report on this using Mode. We are a data native SaaS firm, and we set things up like this about 5 years ago and it has served us well. Streamlined and high performance. For all other sources, we use Stitch -> Snowflake, with one semi-custom Singer.io tap also running on Stitch. All this was simple to set up and means we don't have to worry about getting the data into one pl…

Are you using Dataform Graham? I don't think we've spoken if you are, I'd love to chat! dan at dataform.co

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

#178

Post by pknerd »

exabrial wrote: post #174
pknerd wrote: post #152

Earlier quoted context omitted.

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?

Have you ever tried to install/setup Superset? The chances of you completing this task fall somewhere between "Next to impossible" and "Not going to happen".

What's difficult to install it? I have installed both local and Docker Version. The docker one takes more memory though.

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

#179

Post by exabrial »

pknerd wrote: post #178
exabrial wrote: post #174

Earlier quoted context omitted.

Have you ever tried to install/setup Superset? The chances of you completing this task fall somewhere between "Next to impossible" and "Not going to happen".

What's difficult to install it? I have installed both local and Docker Version. The docker one takes more memory though.

You're not installing it when you're using Docker. However that send to be on the only possible way to run it.

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

#180

Post by soobrosa »

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.

Oh, yeah, thanks for asking! Reasons I had to cancel Metabase deployments.

https://github.com/metabase/metabase/issues/4387 opened this issue on Feb 15, 2017

https://github.com/metabase/metabase/issues/2052 opened this issue on Feb 29, 2016

https://github.com/metabase/metabase/issues/6741 opened this issue on Jan 22, 2018

Post reply on HN