A personal finance tracking dashboard built with Apache Superset, providing insights into cashflow, spending patterns, and goal progress.
# Build custom Superset image
docker build -t superset-custom .
# Start all services
docker compose up -d
# View logs
docker logs superset_app -f# Enter the container
docker exec -it superset_app bash
# Initialize the database
superset db upgrade
# Create admin user
superset fab create-admin \
--username admin \
--firstname Admin \
--lastname User \
--email [email protected] \
--password admin
# Initialize Superset
superset init
# Exit and restart
exit
docker restart superset_appWhen adding/editing your database connection in Superset, check Advanced → Security settings:
- Uncheck "Allow DDL" and "Allow DML" if you want read-only access
- Ensure "Allow this database to run non-SELECT statements" matches your needs
docker compose down -v # -v removes volumes
docker compose up -d --builddocker build -t superset-custom .
docker compose down
docker compose up -ddocker restart superset_app superset_celerydocker exec -it superset_app rm -f /app/superset_home/initialized
docker restart superset_appdocker compose down -v # Removes all volumes
docker compose up -d# Check uv installation
docker run --rm -it apache/superset:latest which uv
# List virtual environment binaries
docker run --rm -it apache/superset:latest ls -la /app/.venv/bin/| Feature | Description |
|---|---|
| Monthly Cashflow Trends | Track income vs expenses over time |
| Category-wise Breakdown | Visualize spending by category |
| Payment Method Analysis | See which payment methods are used most |
| Goal Progress Tracking | Monitor progress toward financial goals |
├── dashboard/
│ └── expense_dashboard.json # Superset dashboard export
├── Screenshots/
│ ├── Dashboard.jpg # Main dashboard view
│ └── Goals.jpg # Goals tracking tab
└── README.md
docker exec -it superset_postgres psql -U superset -d superset
docker exec -it superset_postgres psql -U superset -d superset -W
docker exec -it superset_postgres psql -U superset -c "ALTER USER superset PASSWORD 'superset';"
MIT