ETL: Python & SQL
Warehouse: PostgreSQL
Reporting platform: Looker
Easy, agile, and cheap.
Ask HN: What does your BI stack look like?
31–40 of 181 posts
Re: Ask HN: What does your BI stack look like?
#32Formerly: Oracle Hyperion -> ETL to Azure -> PowerBI Currently: Internal Data Warehouse -> RDS -> Internal web app (Django, React)
Was that Essbase or HFM? I had lots of fun once getting bulk data out of HFM and into spreadsheets via a web app.
Re: Ask HN: What does your BI stack look like?
#33{SQL Server, Oracle} -> ETL to SQL Server (Hybrid graph db)-> SQL Server Analysis Services -> {Power Bi, Tableau}
SSAS is my favorite cube / OLAP data store. I know I'm in the minority, but I find it really user friendly for devs and users.
Re: Ask HN: What does your BI stack look like?
#34Postgres -> 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!
Re: Ask HN: What does your BI stack look like?
#35Formerly: Oracle Hyperion -> ETL to Azure -> PowerBI Currently: Internal Data Warehouse -> RDS -> Internal web app (Django, React)
Was that Essbase or HFM? I had lots of fun once getting bulk data out of HFM and into spreadsheets via a web app.
Essbase, which made it a pain to get everyone off of Excel.
Re: Ask HN: What does your BI stack look like?
#36Postgres -> 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…
Metabase has been serving our startup well. Not as good as Tableau, but the minimalist approach is really good and SQL is better than Tableau's LOD expressions.
Re: Ask HN: What does your BI stack look like?
#37Does Excel qualify here?
Re: Ask HN: What does your BI stack look like?
#38Luigi, AWS S3, DBT, Snowflake and Re:dash (currently analyzing Metabase or Looker to allow queries without SQL) Luigi runs our scrapers and other workflow management tasks (e.g. DB backups). All raw data lives in S3. We make an effort to be able to recreate the whole data warehouse from the raw data, so if any cleaning/normalization process fails, we have this safety net. I'm curious to hear if others use a similar p…
You might want to check out Holistics.io, allowing your non-technical to explore data without writing SQL. It's an alternative to Looker but more affordable, and more powerful than Metabase.
If you setup your data well and have denormalized data tables, metabase is really good.
Re: Ask HN: What does your BI stack look like?
#39how does one end up doing BI | Data Engineering ? currently a frontend | full-stack JS dev. tired of that world and want to switch to something stable ?
If you can setup data pipelines and pump data into dashboards, the rest is just getting the business to ask the right questions.
Re: Ask HN: What does your BI stack look like?
#40Stitch/Fivetran/Custom -> Snowflake -> dbt -> Periscope
Lots more documentation here https://about.gitlab.com/handbook/business-ops/data-team/
We have many of our KPIs embedded in the handbook (look for KPI index mapping link).
This is also our primary project where you can see all of our dbt code https://gitlab.com/gitlab-data/analytics/