Projects

Case studies in data pipelines, dimensional modeling, and BI.

Filter Projects

Power BI dashboard showing battery recycling facility locations and competitor analysis across Europe
PythonPuLPPandas

Optimizing European Battery Recycling Through Data-Driven Location and Technology Analysis

98,667 t/yr

European end-of-life battery volume left unprocessed by existing recyclers by 2026, the capacity gap the network was optimized to close

View project
Power BI dashboard showing total procurement spend, supplier country and material counts, spend by material as a bar chart, and spend by commodity group as a donut chart
Microsoft FabricPySparkPower BI

OEM Material Insights: Procurement & Supply-Risk Intelligence on Microsoft Fabric

Zero silent gaps

Missing coverage is surfaced and flagged rather than coerced to zero, including one gap that can never be closed

View project
Diagram of the draft Circular Footprint Formula rules for a battery, starting from the bill of materials. One strand is making the battery, the other is the battery at end of life, and each flow is colour-coded by the formula term it feeds: material input, dismantling, electronics recycling, cell recycling, energy recovery and disposal Diagram of the draft Circular Footprint Formula rules for a battery, starting from the bill of materials. One strand is making the battery, the other is the battery at end of life, and each flow is colour-coded by the formula term it feeds: material input, dismantling, electronics recycling, cell recycling, energy recovery and disposal
Power QueryExcel

From legal text to data pipeline: the Battery Regulation CFF

Legal text → working pipeline

Translating the draft Circular Footprint Formula for batteries into a pipeline that takes a bill of materials in and returns the six-term breakdown the draft rules set out.

View project
Bar chart showing material composition (Li, Ni, Co, Mn) across battery chemistries from NCA to LFP, demonstrating chemistry evolution analysis from the research
ExcelPower QueryLife Cycle Assessment (LCA)

Lithium-Ion Vehicle Battery Production: Meta-Analysis of Emissions Data

32-47%

Emissions reduction identified vs. 2017 baseline through improved data transparency

View project