Schema
Data Model for Requisition-based Reports
- Flatten into four requisition tables, base tables
- Create three materialized views from which the indicators are built, from base tables
- All charts and dashboards can use the materialized views
- The materialized views were created for the three requisition reports identified in Gap project
Indicator Queries
Created dashboards
Superset is not a report building tool, but a dashboard building tool
Report vs. dashboard
- Report is entering parameters, then running a report
- Dashboard is seeing all of the data immediately then filtering as needed
Can download a CSV from a SQL query
Superset overview
- Sources → Tables, to see a list of tables in the postgres db
Translations
- New dashboard labels would have to be manually updated in Superset
- Only supports one label per column, we would have to choose one language for the dashboard