Metabase – can be a good first step to share access to data in a friendly way, however with growth of data volume it becomes not so convenient.
Specifically for dashboards building, without too much actual coding involved there are low code solutions:
- Appsmith – open source and can be self hosted and customized (via js code)
- Retool – allow to define complete workflow with necessary aggregation but will charge you some fee
Sure, you can start with old school
jinja templates and plug something like
Vega (declarative language and d3.js for visualization) on top of pre-computed aggregations to render static graphics via REST API.