We use the standard Microsoft stuff. SQL Server, SSIS, SSRS, PowerBI. There are some pain points, but for the most part, it works, and it's pretty inexpensive if you're already a Microsoft shop.
Ask HN: What does your BI stack look like?
131–140 of 181 posts
Re: Ask HN: What does your BI stack look like?
#132Earlier quoted context omitted.
Companies using our platform add all sorts of items to their stack, including BI tools/services.
Nice. So you do hypothetically provide a stack similar to Fivetran -> Snowflake -> Looker
We don't currently have any way to define relationships between products, but I like that idea...
It looks something like this [0] when you view the aggregated data of the companies in your community, and you can also view each company's individual stack.
Re: Ask HN: What does your BI stack look like?
#133does anyone use ElasticSearch + Kibana?
I do. I work in data consulting. I prefer tableau on top of snowflake for 99% of jobs, but for massively scaling insert performance elasticsearch has a niche. Kibana seems like a mishmash of different products duct taped together, but for the most part plays nice.
Re: Ask HN: What does your BI stack look like?
#134Product Manager at Replica here.
I've set up the following stack:
Segment -> (postgres DB, Intercom, Heap Analytics, Full Story)
postgress = Data dump for future usage. Intercom = CMS + Communication. Heap Analytics = Product analytics. Full Story = Session analytics.
Re: Ask HN: What does your BI stack look like?
#135It covers many more bases than business intelligence, but Forest Admin. And most of its functionality is free.
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 deliveries on a map, etc).
Also has Stripe and Intercom integrations.
I really can't hype this enough. Have been using this on nearly every app I've built the past three years.
The core team also answered my emails as a never-paying customer within 2-3 days the few times I have mailed them over the years I've used it.
Re: Ask HN: What does your BI stack look like?
#136Embulk + Airflow => Postgres => Apache Superset(as UI/Tool)
ELT process so more DBT in the future
Re: Ask HN: What does your BI stack look like?
#137We use Retool.com with our Postgres & other data sources.
The benefit we can also build tooling and workflows, in addition to the metrics, tables and charts.
Early on you don't necessary don't exactly what end up needing, so malleable tool is useful.
Re: Ask HN: What does your BI stack look like?
#138Data Sources (Analytics, DBs etc) -> Stitch (stitchdata.com) -> Redshift -> Periscope (periscopedata.com)
This setup has worked pretty well for us so far. I've learned of a few tools from this thread that might help us to better manage data sets and views - specifically DBT and Dataform.
Re: Ask HN: What does your BI stack look like?
#139Postgres -> 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…
We've also been using Metabase lately. It doesn't have some of the querying power of a Tableau/Data Studio, but in terms of being able to just click through and "discover" trends in your data, it's really nice. Super quick and easy to get started even for non-technical folks, and best of all it's OSS! Really impressive project.
Re: Ask HN: What does your BI stack look like?
#140Sharing an awesome business intelligence tools list [0] I created ca. 2 years ago to get a better understanding of what's out there.
[0]: https://github.com/thenaturalist/awesome-business-intelligen...