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.

In Progress
Personal · Web
Constellation Analytics — Portfolio Site

This site. Designed and built from scratch using vanilla HTML and CSS with a custom design system. No frameworks, no templates.

HTML CSS GitHub
Read →
Live
Analytics Engineering
Master Data ELT Pipeline — Schneider Electric

End-to-end SQL ELT pipeline built in PostgreSQL to monitor master data quality across a global SAP environment. Feeds a Tableau dashboard used by the client's data governance team.

SQL PostgreSQL Tableau SAP
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