Setup an .env file

Run the following commands in order:

python -m venv .env-analytics

sudo apt-get install libpq-dev

source .env-analytics/bin/activate

pip install -r requirements.txt

streamlit run MgvAnalytics.py

All the queries are stored in the queries/ folder. They are ran with execute_query_from_file function in database_connection.py

Each page needs to be created in the pages/ folder.