Kay Abraham

Local time in Prague:

002 Machines 04 / 07

Margin rebuild

Finance's gross margin report, rebuilt from the raw warehouse tables and matched to the cent. Then a company report on the Business plan pool: health, margin, leaks, projection.

Status
Done
Since
Done October 2026
Built with
SQL on Snowflake

01 The miss

The team's numbers didn't match Finance's.

Corrected Margin rebuild K.A.

02 The machine

SQL on Snowflake. Three raw warehouse tables, joined and reconciled until the result matched Finance's gross margin report to the cent. Then a company report on the Business plan pool: health, margin, leaks and projection, on one page.

03 How it runs

  1. 01 Tables Three, raw, from the warehouse
  2. 02 Reconcile Join, compare, repeat
  3. 03 Match To the cent
  4. 04 Report The Business plan pool

04 What changed

  • One set of numbers for the team and Finance.
  • A company report on the Business plan pool: health, margin, leaks, projection.

05 What I can show

This page describes the method. The numbers stay inside the company.