I want to use the best analytics engineering tool on the market – dbt from Fishtown Analytics.

myBI uses Azure SQL as a backend to store collected data in. It requires additional actions and steps to perform:

1. Use official image from Fishtown Analytics with latest dbt version 0.19.1
2. Install dependencies: MS SQL utilities as well as dbt-sqlserver package
3. Configure dbt to use profiles file (connection strings) in the project root directory

https://kzzzr.github.io/CORE-DWH-building-a-common-foundation/