Blog
Home/Blog
Notes on Power BI, Microsoft data architecture, M-Pesa integrations, and building useful software for African businesses.
Power BI Dashboard Audit Checklist: Fix These Before You Rebuild Reports
A practical audit checklist for teams with messy Power BI reports, slow refreshes, unclear KPIs, manual Excel exports, and untrusted numbers.
Excel to Power BI: How to Move From Manual Reporting to Automated Dashboards
How to move from copied spreadsheets and manual monthly reporting to Power BI dashboards with Power Query, semantic models, scheduled refresh, and governed KPIs.
How to Build a Power BI Semantic Model Business Teams Can Trust
A practical guide to building trusted Power BI semantic models with star schemas, clean relationships, reusable DAX measures, date tables, KPI definitions, and row-level security.
Power BI Is Not the Data Architecture: What a Complete Microsoft Data Stack Includes
A Power BI dashboard is only the visible layer. The real system includes source mapping, ingestion, storage, semantic models, governance, refresh, and delivery across Microsoft Fabric and Power BI.
Claude Opus 4.7 Is Running the GPT‑5 Playbook — And It Shows
Opus 4.7 is better at coding, harder to prompt, and slower. Adaptive thinking isn’t just a feature — it’s compute rationing, same as OpenAI’s GPT‑5 router. Here’s how to prompt 4.7 and what it means for the Mythos rollout.
How to Install Claude’s Frontend Design Skill (And What It Actually Does)
A trending Claude Code plugin that stops the AI from producing generic “AI beige” interfaces. Two commands to install, plus before/after examples from Anthropic showing exactly what changes.
M-Pesa Paybill Has Two Accounts Inside It — And Nobody Tells You
A single M-Pesa Paybill shortcode has two separate accounts: Working and Utility. Understanding how money flows between them is the key to making B2C disbursements work. Here’s the full breakdown and how Business One Account fixes it.
How I Fixed M-Pesa Daraja API Error 404.001.03 on B2B — It Wasn’t My Code
If your B2B or B2C requests are returning 404.001.03 (Invalid Access Token) after going live, stop debugging your code. The problem is almost certainly that Safaricom hasn’t whitelisted B2B/B2C on your shortcode.