AI workflows & prompting
Prompts, agent harnesses like Claude Code, and review habits for AI-assisted analytics.
-
MCP servers for data work
What the Model Context Protocol is, how Claude Code connects to MCP servers, three patterns for analytics teams (read-only database access, documentation lookup and ticketing), and the governance that has to come first.
-
Choosing a Claude model and effort level for analytics work
How to pick between Fable, Opus, Sonnet and Haiku and between effort levels for lookups, routine SQL, hard debugging and long builds, and how to make the choice a habit.
-
Reviewing AI-written DAX and SQL
A review checklist for AI-generated SQL and DAX, with wrong and right pairs for each trap and a small fixture that catches the mistakes before a stakeholder does.
-
Subagents and parallel work in Claude Code
When to split work across Claude Code subagents, how to brief them, how to stop them racing each other, and how to check the result before anything ships.
-
Prompting for analysts
Prompt patterns that get usable SQL, DAX, and analysis out of a language model, the anti-patterns that waste time, and before-and-after prompts to adapt.
-
Writing CLAUDE.md and AGENTS.md for analytics repos
What belongs in a project memory file for a coding agent, what doesn't, how Claude Code chooses between CLAUDE.md and AGENTS.md, and two worked examples.
-
A Claude Code workflow for analysts and BI developers
Set up the project, keep a short memory file, plan before building, fence the agent into a virtual environment and a branch, and let tests and linters decide when it's done.
-
Claude Code hooks for analytics repos
How Claude Code hooks work, from events and matchers to exit codes and blocking, and five hooks for a data repository that lint Python and SQL, run fast data tests, protect generated and production files, keep secrets unread and log every command.
-
Evaluating LLM features with a test set
How to build a labelled evaluation set before shipping an LLM feature, choose metrics that match the risk, catch regressions when prompts or models change, and keep clinical text governed throughout.
-
Skills for repeatable analysis in Claude Code
What a Claude Code skill is, how it loads, how to write a description that makes it trigger at the right moment, and two complete skills for analytics work, one that profiles a new table and one that reviews a DAX measure.