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
Analytics Engineering
Automated Sales Performance Tracker

A personal project built to practise end-to-end pipeline development. Python pulls and cleans synthetic sales data, loads it to a PostgreSQL database on Neon Cloud via a scheduled GitHub Actions....

Power BI DAX Tech 3
Read →

Paul Chapman
© 2026 Constellation Analytics

Constellation Analytics