BEN MANGUIATData · Systems · Scrum
COMPLETE PORTFOLIO INDEX

All Interactive Case Studies

Browse complete interactive project case studies spanning Data Analytics Pipelines, SQL/Python ETL, Agile/Scrum project delivery, and Business Systems Architecture.

01Data & Analytics

Northstar Commerce Executive BI Dashboard & Data Pipeline

PostgreSQL Data Pipeline, Star Schema Dimensional Modeling & Power BI

Engineered an end-to-end PostgreSQL data analytics pipeline and interactive Power BI Executive Command Center to diagnose margin decay ($5.94M revenue, $2.29M profit) across 63k+ order transactions.

TECHNOLOGY STACK
PostgreSQL · SQL · Power BI · DAX · Data Modeling · Star Schema · ETL Pipelines · Data Quality Audit
VISUAL ANALYSIS PREVIEWZOOM IN
Northstar Commerce Executive BI Dashboard Overview
POWER BI EXECUTIVE COMMAND CENTER$5.94M NET REVENUE
Net Revenue$5.94M
Gross Profit Margin38.6%
Order Items Analyzed63,635
GITHUB REPOSITORY ↗
02Business & Systems

Interactive Portfolio & Analytics Platform

Modern Web Application (Next.js, TypeScript, Tailwind CSS, Recharts)

Engineered a modern, responsive web application showcase for data analytics pipelines, interactive Machine Learning scatter plots, and Agile Scrum Master project workflows.

TECHNOLOGY STACK
Next.js 16 · React 19 · TypeScript · Tailwind CSS v4 · Recharts · GitHub REST API · Glassmorphism
VISUAL ANALYSIS PREVIEWZOOM IN
NEXT.JS 16 SYSTEM ARCHITECTURE100% SSG
Next.js 16 App RouterReact 19 & Tailwind v4
PAGE LOAD SPEED
< 1.0s SSG
STATIC ROUTES
15 SSG Pages
API: GitHub REST APIINSPECT ARCHITECTURE →
Page Load Speed< 1.0s (Prerendered)
Static Routes15 SSG Pages
API IntegrationGitHub REST
GITHUB REPOSITORY ↗
03Data & Analytics

NFL Player Clustering & Fantasy Tier Analytics

K-Means Machine Learning & VOR Modeling | Python & Scikit-Learn

Unsupervised machine learning pipeline that clusters NFL players into actionable fantasy performance tiers using custom PPR+IDP scoring, Value Over Replacement (VOR), and K-Means with triple-metric validation.

TECHNOLOGY STACK
Python · Scikit-Learn · K-Means · Pandas · Value Over Replacement (VOR) · Matplotlib · Seaborn · CLI Pipeline
VISUAL ANALYSIS PREVIEWZOOM IN
NFL Player Fantasy Tiers K-Means Clustering
K-MEANS VOR TIERS (k=4)SCIKIT-LEARN PIPELINE
Validation MethodsElbow, Silhouette, Gap
Clustering ModelK-Means (k=4)
Core MetricVOR (Value Over Replacement)
GITHUB REPOSITORY ↗
04Data & Analytics

TFT Analytics & Snowflake Data Warehouse

SQL Dimensional Data Modeling & Snowflake Cloud Warehousing

Engineered a Snowflake cloud data warehouse and analytical SQL pipeline analyzing Teamfight Tactics (TFT) player performance, team composition synergies, and win-rate trends.

TECHNOLOGY STACK
Snowflake · SQL · Python · Data Warehousing · Dimensional Modeling · ETL Pipelines
VISUAL ANALYSIS PREVIEWZOOM IN
TFT Analytics Power BI Dashboard
TFT POWER BI DASHBOARDSNOWFLAKE DATA PIPELINE
Data WarehouseSnowflake Cloud
Schema ModelStar Schema (Fact/Dim)
Query OptimizationCustom CTEs
GITHUB REPOSITORY ↗
05Project Management & Scrum

Woodland Manor Agile Web Redesign & Systems Overhaul

Scrum Master & Business Analyst Project Management Delivery

Led a cross-functional Scrum team (DevHawks) through 4 2-week Sprints to redesign Woodland Country Manor’s digital presence, streamlining stakeholder reviews and boosting user engagement by 45%.

TECHNOLOGY STACK
Agile / Scrum · Jira / Confluence · Backlog Grooming · Stakeholder Management · User Stories · Process Mapping
VISUAL ANALYSIS PREVIEWZOOM IN
AGILE SCRUM SPRINT DELIVERY4 SPRINTS · 8 WEEKS
AVG VELOCITY
42 Pts
ON-TIME
96%
FEEDBACK
-40%
ARTIFACTS: Backlog · Burndown · DoDLIVE WEBSITE →
TEAM: DevHawks (6 Members)EXPLORE FRAMEWORK →
Sprint Velocity Increase+35%
On-Time Story Completion96%
Stakeholder Feedback Loop-40%
LIVE WEBSITE ↗