Data Analytics Portfolio

Turning raw data into clear decisions.

A growing collection of dashboards and SQL analyses, focused on energy and product data. Built with Power BI, SQL, and Python.

View work GitHub

Power BI DAX SQL Python Data Modeling

Selected work

SQL | Data Modeling

US Electricity Generation: a SQL Analysis (1990-2024)

A star-schema project on 35 years of US energy data from the EIA: ETL and data validation in Python, then analytical SQL with JOINs, CTEs, and window functions. Finds that natural gas now supplies 43% of US power and leads 28 states, while coal has fallen about 59% since 1990.

SQL SQLite Window Functions Data Modeling Python

View on GitHub

Power BI | Live

US Mineral Production & Import Dependence

An interactive report on US mineral production and the country's reliance on imported critical minerals, built on USGS data. The TMDL model and PBIR report were authored as code (Python and DAX). Highlights: the US is 100% import-reliant on 16 commodities, and China leads world supply for 20 of 39 critical minerals.

Power BI DAX TMDL Power Query Python

View on GitHub

Contact

Open to remote data work. The fastest way to reach me is LinkedIn or email.

LinkedIn Email