Solution Architecture

Practical Fibonacci (T-Shirt)

by

Practical Fibonacci is a lightweight, confidence-based approach to job sizing. By using Fibonacci numbers to estimate effort, teams can express not just how long something might take — but how much clarity, confidence, and complexity is involved. This method encourages meaningful conversation about risk, unknowns, and deliverability, helping teams avoid underestimating large or unclear work, … Read more

An Overview of the Bronze Pipeline

by

Data pipeline name: My Bronze Pipeline Owner: Data Engineering Team Used since: July 2023 Purpose: The Bronze pipeline is an automated the loading of Parquet data files from an Azure data lake storage container into tables in the staging database Overview This pipeline orchestrates the movement of new data that is continually appended to storage. … Read more

How to Redirect from HTTP to HTTPS

by

 Set up your redirects in your .htaccess file: <IfModule mod_rewrite.c>RewriteEngine OnRewriteCond %{HTTPS} offRewriteRule ^(.*)$ https://%{HTTP_HOST}%{REQUEST_URI}[L,R=301]</IfModule> Look confusing? Here’s the breakdown:  You can also solve this from within PHP in case your provider has disabled .htaccess (which is unlikely since you asked for it, but anyway)

An Overview of the Medallion Pipeline

by

Data pipeline name: Medallion to Bronze ETL Pipeline Owner: Data Engineering Team Used since: July 2023 Purpose: The Medallion pipeline is an automated process that handles the extraction, loading, and processing of CSV data from SATUK or GMISUK systems into bronze storage as parquet files. Overview The Medallion pipeline begins by setting source variables based … Read more