All Articles & Tutorials
Explore practical guides, step-by-step masterclasses, and foundational definitions across AI, SQL, and data systems — written in plain, human English.
All articles
How to ask better data questions in meetings
Ask data questions that name the decision, window, segment, and success criteria. Use a question ladder so meetings end with an answerable next action.
How to build and test your first data models with dbt, a SQL tool
Turn layout into working models. Write your first staging and mart SQL, wire refs, add unique and not-null tests, and run a small build you can actually explain…
How to calculate a conversion rate correctly
Write conversion as success over eligible with a clear window. Definition cards beat dashboard magic when the same funnel stage means three rates.
Data warehouse, data lake, or plain database: which one does your data need?
App database, warehouse, or lake? Walk a plain decision tree for where data should live so product traffic, cheap history, and certified analytics stop fighting over one system.
How to pick an AI coding assistant like Claude Code or Codex, and use it well
For coding help, pick one AI surface, keep changes on one branch, list the folder, and re-run the failing command yourself. Agents multiply mistakes when nobody owns the…
