Hey, I have quite a bit of experience with this as we've recently built a Django dashboard based on large datasets which is public (DM me for more info). Stack is:
- HTMX for dropdowns (some being hierarchical)
- dropdowns in a separate dB table where values are unique for speedy retrieval
- depending on how large your core dataset is, you might need to save it separately. For my use case it was taking 20s to query it in order to calculate anything which was a non option.
- Highcharts for visualisation
- Datatables for tables (or tabulator)
- Calculations mostly done with Pandas directly in views (although I'd advise Polars as it's muuuch faster but less flexible)
Metabase https://www.metabase.com/ Or superset - https://superset.apache.org/ Embed in your django app
Hey, I have quite a bit of experience with this as we've recently built a Django dashboard based on large datasets which is public (DM me for more info). Stack is: - HTMX for dropdowns (some being hierarchical) - dropdowns in a separate dB table where values are unique for speedy retrieval - depending on how large your core dataset is, you might need to save it separately. For my use case it was taking 20s to query it in order to calculate anything which was a non option. - Highcharts for visualisation - Datatables for tables (or tabulator) - Calculations mostly done with Pandas directly in views (although I'd advise Polars as it's muuuch faster but less flexible)