Type-safe, schema-driven Excel reporting for TypeScript with native Excel tables and streaming exports.

This case study is designed for e-commerce teams, store operators, agencies, and freelancers who need recurring exports and reporting-ready files from Shopify-style order, product, and customer data.

Production-grade sales forecasting system using ARIMA, Holt-Winters, and ML with automated reporting.

Interactive Excel dashboard analyzing UK road accident data for 2021–2022 (307K+ records)

A Machine Learning-Based Decision Support System for Predicting Customer Attrition and Quantifying Revenue Risk in Subscription Businesses

Bulk Gmail credential validation using Python, Selenium, Docker, and GitHub Actions with Excel-based reporting and security auditing.

Python data pipeline that extracts data from Notion API, transforms it with Pandas, and generates automated Excel reports for Power BI dashboards.

VAT reconciliation control app for comparing VAT registers, return summaries, payments/refunds, and GL control movements with exception reporting and Excel export.

Python automation tool for Cisco switch collection, parsing, Excel reporting, dashboards, JSON snapshots, and topology crawl.

AI-assisted job intelligence pipeline for structured JD analysis and candidate-role matching.

A practical SQLite portfolio project analyzing property occupancy, rent collection, tenant payments, and maintenance KPIs using SELECT, JOIN, GROUP BY, CASE WHEN, SUM, COUNT, and date filtering.

Process unlimited Excel files automatically: clean data by processing each, standardize columns, merge files, and generate professional reports with visual tools.

School Analytics Dashboard – Flask web app to track attendance, fees, grades, and student reports with Excel export.

Portfolio risk management tool using VaR, Expected Shortfall, Risk Parity and Black-Litterman optimization.

Автоматизированная система сбора производственных данных через REST API с последующей обработкой, агрегацией и формированием управленческих отчетов в Excel.

Production-style RPA pipeline built with Python, Selenium, pandas, and openpyxl for web automation, data processing, Excel reporting, and scheduler-ready execution.

Automated web scraper for SEMI member directory with multi-lingual support and data enrichment.

Análisis de datos de ventas e inventario para un e-commerce simulado, con el objetivo de optimizar la gestión de stock mediante el cálculo de Puntos de Reorden y Stock de Seguridad, identificando riesgos de quiebre y oportunidades de mejora.

NLP survey analysis pipeline for Shopify (Zigpoll/KNO/other) CSV exports. Classifies sentiment & themes (free demo mode or OpenAI mode) and outputs multi-sheet Excel with charts.

Cohort CAC/LTV model for GTM analytics. DuckDB SQL executed from Python. Exports Excel + PNG for decision-ready unit economics.