Skip to content
Anil Thapa

Case studies and essays

Writing

Platform and team decisions, written up for anyone paying for a data platform or building a career on one. Case studies take one decision each, and the essays carry the patterns further. Start with the subject you are deciding about.

By subject

Case studies

One decision each, in the same six sections: situation, constraint, decision, the tradeoff I accepted, outcome, and what I would do differently. Observed changes are separated from the criteria I recommend, and published industry examples are credited to their sources.

01
  • Org design
  • Platform strategy
  • Enablement

Greenfield data function, analysts embedded across departments

Building a data function from zero

Building a central data function from zero: org design, hiring, and centralizing scattered analysts without becoming the bottleneck.

02
  • Exec partnership
  • Stakeholder alignment

Executive partnership across departments and at board level

Data in the boardroom

What changes when data reaches the executive table: leading with the decision, showing uncertainty, and keeping the seat.

03
  • Architecture
  • Governance
  • Enablement
  • Platform strategy

An AI assistant for self-service, on a governed data layer

What the assistant was allowed to know

Launching an AI analyst against a real warehouse: metrics as tools, a knowledge base of business context, and a feedback loop that became the eval set.

04
  • Data quality
  • Governance
  • Stakeholder alignment

Data quality and reliability as an operating discipline

Earning trust in the numbers

How trust in a data platform is lost, slowly or all at once, the four failure modes that break it, and how to run an incident well.

05
  • Governance
  • Stakeholder alignment
  • Data quality

Marketing and payment attribution across teams that each kept a version

One customer, four acquisition stories

Attribution as a definition problem: four teams, four acquisition stories, and why named measures with owners beat a single blended number.

06
  • Architecture
  • Platform strategy
  • Stakeholder alignment

Modernizing a warehouse that had fallen behind, while reporting continued

Move the decisions, not the tables

Modernizing a warehouse that had fallen behind: migrate by the decisions reports serve, run two platforms deliberately, and retire what nobody would miss.

07
  • Architecture
  • Governance
  • Stakeholder alignment

Warehouse consolidation across mergers, silos, and migrations

One number, two histories

Consolidating warehouses after mergers, silos and migrations. Why definition reconciliation is the project and pipelines are support.

08
  • Architecture
  • Data quality
  • Platform strategy

Ingestion rebuilds across heterogeneous sources and warehouses

Rebuilding ingestion people trust

Rebuilding data ingestion: choosing the integration approach, reconciling sources that disagree, and proving it by parallel run.

09
  • Platform strategy
  • Governance
  • Exec partnership

Platform cost governance and capacity decisions

What the platform costs

What a data platform costs and who decides: cost attribution before optimization, and which inefficiencies to leave alone.

10
  • Org design
  • Governance
  • Enablement
  • Platform strategy

Central platform team federating ownership to domain analysts

Giving the models away

Federating model ownership to analysts: what a central data team gives up, what it gets back, and the guardrails that make it safe.

Essays

October 2026

Leading data teams

The team moves and the failure stays

Moving a data team out of IT helps only when it changes what the team is measured on, who may decline a request and who pays for the engineering.

Leading data teams

An interview that asks for a decision

Hiring for judgment in data: an interview built around one bounded decision, what to listen for, how to score it, and what the format costs.

Leading data teams

Count the decisions, not the dashboards

The evidence of judgment in a data career is a record of decisions, not deliverables: four columns to keep, how to read them, and what the log costs.

Trust & governance

After the wrong number has been used

After a data error reaches a decision, fixing the number leaves work unfinished. Trace its use, correct the record, and return the choice to its owner.

September 2026

Architecture & economics

What a faster refresh actually buys

When fresher data changes a decision: price the full operating promise, account for late records, and choose which workloads need the speed.

Leading data teams

Too many priorities, none of them yours

A data team whose roadmap is other people’s requests needs a remit, not a better scoring model: one sentence, used to decline one thing.

Agentic & AI systems

The dashboard stopped one step short

Dashboards show the number and stop. AI briefings add the reason and a next step. How to keep the numbers governed and the reasons checkable.

Leading data teams

When every decision still needs you

Developing judgment in a data team: delegate a bounded decision, review the reasoning, and help someone lead without quietly taking the work back.

Data in the business

Data-driven is a discipline, and it lapses

A testable definition of data-driven, five rungs named for what happens when a number and an opinion disagree, and how decision habits connect to tooling.

Architecture & economics

The tools I use

A current data toolkit paired with the 2025 list so the drift shows. The core barely moved, and part of it is no longer data tooling at all.

Data in the business

Recommendations that go nowhere

Why sound analysis produces recommendations nobody acts on, and the rewrite that fixes it: name the decision, offer an alternative, state a condition.

Agentic & AI systems

An analyst in the chat window

Rolling out an AI data assistant in the team chat tool: why to start narrow, recruit people to break it, and what it exposes about the questions.

Data in the business

Four habits of a self-service analyst

Self-service analytics fails on habits, not access. Four questions that separate answers from charts, and a worked example of a conversion drop.

Data in the business

What BI means, revisited

Three passes at defining business intelligence, over five years. The definition held. The bottleneck moved from access to trust.

Leading data teams

Who owns the model?

Handing dbt model ownership to analysts is a governance change, not a tooling one. Why the question is now authorship, and what the move cost.

Data in the business

Built, launched, ignored

Most dashboards end up ignored. Why that is the default outcome, what moves one from decoration to a decision, and what the fix costs.

Archive, 2021 to 2025

A selection of 6 pieces from my previous blog, including a merged reference on SQL Server performance from back when I was in the engine daily. Dated, preserved, and not current thinking.

Browse the archive