Data & BI
Data engineering and BI write-ups: auditing marketing data, building a warehouse people trust, and dashboards that lead to decisions.
Posts about Data & BI
Non-brand clicks are the SEO number that matters
+183% non-brand clicks
Five bugs a data audit caught before anyone made a decision on them
2.00× → 1.00× Meta lead count
Mapping a whole market when the API stops at 60 results
1,176 firms mapped in Mumbai
The shared token that switched off the website’s leads
~30 min website leads stopped, once
Planning billboards around where the leads are
93 sites geocoded from a spreadsheet
A 15-minute warehouse that runs on one PC
15 min refresh, while the PC is on
An ads agent that grades its own advice
≤ 8 recommendations per weekly run
One meaning per number, so the screens stop arguing
54 metric formulas, one definition each
A nightly sync that survives its own failures
16 of 25 steps that can fail without stopping the run
A phone page that tells consultants who to call next
7 days with nothing logged puts a deal on the list
Don’t let the LLM do the maths
~255 lines of Python maths moved to SQL