Category: Tutorials
You are in the right place if you want a lesson you can follow, not a glossary and not a product homepage. This shelf holds most of the articles on Analytics Made Simple. Two paths sit inside it on purpose. SQL is the database path: you have rows, and you need to ask a question without exporting another spreadsheet. AI is the tool path: chat products, open-weight models, and the jobs those tools are actually good at. Other tutorials land here when they teach a skill that does not belong on a narrower shelf.
A category page is the pile. A series page is the path, with a place to start and an order. If you open a tag or page 2 of this list, you are in a filing cabinet. The lesson is the article, or the series hub that lines the articles up.
Where to start: if the pain is a table, open the SQL series and use the first part on that page. If the pain is a model name or a chat tool, open the AI category and pick the product you already have on screen. If you are not sure which job you have, open Learn and choose the track that matches the work, not the logo.
What is a data contract?
A data contract is an explicit agreement between data producers and consumers on schema, meaning, quality, and delivery. Learn the pieces, a worked example, and when contracts beat…
dbt lab: reviewing a model like a PR
Review dbt model PRs for grain, joins, filters, tests, docs, and blast radius. Green CI means the files compile. It does not mean the metric is safe for…
Leading vs lagging indicators
Use lagging indicators for outcomes and leading indicators for early warning. Put both on the review so a green result tile cannot hide a thin pipeline.
Reproducibility for solo analysts
Solo analysts still need reproducibility: fixed inputs, pinned environments, clear parameters, and a re-run path so last quarter’s number can be explained without archaeology.
The analysis PR checklist
An analysis PR checklist turns “looks good” reviews into real quality gates: question, grain, filters, lineage, tests, and narrative before anyone merges a metric change.
