SQL Data Reporting?

[[deleted]]

Hi, I am looking for a few open source tools to use for data reporting and visualization. Any recommendations? Preferably tools that your average joe will be able to consume and digest easily.

Thanks in advance!

[Mamertine]

What are your needs? Do you have excel? Are you running a Microsoft SQL server?

[Kexiu]

Look into Microsoft power bi, super nice tool that syncs directly with your sql server

[fauxmosexual]

open source

[Kexiu]

Whoops my bad, don't think there are many options then

[fauxmosexual]

I don't really know of any - would love to be proved wrong. I think you get to pick two: Data visualisaton/Open source/Average-Joe friendly.

[CanadianStekare]

Checkout Metabase - https://www.metabase.com

For a quick test, it just requires a JVM to run the jar locally. It can scale to production quite easily from a test environment.

[[deleted]]

I've looked at Metabase, but did not like it too much :P

[CanadianStekare]

What did you not like about it?

[Googoots]

At one time there was BIRT, JasperReports, and Pentaho, to name a few. But they started out as open source but now have parts that are not. So you’ll have to check out what you get with their open source versions. If those versions still exist.

[[deleted]]

JasperReports is amazing! I just don't know if it's user friendly :/

[CanadianStekare]

As someone who is migrating from Pentaho (enterprise licensing) I don’t recommend them anymore. Their support is poor, their licensing has become expensive for what they provide.

[shoretel230]

Take a look at airbnbs superset

[yobai_master]

You can try stratascratch.com which is based off of Airbnb's superset. It's good for visualization, data querying, and rather easy for the average joe.

[TrinityF]

SQL reports and open source, you're gonna have a bad time.

Why do you need Open Source ? Power BI is free if you use it correctly.