New on LowEndTalk? Please Register and read our Community Rules.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
What opensource data analytics and business intelligence tools?
k9banger02
Member
in Help
I'm looking for open source data analytics tools, and just tried out Metabase and Redash.
Redash seems to be the better tool but it seems development has slowed after they were bought out by Databricks, probably Databricks undermining open source competition and folding it into their main product.
What other openisource tools are recommended here? I saw a page mentioning a few of them here sometime back, but have forgotten which one it was.
I see Grafana mentioned but it seems more focused on graphing logs and events. Does it handle transactional data?
Comments
Good question. I do know Grafana is a popular solution, same with Zabbix (you're going to have to fanagle the data inputs).
There's also Apache Superset (https://superset.apache.org/ )
If you're keen on coding it yourself, then there's always coding something up in Python and wrapping it around in Dash (or R and Shiny).
On the non open-source way, our firm uses the living crap out of Microsoft Power BI and I used to spend a significant amount of my time on writing models and dashboards and integrating them with R Shiny.
Thanks for the heads up about Apache Superset.
What applications are Dash and Shiny? Do you have URLs for them?
I think I know what R is
Dash - https://plotly.com/dash/
Shiny - https://shiny.rstudio.com/
R is the programming language most commonly used in data science and data analytics (imho, better than Python due to Hadley Wickham's Tidyverse and his implementation of "Fundamentals of Data Visualizations" (which is the ggplot2 package). You'll find similar data science/analytics packages in python such as numpy, pandas, and matplotlib but none of them really hold a candle up to ggplot and tidyr. But Python is just more popular as a generalized programming language so ehh.
Plotly and Posit are two very successful data visualizations and analytics firms that are operating within each ecosystem. Anything they make are always a high quality product.