Constellation Analytics
  • HOME
  • EXPERTISE
  • PROJECTS
  • ABOUT
  • Let's Talk
Home
Portfolio

Projects & Case Studies

A collection of analytics, engineering, and automation work — covering ELT pipelines, data modelling, BI dashboards, and more.

Constellation Analytics
Live
Personal · Web
Building This Site as a Non-Developer

How I designed and built this portfolio from scratch using plain HTML and CSS, with no prior web development experience. A four-hour foundations course, version control from day one, and an iterative AI-assisted workflow.

HTML CSS GitHub Claude (AI)
Read →
Live
Data Challenge · Data Visualisation
50 Years of Lego - Power BI

Designed and built an interactive dashboard exploring the history and evolution of LEGO sets over the past five decades, as part of the Maven Analytics 2024 data challenge series.

Power BI DAX Python Power Query
Read →
Live
Personal · Analytics Engineering
Cloud-Hosted Fuel Price Pipeline

How I replaced a manual monthly process with a fully automated ELT pipeline using GitHub Actions, Neon PostgreSQL, and Python.

Python PostgreSQL GitHub Actions Neon
Read →
Live
Client Project · Analytics Engineering
Product Hierarchy Data Management

A three-stage SQL stored procedure pipeline that automates product hierarchy propagation, runs 80+ data quality checks, and produces a full audit trail of every change — replacing a manual Excel-based process for a global energy management company.

SQL Stored Procedures Data Quality Master Data
Read →

Paul Chapman
© 2026 Constellation Analytics

Constellation Analytics