regarding reporting tools, I know quite a lot of large comercial reporting tools (I have experience with MicroStrategy, IBM Cognos, etc). I’ve also seen Tableau and Looker being used, they are both commercial and market leaders in BI.
Googling for open source tools the ones that appear in most lists are:
- metabase - looks like this one is full open source, not a community edition like the others
- knowage
- pentaho
- jaspersoft (java based)