Skip to content
View GarethMackenzie's full-sized avatar
🎯
From raw data to better decisions ⚡️
🎯
From raw data to better decisions ⚡️

Block or report GarethMackenzie

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
GarethMackenzie/README.md

Animated analytics signal

Gareth Mackenzie

Data Analyst | Power BI · SQL · Python
I build governed analytics, executive intelligence and automated decision-support systems with a focus on reproducibility, data quality and clear business interpretation.

Johannesburg, South Africa · LinkedIn · Portfolio / author site

Flagship projects

Executive public-data analytics system covering municipal debt, electricity demand, tariffs, financial performance and physical-security risk.

Power BI · PBIP/PBIR · TMDL · DAX · Python · SQLite

Evidence: 40 governed source records · 17 release-blocking data-quality checks · 32 automated tests · 34 explicit DAX measures · 5 report pages · deterministic rebuild validation.

Repository · Actions

Open-source Python CLI for auditing analytics and Power BI repositories before release.

Python · CLI · PBIP/PBIR · TMDL · DAX checks · CI/CD

Evidence: 15 documented release rules spanning repository hygiene, Power BI project integrity, DAX heuristics, security signals, documentation and reproducibility, with console and JSON reporting.

Repository · PyPI · v0.1.0 release

Source-controlled Power BI decision support for synthetic claims performance, financial exposure, service, operations and risk-based human review.

Power BI · PBIP/PBIR · TMDL · DAX · Power Query · Python · SQL

Evidence: deterministic data pipeline · governed star schema · 79 explicit DAX measures · 8 report pages · automated QA · hosted CI.

Repository · Actions

Portfolio projects use synthetic or public data and are designed to demonstrate engineering and analytical methods. They do not contain customer, policyholder or employer-confidential data.

Additional systems

  • Banking Process Excellence — Lean Six Sigma DMAIC analytics for a fictional retail-banking onboarding and KYC process using synthetic data. Python · DMAIC · SPC · MSA · DOE · Regression · CI
  • Motor Claims Risk Triage — capacity-constrained machine-learning review prioritisation using synthetic claims data and leakage-safe evaluation. Python · scikit-learn · XGBoost · Decision Science · CI

Engineering capability

  • Analytics Engineering — reproducible pipelines, dimensional modelling, governed transformations, data-quality controls and CI.
  • Business Intelligence — Power BI, semantic modelling, DAX, Power Query, PBIP/PBIR and executive decision support.
  • Data & Automation — Python, SQL, deterministic workflows, validation and release automation.
  • Decision Science — statistical analysis, hypothesis testing, ranking metrics, human-in-the-loop workflows and responsible model governance.
  • Process Excellence — Lean Six Sigma, SPC, MSA, DOE, root-cause analysis and operational improvement.

Technical stack

Core: Power BI · SQL · Python · DAX · Power Query
Data & modelling: SQLite · dimensional modelling · TMDL · PBIP/PBIR
Engineering: Git · GitHub Actions · CI/CD · automated QA · reproducible builds
Analytics: statistical testing · predictive modelling · process analysis · decision support

Professional context

My background combines financial-services and insurance operations with analytics engineering, process improvement, internal controls and risk-aware decision support. I focus on translating operational problems into measurable analytical systems that can be reviewed by both technical and business stakeholders.

For full career chronology, see LinkedIn.

Education & selected credentials

  • University of South Africa (UNISA) — Bachelor of Business Administration
  • Microsoft Certified: Power BI Data Analyst Associate
  • Microsoft Certified: Azure Data Scientist Associate
  • Oracle Cloud Infrastructure Data Science Professional
  • Oracle Analytics Cloud 2025 Professional
  • Lean Six Sigma Black Belt

Connect

LinkedIn · GitHub · Website

Pinned Loading

  1. insurance-claims-intelligence-powerbi insurance-claims-intelligence-powerbi Public

    Executive-grade Power BI insurance claims analytics portfolio featuring PBIP, TMDL, DAX, Power Query, SQL, synthetic data quality, financial exposure and risk-based review prioritization.

    TMDL

  2. motor-claims-triage motor-claims-triage Public

    Machine-learning claims risk triage using Python, leakage-safe modelling, ranking metrics, lift analysis, testing and human-in-the-loop review prioritisation.

    Python

  3. banking-process-excellence-lean-six-sigma banking-process-excellence-lean-six-sigma Public

    Synthetic Lean Six Sigma DMAIC banking process excellence case study using Python, SPC, MSA, DOE, COPQ, testing and reproducible analytics.

    Python

  4. eskom-strategic-intelligence eskom-strategic-intelligence Public

    Public-data analytics case study on Eskom municipal debt, electricity demand and physical-security risk using Python, SQLite, DAX, automated QA and CI.

    Python

  5. analytics-release-gate analytics-release-gate Public

    Open-source CLI that audits analytics and Power BI repositories for release readiness — repo hygiene, PBIP/PBIR/TMDL integrity, risky DAX patterns, and credential/path leaks — before they become re…

    Python

  6. garethmackenzie.github.io garethmackenzie.github.io Public

    Official website of Gareth Andrew Mackenzie, author of BUILT

    HTML