Projects

Selected reporting systems and analytical projects

Featured Projects

Retail Operations Reporting
Business Analysis Reporting Excel
A structured Excel reporting system that converts ERP-style transaction data into reconciled KPI tables and recurring operational summaries. Row-level business logic is defined before aggregation so monthly performance, mix, and operational views reconcile cleanly back to source transactions.
Retail SQL Explorer
SQL SQLite Datasette
A browser-based SQL explorer built from the same retail transaction dataset as the Excel case study, with KPI views and working-layer logic available for live queries. It exposes the relational model behind the reporting system so calculations can be inspected and queried directly.

Additional Projects

WGU Reddit Feedback Analyzer
Reporting Data Structuring SQL
A structured reporting project that converts public Reddit discussions about WGU courses into a queryable feedback dataset for inspection and analysis. A staged extraction pipeline turns informal posts into normalized issue tables that can be reviewed across courses, programs, and recurring themes.
Reddit Early Engagement Dynamics
Observability Measurement Analytics
An observational analysis of early post visibility patterns using timestamped Reddit listing snapshots. It measures what can be directly observed about chronological visibility and ranked-surface intersections under snapshot-based collection limits.