With SurveyJS form UI libraries, you can build and style forms in a fully-integrated drag & drop form builder, render them in your JS app, and store form submission data in any backend, inc. PHP, ASP.NET Core, and Node.js. Learn more →
Top 23 Business Intelligence Open-Source Projects
-
Grafana
The open and composable observability and data visualization platform. Visualize metrics, logs, and traces from multiple sources like Prometheus, Loki, Elasticsearch, InfluxDB, Postgres and many more.
-
-
SurveyJS
Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App. With SurveyJS form UI libraries, you can build and style forms in a fully-integrated drag & drop form builder, render them in your JS app, and store form submission data in any backend, inc. PHP, ASP.NET Core, and Node.js.
-
Metabase
The simplest, fastest way to get business intelligence and analytics to everyone in your company :yum:
-
Redash
Make Your Company Data Driven. Connect to any data source, easily visualize, dashboard and share your data.
-
dbt-core
dbt enables data analysts and engineers to transform their data using the same practices that software engineers use to build applications.
-
-
WorkOS
The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
-
-
evidence
Business intelligence as code: build fast, interactive data visualizations in pure SQL and markdown
-
FastReport
Free Open Source Reporting tool for .NET6/.NET Core/.NET Framework that helps your application generate document-like reports
-
-
-
retentioneering-tools
Retentioneering: product analytics, data-driven CJM optimization, marketing analytics, web analytics, transaction analytics, graph visualization, process mining, and behavioral segmentation in Python. Predictive analytics over clickstream, AB tests, machine learning, and Markov Chain simulations.
-
optimus
Optimus is an easy-to-use, reliable, and performant workflow orchestrator for data transformation, data modeling, pipelines, and data quality management. (by raystack)
-
turnilo
Business intelligence, data exploration and visualization web application for Druid, formerly known as Swiv and Pivot
-
motor-admin-rails
Low-code Admin panel and Business intelligence Rails engine. No DSL - configurable from the UI. Rails Admin, Active Admin, Blazer modern alternative.
-
-
-
-
InfluxDB
Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
Project mention: Docker Log Observability: Analyzing Container Logs in HashiCorp Nomad with Vector, Loki, and Grafana | dev.to | 2024-04-19Monitoring application logs is a crucial aspect of the software development and deployment lifecycle. In this post, we'll delve into the process of observing logs generated by Docker container applications operating within HashiCorp Nomad. With the aid of Grafana, Vector, and Loki, we'll explore effective strategies for log analysis and visualization, enhancing visibility and troubleshooting capabilities within your Nomad environment.
Superset is absolutely phenomenal. I really hope Microsoft eventually releases all of their customizations they made to it internally to the OS community someday.
https://www.youtube.com/watch?v=RY0SSvSUkMA
https://github.com/apache/superset/discussions/20094
Remote Code Execution via H2
Project mention: Redash: Connect to data source, easily visualize, dashboard and share your data | news.ycombinator.com | 2024-03-20
> YAML, pivoting being done in the frontend, no symmetric aggregates
(one of the maintainers of Lightdash) You touched on some of our most interesting problems here! Would be especially interested to hear about what you liked / didn't like about symmetric aggregates in Looker and how you find dev with YAML. If you have an idea of how you'd like these to look in Lightdash, the team would be really open to making that a reality.
For pivoting in the backend, this is coming! Issue here: https://github.com/lightdash/lightdash/issues/2907
Project mention: SQLPage – Building a full web application with nothing but SQL queries [video] | news.ycombinator.com | 2024-03-11It’s interesting to me how far you have pushed the SQL language in this framework, such that it truly is “SQL only”.
The challenge as I see it with enabling analysts to build websites is that you need to build abstractions to get from familiar (SQL, yaml) - the language of analytics, to new (HTML, CSS, JS) - the language of the web browser
As one of the maintainers of Evidence (https://evidence.dev), one of the things I’ve often considered is how accessible our syntax is to analysts. Our syntax combines SQL and Markdown, with MDX style components e.g.
The are inherently webdev-ey, and I do think they put off potential users.
On the flip-side, by adhering to web standards, you get extensibility out of the box, and working out what to do is just a Google search away.
Anyway, thanks for the thought provoking piece.
Project mention: EU suggests breaking up Google's ad business in preliminary antitrust ruling | news.ycombinator.com | 2023-06-14In a project I maintain on billing and payments[1], I had a link to Google Ads API. It was documenting how they had hard-limit budget, with notions like "capped actuals" and "monthly with rollover". The explanation was quite good so I keep it around to explain the concept, and why it was perfect for customers to avoid any surprises.
Then the URL[2] 404'd and the API disappeared. I couldn't find any references to a "BillingCap". I wondered why[3].
Now it makes sense: they got rid of budgets as you explained above. Everything's seems to be obfuscated behind a quite opaque Proposals/Deals[4] data structure now.
[1]: https://github.com/kdeldycke/awesome-billing
You can check odpf github, they created some dataops tools using go, one of the example is optimus (https://github.com/odpf/optimus) which is a data pipeline orchestrator
Project mention: Quary: Rust-based data transformation alternative to DBT | news.ycombinator.com | 2024-02-21
Project mention: Show HN: Synmetrix – Open-Source Platform for Data and Metrics Management | news.ycombinator.com | 2024-02-28
NOTE:
The open source projects on this list are ordered by number of github stars.
The number of mentions indicates repo mentiontions in the last 12 Months or
since we started tracking (Dec 2020).
Business Intelligence related posts
- ADA: Accelerate Data Analysis with AI
- Show HN: Synmetrix – Open-Source Platform for Data and Metrics Management
- Apache Superset
- Blazer: Business Intelligence Made Simple
- Is Tableau Dead?
- Show HN: Synmetrix – Open Semantic Layer
- Dbt
-
A note from our sponsor - SurveyJS
surveyjs.io | 28 Apr 2024
Index
What are some of the best open-source Business Intelligence projects? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | Grafana | 60,395 |
| 2 | superset | 58,852 |
| 3 | Metabase | 36,510 |
| 4 | Redash | 24,948 |
| 5 | dbt-core | 8,881 |
| 6 | openblocks | 5,554 |
| 7 | Blazer | 4,375 |
| 8 | lightdash | 3,399 |
| 9 | evidence | 3,320 |
| 10 | FastReport | 2,548 |
| 11 | awesome-business-intelligence | 1,952 |
| 12 | metricflow | 1,073 |
| 13 | insights | 1,057 |
| 14 | awesome-billing | 811 |
| 15 | dataform | 790 |
| 16 | retentioneering-tools | 762 |
| 17 | optimus | 737 |
| 18 | turnilo | 705 |
| 19 | motor-admin-rails | 701 |
| 20 | quary | 570 |
| 21 | mlcraft | 467 |
| 22 | dbt-metabase | 425 |
| 23 | faros-community-edition | 403 |
Sponsored
Power Real-Time Data Analytics at Scale
Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
www.influxdata.com