Gaborone, Botswana • Data Engineer & AI Creator

Hi, I'm Sandile. I engineer data systems, build AI automations, and share the journey.

Business Intelligence Consultant & First-Class Honours graduate exploring the intersection of enterprise data architecture, practical Business AI Automation, and building a life in tech.

1.7B+ Records Automated across 3 countries
1st Class Honours BSc (Hons) BI & Data Analytics (6 Distinctions)
30+ Pipelines & AI SQL, Power Platform, Python & AI Workflows
Sandile Desmond Mfazi
Currently Building Enterprise BI pipelines at UGT + launching my Business AI Automation YouTube channel
What I Do & Create

Bridging enterprise data engineering with practical AI automation.

My day job is building large-scale data warehouses and BI systems across Southern Africa. Outside of that, I build AI workflows, write about systems thinking, and am preparing to document it all on YouTube.

01 • Business AI Automation

AI Agents & Workflows

Designing practical AI agents, automated pipelines (Power Automate, Make, n8n, Python), and LLM integrations that eliminate repetitive operational busywork.

n8n / Make Power Automate LLM Agents
02 • Data & Analytics Engineering

Enterprise Data Systems

Building end-to-end data warehouses, SSIS & Azure Data Factory ETL pipelines, and governed Power BI semantic models across finance, retail, and agriculture.

SQL Server / SSIS Power BI / DAX BigQuery / Azure
03 • Personal Life & Building in Public

Tech, Systems & Life

Documenting life in Gaborone, continuous learning after a First-Class Honours degree, Notion productivity workflows, and launching a creator brand from scratch.

Notion Certified Gaborone, BW YouTube Prep
The AI & Tech Blog

Latest Writing & Field Notes

View All Posts →
Channel In Production • Coming Soon

The YouTube Channel: Business AI Automation, Tech & Life

Inspired by practical, no-fluff AI builders like Nate Herk, I'm launching a YouTube channel dedicated to step-by-step Business AI Automation tutorials, real-world data engineering breakdowns, and honest stories about building a career in tech from Gaborone.

3 Core Channel Themes
  • 01. AI Automation Builds: Agents, n8n, Make, Power Automate & LLM workflows.
  • 02. Data & Tech Stack: SQL Server, Python, Power BI & cloud architecture.
  • 03. Personal & Systems: Notion setups, career lessons & life in Botswana.
Experience & Background

Career Snapshot

Full Interactive CV →
March 2025 – Present • Gaborone

Junior Business Intelligence Consultant

UGT — Analytics Training & Consulting

Engineered 30+ automated SSIS ETL pipelines and 28 SSAS Tabular Cubes, optimizing 1.7B+ records across 47 compressed tables for operations across Botswana, South Africa, and Zambia.

Apr 2024 – Nov 2024 • Remote

Power BI Expert & Data Analyst

Upwork — Verified Freelancer

Delivered custom BI solutions, DAX semantic modeling, data quality frameworks, 3-page executive KPI dashboards, and rapid SQL dataset analyses for international clients.

Feb 2023 – Aug 2023 • Gaborone

Business Intelligence Attachment

First National Bank of Botswana (FNBB)

Developed database tables and automated ETL processes using SQL Server Full Stack (SSIS, SSAS, SSMS) and Python, achieving 100% on-time delivery for paginated stakeholder reports.

Graduated 2024 • Gaborone

BSc (Hons) Business Intelligence & Data Analytics

Botswana Accountancy College / University of Sunderland

Awarded First-Class Honours (1:1) with all six distinctions, alongside Google Data Analytics and Notion Certified (Essentials, Workflows, Advanced) credentials.

Selected Work

Featured Projects & Deep Dives

Explore All Projects →
Enterprise Data Engineering

115M+ Record History Reconstruction

Parsed 115M+ flattened audit logs and automated 30+ SSIS pipelines across Botswana, South Africa, and Zambia with country-level Row-Level Security.

Read Case Study →
Serverless Cloud Portal

Real-Time Livestock Logistics App

Replaced vulnerable paper field logs with a serverless Google Apps Script, BigQuery, and Looker Studio pipeline syncing in under 60 seconds.

Read Case Study →
Interactive Lab

Governed Power BI Semantic Layer

Audited fragmented Excel metrics and unified Finance, Sales, and Marketing KPIs inside a documented, Git-ready Power BI Semantic Model.

Open Interactive Lab →
Free Weekly Notes & Templates

The AI & Systems Dispatch

Get practical Business AI Automation blueprints, SQL & Power BI engineering notes, and an alert the day my first YouTube videos go live.