What are the Open source solutions for creating an interface that allows you to create various kinds of reports and prepared sources of information?

Question

Database

Good afternoon, please tell me, there is a database consisting of several tables, all these tables are interconnected by keys, i.e. everything is perfectly normalized.
Are there such solutions in nature that allow users who are far from programming and compiling SQL queries to collect a report at the interface level, as it were, adding all sorts of filters, sorting, output fields, etc. with the mouse?
Those. roughly speaking, on ready-made database tables, click on various types of reports, which could then be saved and used in the future

Answer 1

Such things are called - BI tools and cost money. Bright representatives are PowerBI and Tableau. You can look for analogues, but I do not flexibly believe in success

Answer 2

The free solution is cross-platform, it comes with a test data set, selections, dashboards, saving queries, connecting several databases, the ability to provide access to colleagues with flexible privacy settings.
https://www.metabase.com/