Articles, Case Studies & Live Demos
AI Service Providers in Cape Town: A Buyer's Guide for Business Article
Who actually ships AI in Cape Town for business use? We mapped the landscape: hyperscalers, specialist consultancies, vertical players, and the compliance gap nobody fills. Here is who does what, what it costs, and which choice survives an audit.
I Asked ChatGPT What It Knows About Me. I Wish I Hadn't. Article
ChatGPT's memory builds a dossier on you, line by line. I asked it to tell me everything. It knew my salary, my wife's health condition, the product I was building, and the exact phrasing of an argument I had with my co-founder. None of this was in my settings.
You Just Gave Your Competitor's AI Your Pricing Model Article
Samsung engineers pasted source code into ChatGPT. An Apple employee uploaded confidential product details. A pharmaceutical researcher ran clinical trial data through a public model. These are not hypotheticals. They happened. Your firm is next.
AI Knows Your Customer Better Than You Do. Someone Is Exploiting That. Article
Give ChatGPT a customer's chat history and ask it to build a persuasion profile. It returns a psychological blueprint: their motivations, their decision triggers, their objections, and the exact phrasing most likely to close them. Someone in your industry is running this prompt. It is not you.
Your Customer Support Tickets Are Training Data. You Cannot Opt Out. Article
Amazon warned employees not to share code with ChatGPT. Apple banned it. Verizon blocked it. Yet your support team pastes customer tickets into it every day. Here is where that data goes, what it trains, and why you will never get it back.
I Extracted a Company's Entire Strategy With One Prompt. They Handed It to Me. Article
No hacking. No phishing. No breach of any system. I asked ChatGPT to write a competitor analysis of a firm that has been using AI internally for two years. The model returned their org structure, their pricing logic, their talent gaps, and the product they are building next quarter.
Extracting HotSpotter From 15 Years of Wildbook IA Case Study
How we untangled a wildlife identification pipeline from a 20 GB legacy monolith and turned it into a reusable, parity-tested Python library without rewriting it from scratch.
Untangling HotSpotter From 15 Years of Wildbook Article
We are extracting the core wildlife identification algorithm from a 20 GB legacy Docker image into a reusable library. This post explains the plan, the risks, and why we are not doing a rewrite.
PostgreSQL for BI Dashboards Article
Your dashboards are slow because your queries are slow. PostgreSQL can handle BI workloads. You need the right indexes, materialized views, and connection pooling.
Data Analytics for African Business Article
Cloud hosting in Africa, data residency requirements, mobile-first dashboards, and the tools that ship. What works in Lagos, Nairobi, Johannesburg, and Cape Town.
Cut Client Inquiry Calls by 90% Case Study
Crossroads Health's provider portal went from monthly PDFs to live Metabase dashboards. The architecture, the RBAC model, the HIPAA compliance layer, and the results.
The True Cost of Building Analytics In-House Article
Charts library, backend data layer, auth, RBAC, embedding, maintenance. We priced it out. Building analytics from scratch costs 3-5x what teams budget. Here's the breakdown.
Real-Time Data Pipelines for Business Article
Python ingestion, InfluxDB time-series storage, Grafana dashboards. The architecture we use to stream live F1 telemetry — and how the same pattern applies to logistics, IoT, and SaaS.
10 SaaS Metrics Every Dashboard Needs Article
DAU/WAU/MAU, MRR by plan tier, trial-to-paid conversion, churn signals. The metrics that matter, the SQL to query them, and how to surface them in Metabase or Grafana.
Building HIPAA-Compliant Analytics Article
PHI in dashboards. Row-level security. Audit trails. What Metabase gives you and what you have to build yourself. Hard-won lessons from deploying analytics in healthcare.
How to Embed a Metabase Dashboard Article
JWTs, iframes, RLS. Metabase embedding your clients will trust.
Metabase vs Grafana vs Superset Article
Three open source BI tools. Three different philosophies. We've deployed all three in production. Here's where each one wins, where each one breaks, and how to pick.
What Is Embedded Analytics? Article
Embedded analytics puts dashboards inside your product, not a separate tool. Here's why SaaS teams are moving to self-hosted BI, how build-vs-buy shakes out, and what actually ships in production.
SaaS Retention Pulse Demo
Synthetic SaaS data piped through Docker, Python, SQLite, and Grafana. Track DAU/WAU/MAU, MRR, session quality, and conversion flows. Spot the accounts about to leave.
Live F1 Telemetry in Grafana Demo
FastF1 pulls race data. InfluxDB stores it. Grafana renders it. Engineers watch telemetry live and call undercuts before the pit wall does.
AI Market Pulse Demo
Track momentum, liquidity, and volatility across AI chip stocks, cloud platforms, and ETFs. Minute-by-minute data so you see rotation before the news breaks.
F1 Driver Battles, Visualized Demo
75 years of F1 data. Hamilton vs Schumacher. Senna vs Prost. Wins, podiums, and reliability stacked side by side in Metabase.
Subscription + Retail Analytics Demo
One dashboard for subscription revenue and retail sales. CFOs see both streams in real time instead of waiting for end-of-month reports.
Pizza Franchise Analytics Demo
Compare store performance across cook times, delivery speed, and regional demand. Metabase dashboards that show franchise owners where they stand and where to improve.
Crossroads Health: Real-Time Provider Portal Case Study
HIPAA-compliant portal with embedded Metabase dashboards. Cut client inquiry calls by 90%. Healthcare providers saw their credit balance data live instead of waiting for monthly PDFs.
Right Refund: Digital Patient Refunds Case Study
Healthcare providers still mail paper checks. Right Refund sends refunds electronically. Secure, fast, no stamps.
Building a Secure Chat API Article
FastAPI, JWT auth, rate limiting, input sanitization, Discord alerts. The architecture behind a chat API that handles real traffic without falling over.