1. Installation Instructions

Power BI

This project requires downloading Power BI desktop: https://www.microsoft.com/en-gb/download/details.aspx?id=58494

As it is only available in Windows machines, users of other operating systems will want to download the program in a virtual machine, such as Azure's Windows VM.

Connecting to Azure SQL Server: SQLTools

Later in the project, we will be connecting remotely to a database stored in Azure's cloud platform. The user may want to download VSCode and the SQLTools extension for this purpose.

The database in stored in Azure PostgreSQL database cloud platform. To connect to it, I established a new connection in SQLTools (inside VSCode), by providing the credentials obtained from AiCore.

Automating SQL queries with psycopg2

Optional: The user may want to install the psycopg2 library to automate SQL queries with python:

conda create -n my_env
conda activate my_env
conda install pip
pip install psycopg2

Or alternatively:

python3 -m venv my_env
source my_env/bin/activate
pip3 install psycopg2