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 control system 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 on Linux than on 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 set up 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 for your work, but it's good knowledge to have anyway.
We advise using Ubuntu, but you'll be fine with any distro, provided you know how to use it.