TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

Insights – Open-Source Self-Hosted Business Intelligence Platform

91 pointsby mariusandraover 5 years ago

5 comments

thenaturalistover 5 years ago
I totally do not get the negative comments.<p>Having seen a fair share of BI tools (I created and maintain an &quot;awesome&quot; list at [1] which I created for the sole purpose of getting an overview of what&#x27;s out there) and assessing the stage you&#x27;re at developing solo, you&#x27;re getting quite some important UI basics very right imo.<p>The &quot;Next Steps&quot; give a great impression of what&#x27;s possible and how to navigate the app.<p>From an E-Commerce viewpoint, most people want to flexibly play around with Products, Orders and Order Line Items and ratios between the three. Configuring this by hand in something like Google Datastudio etc. is cumbersome, even or more so in Looker (if broken out into separate Views, one needs to needs to create Merged Results Looks; if not the different cardinality objects are always connected). I feel like Insights is handling this really well. If you would add support for calculated fields, you&#x27;d offer a compelling E-Commerce controlling solution.<p>One issue I noticed though is that your nesting seems to be unlimited. I could open an infinite &quot;table&quot; tree if I start from the order_lines or product view --&gt; order_lines --&gt; order --&gt; order_lines --&gt; product --&gt; seller --&gt; orders&#x2F; products... ad infinitum.<p>You want to make sure that this drilldown into FK relationships does not lead to loops. Also I think some visual support where in the nest tree one is at (orders --&gt; order_lines --&gt; product --&gt; sellers) would be great, otherwise it&#x27;s quite easy to get lost.<p>Other than that honestly congrats on doing a lot of things right in terms of data viz, responsiveness, sharing capabilities. Really like your work!<p>[1]: <a href="https:&#x2F;&#x2F;github.com&#x2F;thenaturalist&#x2F;awesome-business-intelligence" rel="nofollow">https:&#x2F;&#x2F;github.com&#x2F;thenaturalist&#x2F;awesome-business-intelligen...</a>
评论 #22349369 未加载
_frklover 5 years ago
Nice, well done! I&#x27;m using Metabase at the moment, which I quite like, except for a few little annoyances. What was your motivation for writing this, and where do you see insights differ from the current main players like metabase, superset and redash?<p>Feature wise, in case you are interested, for these tools it is important to me to be able to create the graphs&#x2F;dashboards in an automated way, e.g. via an api. Import&#x2F;export would also be good. Also: openid support, ldap would be nice to have too, but openid would suffice.
评论 #22349410 未加载
评论 #22349739 未加载
评论 #22349543 未加载
fsajkdnjkover 5 years ago
The title should be: &quot;Insights is a tool to visually explore a PostgreSQL database&quot;
lappaover 5 years ago
IMO, your demo site could be improved by having some widgets created in advance.
saber6over 5 years ago
Already on my nope not even gonna try it list.<p>The demo page does that annoying crap where it tries to prevent you from navigating to your prior site.<p>I thought that trend peaked in like 2001.
评论 #22349007 未加载