Opensource BI / Dashboard / Reporting solutions?
-
Not 100% sure if this what you want but Directus
https://medium.com/directus/tagged/mysql
or
Grafana
https://grafana.com/ -
We use MS's PowerBI, not open source and has a lot of gotya's that are incredibly annoying and expensive.
There also aren't many solutions that would work for us due to compliance issues.
-
Grafana is probably the easiest and best looking.
-
@Danp said in Opensource BI / Dashboard / Reporting solutions?:
@wrx7m said in Opensource BI / Dashboard / Reporting solutions?:
Domo
Have not seen that one. What factors led to choosing it? Which others did you look into?
I wasn't really too involved with the reasons. But, I am pretty sure that it has a lot of integrations with various channels.
-
Is Grafana actually something that could work for you? If you're looking more for reporting, you could check out Jasper Reports.
-
-
I think Jasper is a long term popular solution here.
-
Pentaho is another option. I have only used the ETL part but the suite is large
-
@dave_c said in Opensource BI / Dashboard / Reporting solutions?:
Pentaho is another option. I have only used the ETL part but the suite is large
Oh yeah, I was trying to think of that one.
-
ELK - ElasticDB search - Logstash - Kibana?
-
@xstorm said in Opensource BI / Dashboard / Reporting solutions?:
ELK - ElasticDB search - Logstash - Kibana?
Just the Kibana piece in that case, I think.
-
@dafyre said in Opensource BI / Dashboard / Reporting solutions?:
Is Grafana actually something that could work for you? If you're looking more for reporting, you could check out Jasper Reports.
Dashboards yes. You can do live reports with grafana within a certain time but a reporting tool might be better for reports specifically.
-
So I know I've looked at Grafana before, but now that I'm reading into it a bit more on lunch, I don't think Grafana is a BI tool.
Not in a sense that an accounting/sales team could use anyways. Maybe but it really looks more like an infrastructure monitoring and reporting tool to watch IT infrastructure.
-
@DustinB3403 said in Opensource BI / Dashboard / Reporting solutions?:
So I know I've looked at Grafana before, but now that I'm reading into it a bit more on lunch, this I don't think Grafana is a BI tool.
Not in a sense that an accounting/sales team could use anyways. Maybe but it really looks more like an infrastructure monitoring and reporting tool to watch IT infrastructure.
It will graph any time series data (even non time series but it's a little different). We used it for a lot at the last place I worked. We even used it as a dashboard for Graylog instead of using their own dashboarding. So anything you can log (as in collect data on) you can present.
-
@stacksofplates what sources were you feeding into it?
-
@DustinB3403 said in Opensource BI / Dashboard / Reporting solutions?:
@stacksofplates what sources were you feeding into it?
Mostly Elasticsearch, but you can feed quite a few different types of databases into it.
-
@DustinB3403 said in Opensource BI / Dashboard / Reporting solutions?:
So I know I've looked at Grafana before, but now that I'm reading into it a bit more on lunch, I don't think Grafana is a BI tool.
Not in a sense that an accounting/sales team could use anyways. Maybe but it really looks more like an infrastructure monitoring and reporting tool to watch IT infrastructure.
Yes, I found weird to find Grafana as an suggestion for cross tab reports created by non-technical users.
-
@dave_c said in Opensource BI / Dashboard / Reporting solutions?:
Yes, I found weird to find Grafana as an suggestion for cross tab reports created by non-technical users.
Yeah, what I saw for grafana was mostly heatmap, uptime, system performance type metrics.
Rather than the types of BI graphs one would expect from a Accounting/Sales teams which would show profit, costs, etc.
-
I forgot to mention the other big option along with Jasper and Pentaho: Spago BI now known as Knowage
Edit: going back to school so I can learn to type.
-
@DustinB3403 said in Opensource BI / Dashboard / Reporting solutions?:
@dave_c said in Opensource BI / Dashboard / Reporting solutions?:
Yes, I found weird to find Grafana as an suggestion for cross tab reports created by non-technical users.
Yeah, what I saw for grafana was mostly heatmap, uptime, system performance type metrics.
Rather than the types of BI graphs one would expect from a Accounting/Sales teams which would show profit, costs, etc.
I'm not going to keep harping on it. You guys can come to whatever conclusion you want. I specifically mentioned for dashboards
Dashboards yes. You can do live reports with grafana within a certain time but a reporting tool might be better for reports specifically.
And here's a tool that specifically holds data so you can use Power BI and Grafana together. https://panoply.io/integrations/grafana/power-bi/
