Interactive Shopify Analytics Dashboard on Google Sheets
Custom JavaScript dashboard built on Google Sheets for a Shopify store — 4 interactive pages covering executive KPIs, customer analytics, product performance, and operations.
Automated Invoice Generator for Architecture Firm
Custom Excel VBA tool that imports timesheets from Airtable, generates branded PDF invoices with one click, and includes a project analysis dashboard.
Automated Excel Data Consolidation Tool
VBA & Power Query tool that consolidates data from multiple Excel files into one sheet — extracting keywords and values with a single click.
COVID-19 Tracking & Reporting Tool
Automated Excel tool that pulls live pandemic data via Power Query, builds dynamic pivot charts, and generates a printable PDF report — refreshed daily with zero manual work.
CSV Data Cleaner & Validator
Open-source Python tool that automatically detects and fixes common data quality issues in CSV files — duplicates, missing values, type errors, and formatting.
Read More