Introduction
Prerequisites
What do I need ?
Both users and developers should be familiar with dbt and Power BI. If you are not, we recommend that you read the dbt documentation before going any further.
Taming the dbt wilderness 🦬
I haven't finished reading the Internet yet, but I have curated a list of resources that I found useful to get started with dbt.
- 🦔 dbt fundamentals
- 🦅 Advanced dbt
It could be useful to know a little bit about these technologies too.
- Git because even if not everyone is building a kernel, a version manager always comes in handy
- Ubuntu some good stuff might come for free ;)
- YAML a human-readable data-serialization language. Like JSON but worse.
- SQL Structured Query Language. The language used to query the database.
- Python dbt is built in Python, so you might want to have a look at it.
- Poetry but let's face the truth... pip is garbage. So we ditched it for Poetry
Your own personal Linux
dbt and Git are easier to use with Linux than with Windows. If you don't have access to a *nix machine you can experiment with, you should set up your own personal Linux with Windows Subsystem for Linux (WSL).
How to setup WSL ?
It's paramount that you follow the instructions for Windows Subsystem for Linux Version 2. The first version was buggy as hell.
You won't necessarily need Ubuntu's GUI to work, but that's great knowledge anyway.
We advise using Ubuntu, but you will be at ease with any distro, provided you know how to use it.