Define it once.
Trust it everywhere.

Notes on governed analytics, semantic layers and building with AI.

I'm Waylon Sittampalam, an analytics engineer in Cary, NC. When "revenue" means five different things across five dashboards, nobody trusts the number. I define each metric once, as code in a semantic layer, so a dashboard, a notebook and an AI agent all return the same answer, and every answer can be checked.

revenue = one definition
Define the metric once; the dashboard, the notebook and the agent all read the same definition.

Writing

All writing →

Projects & dashboards

Moving BI models to a new warehouse without anyone noticing

I moved production Power BI models from Synapse to Snowflake's gold layer. Same numbers, same security, same reports. Because the models lived as code in Git, a fix found in one could be rolled out to all of them.

Data migration · Metrics-as-code · Fix once, apply at scale · CI/CD · Automated parity testing

A bean roasting copilot

I'm still new to roasting coffee, and there's too much to watch at once. So I built a copilot that tracks the roast for me and tells me what to do next, based on the bean and the plan I set beforehand.

Hardware integration · LLM tooling · Safety checks · Python

Family Learning Tracker

A small private app that turns my kids' school curriculum into daily practice. They answer in the app, it works out why a wrong answer was wrong, and the next day's questions go after exactly that.

AI product design · Structured LLM outputs · Human-in-the-loop · Claude API

Claims trend (D3)

An Astro page with D3 bundled from npm: monthly claims with a fraud-rate overlay, hover tooltips and a metric toggle.

Data visualisation · D3.js · Interactive analytics

Claims KPI dashboard (sample)

A self-contained HTML dashboard where every KPI shows its governed definition next to the number.

Governed metrics · Metric definitions · Dashboard design