Superset Dashboard

BI Dashboard

Feature and Objective

Data Visualization

Help stakeholders understand, share and collaborate on the information

purpose-built and designed to analyze data from key datasets

Must be easy to understand at a glance

Different Types of BI Dashboard

Tableua

One of the biggest BI Dashboard but mostly paid plans.

Metabase

A one-click button to deploy and run on heroku is <a href=https://www.metabase.com/docs/latest/installation-and-operation/running-metabase-on-heroku>here.</a>

Superset

You can use as either a docker image file or on a python environment. But I prefer to use in a local python environment. I used python version 3.9.12. Python version 3.10 seems to have dependency error with flask

On local

conda create -n pyenv-superset python=3.9.13
conda activate pyenv-superset
pip install apache-superset
superset db upgrade
export FLASK_APP=superset
superset fab create-admin
superset init
superset run -p 8088 --with-threads --reload --debugger

IF you want to share/deploy it on heroku or other platform Check out git repo.

Shell command

conda create -n pyenv-superset python=3.9.13
conda activate pyenv-superset
pip install apache-superset
pip install psycopg2-binary
pip install cryptography
pip freeze > requirements.txt

Create Procfile

web: gunicorn "superset.app:create_app()"

Create superset_config.py > on my git repo superset-heroku

Shell command

heroku create <app_name>
heroku addons:create heroku-postgresql:hobby-dev
git push heroku
heroku run bash
export FLASK_APP=superset
superset db upgrade
superset fab create-admin
superset init
exit

source

https://www.tableau.com/learn/articles/business-intelligence/bi-dashboards

https://chizurumolorondu.medium.com/setting-up-apache-superset-on-heroku-b547302f600e