Data Engineering · CASE STUDY
Enterprise Data Warehouse on a Medallion Architecture
A bronze–silver–gold warehouse in Microsoft Fabric unifying CRM, ERP and static Excel sources into one governed star schema.
Read the case study →Projects
Case studies, not just screenshots.
Every project here covers the actual problem, the data that was in the way, the approach and what it changed. Filter by the kind of work you're looking for.
Data Analytics & BI · CASE STUDY
Financial Analysis Dashboard
An end-to-end Fabric pipeline replacing a manual monthly P&L rebuild with live, self-serve financial reporting and ratio analysis.
Read the case study →
Data Analytics & BI · CASE STUDY
CRM Pipeline Analysis Dashboard
REST API extraction into SQL Server, rebuilt as a star schema, exposing an 11.6% conversion rate and the exact stage where deals were dying.
Read the case study →
Data Analytics & BI · CASE STUDY
Marketing Campaign Analysis Dashboard
Facebook, Instagram and Pinterest unified in Fabric — showing the lowest-CTR channel was actually returning 75% more revenue per conversion.
Read the case study →
Data Analytics & BI · CASE STUDY
HR Analytics & Pay Equity Report
HR system and department spreadsheets unified in Fabric, with a multi-year gender pay gap analysis that surfaced role-level disparities.
Read the case study →
Data Analytics & BI · CASE STUDY
Hotel Reservation & Revenue Dashboard
Multi-channel booking data unified in Fabric, with threshold-driven alert logic flagging a systemic 36% lost-revenue problem.
Read the case study →
Data Analytics & BI · CASE STUDY
Critical Care & ER Analytics Dashboard
SQL Server and Excel patient records unified into one model, showing an average wait time was hiding how often the 30-minute target was missed.
Read the case study →
Data Analytics & BI · CASE STUDY
Call Centre Analytics Dashboard
A Python NLP layer added sentiment to 33,000 call records that had none — revealing negative sentiment outweighed positive nearly 3 to 1.
Read the case study →
GENERATIVE AI · BUILD
Multi-Department Infrastructure AI Agent
A single webhook-driven agent that takes plain-language requests and reasons through what's being asked: onboarding an employee, enriching a security…
See how it works →
GENERATIVE AI · BUILD
AI Sales Forecasting & Market Intelligence Agent
A single chat-based agent that handles all three. Market trend requests scrape live product data and return an AI-generated summary, forecast requests run…
See how it works →
GENERATIVE AI · BUILD
Multi-Agent Content & Operations Orchestrator
A central orchestration agent that receives requests through Telegram and routes each one to the right specialist agent — email, content, social upload,…
See how it works →
GENERATIVE AI · BUILD
AI Executive Assistant with Memory & CRM Integration
An assistant backed by persistent Postgres memory that holds context across sessions while checking calendar availability, creating events, managing CRM…
See how it works →
GENERATIVE AI · BUILD
Scout Agent — Automated Lead Discovery & Scoring
A scheduled agent that pulls founder and startup data from six sources (X, Product Hunt, GitHub, Crunchbase, LinkedIn, YC Demo Day), scores each lead…
See how it works →
GENERATIVE AI · BUILD
Website-to-RAG Ingestion Pipeline
A scheduled pipeline that crawls a target site, extracts clean content from every sub-page, chunks and embeds it, and stores it in a Supabase vector…
See how it works →
GENERATIVE AI · BUILD
Dynamic LLM Routing System
A routing system that sends heavier requests to GPT-3.5-Turbo or 4o-mini and lighter ones to a local Ollama model (Gemma, DeepSeek or Llama 3.2) running…
See how it works →
GENERATIVE AI · BUILD
Automated Network Device Installation System
A staged deployment workflow that installs on a single standby device first, verifies file integrity with an MD5 checksum before anything runs, and only…
See how it works →
GENERATIVE AI · BUILD
Notion-to-LinkedIn Auto Publisher
An automation that pulls the day's scheduled post from Notion, reassembles the content and runs it through an AI agent for formatting. A size check…
See how it works →
GENERATIVE AI · BUILD
reMarkable-to-Obsidian Sync Pipeline
An automation that watches an inbox for note exports, extracts the content through custom parsing logic, converts it to structured markdown and writes it…
See how it works →Want something like this for your data?
Tell me what decision or process is being held back, and I'll tell you what it would take to fix it.