Projects

Each project documents the business question, source data, analytical logic, evidence state and limitations.

Publication statesPublished · data-pipeline · pipeline-ready · research-ready · simulation · live-system
published
Construction Materials

The Bitumen Effect

A completed Stats SA case study showing how the treatment of bitumen changes the inflation signal for road activities, and why weighted inputs matter more than headline percentages.

ExcelPower QuerySQLJavaScript visualisationPower BI-ready model
Decision

Choose the most relevant price signal for road-material exposure instead of relying on one blended construction headline.

building
Construction Materials

Construction Materials Intelligence

A monthly material-risk system using Stats SA CMPI/CPAP/CIPI data to detect unusual movement, volatility and divergence across road, concrete, steel and other civil-engineering inputs.

ExcelPower QueryPostgreSQLSQLPower BI
Decision

Prioritise which input risks need procurement, contingency or commercial attention without exposing project monetary values.

pipeline-ready
Market Intelligence

Cape Town Asphalt Demand Pressure Monitor

A procurement-pipeline model that classifies road tenders and awards to estimate future asphalt demand pressure in Cape Town and the Western Cape without claiming supplier inventory.

REST APIJSONSQLPython/NLP plannedPower BI
Decision

Anticipate procurement pressure early enough to review programme sequencing, supply strategy and escalation risk.

pipeline-ready
Procurement Analytics

Civil Infrastructure Tender Intelligence Engine

An OCDS data pipeline that turns public procurement releases into a searchable civil-infrastructure market view: sector, stage, location, buyer, cycle time and outcome.

REST APIJSONPostgreSQLSQLPython planned
Decision

Convert procurement records into a reusable, queryable infrastructure pipeline instead of manually checking tender pages one by one.

research-ready
Infrastructure Intelligence

Infrastructure Activity Radar

A multi-source view combining municipal capital activity with procurement pipeline signals to identify where roads, stormwater and water infrastructure activity is strengthening or weakening.

API/CSVPower QueryPostgreSQLSQLPower BI
Decision

Identify infrastructure activity using multiple independent signals instead of ranking municipalities on one headline number.

simulation
Information Management

Engineering Information Performance Lab

A large synthetic CDE/BIM reporting environment modelled on real construction information-management work: RFIs, submittals, deliverables, packages, ageing, cycle time and data-quality controls.

Power QueryPostgreSQLSQLPower BIDAX
Decision

Detect information bottlenecks before they become programme or coordination problems.

live-system
Data Engineering

Yatify Data Reliability Monitor

The operational layer behind Yatify: source checks, release freshness, validation state, schema-change detection and a publish gate that protects dashboards from silent source failures.

PHPREST/HTTPJSONValidation rulesAdmin monitoring
Decision

Know whether a dashboard is fresh and trustworthy before using its result.

simulation
Project Controls

Project Controls Performance Lab

A portfolio-safe project-controls environment with 800 activities across 24 monthly reporting snapshots, WBS/packages, planned vs actual progress, forecast finish, float, milestones and resource-hour variance.

Excel / Power QueryPostgreSQLSQLPower BIDAX
Decision

Identify package slippage, float erosion, milestone risk and resource variance early enough for a project team to investigate and recover the programme.

published
Data Quality

Data Quality & UAT Lab

A practical validation layer that turns data-quality rules into inspectable test results across Yatify’s published and portfolio-safe datasets.

SQL-style data testsPython validationCSV reconciliationUAT rulesPublication gates
Decision

Determine whether an analytical output is safe to publish and identify exactly which rule failed when it is not.

published
Building pipeline analytics

The Approval Gap

A real public-data case study comparing building plans passed with buildings completed, testing real-price movement, building-type and province divergence, and whether the available monthly window supports a defensible construction lag.

PythonpandasSQLExcel / Power QueryInteractive charts
Decision

Can building approvals be used as a forward signal for completed construction activity without confusing same-period values with a true conversion rate?