Work & case studies | MCC AI Automation

Data Engineering · Machine Learning · Financial Modeling

Portugal Rental Investment Intelligence

A financial decision-support system that evaluates whether a short-term rental property in Portugal is a viable investment. It ingests multi-platform listing data (Airbnb, Booking, Vrbo), models occupancy and nightly price, and simulates revenue, cash flow, and mortgage payback across regions.

SOURCE: Airbnb · Booking · VrboPublic multi-platform listing snapshots for Portuguese regions

Bronze: raw ingestionListings, availability, coordinates, and reviews captured as received

Silver: filtered & conformedGeographic filtering by coordinates and municipality, cleaning, cross-platform matching

Gold: warehouse & featuresValidated warehouse tables and model features

ML: occupancy & nightly priceXGBoost occupancy and nightly-price models, versioned and benchmarked

Financial model & decision viewRevenue, cash flow, €150k mortgage payback, and regional comparison

AI · Revenue Intelligence · Automation

AI Revenue Operations Command Center

An interactive revenue-operations product on a synthetic-but-coherent commercial dataset: it scores opportunities with an interpretable model, forecasts weighted pipeline, retrieves grounded account intelligence locally, and recommends next-best actions traceable to the data. It runs live on this page.

Synthetic CRM modelAccounts, opportunities, activities, notes (seeded, reproducible)

Feature engineeringStage, recency, engagement trend, deal age and size

Opportunity scoringInterpretable win-likelihood with visible contributing factors

Pipeline forecastValue weighted by stage win-probability

Account intelligenceLocal retrieval and a deterministic grounded summary

Next-best-action engineRules with cited evidence, priority-ranked

Data Engineering · Operational AI · Anomaly Detection

Intelligent Supply Chain Exception Control Tower

An operational control tower over a synthetic warehouse-and-transport event stream. It detects exceptions (late shipments, picking delays, SLA-breach risk, stockouts), scores delivery-delay risk, and ranks what needs attention now with a transparent priority score. It runs live on this page.

INBOUNDSTORAGEOUTBOUND3PLSAP EWMREPORT

Data Engineering · Geospatial · Sustainability

Dutch Housing & Energy Intelligence

A decision-support platform on real Dutch open data (CBS): average dwelling energy use (gas, electricity, district heating) across all 342 municipalities, compared to the national baseline, with an indicative retrofit scenario lab. It runs live on this page.

EXTRACTSQL / Python

TRANSFORMKPI definitions

REFRESHPower BI / Tableau

Web Experience · Creative Engineering

MCC Living Intelligence Platform

This website. An immersive, multilingual Next.js platform built as living proof of what MCC ships: a hand-authored Intelligence Core, a context-aware cursor, scroll-driven motion, five languages, and interactive AI demos, all tested and production-built.

Design systemTokens for color, type, spacing, motion, and MCC spatial primitives

Component architectureTyped React components on a token-driven CSS system

Motion & cursor intelligenceScroll-driven reveals, magnetic cursor, signal motion

Intelligence CoreHand-authored Canvas network with device tiers and reduced-motion fallback

Ship: tested & localizedFive locales, Playwright end-to-end tests, clean production build

Azure · Automation

Azure Lakehouse & Secure Data Intake

A new Azure Lakehouse architecture with Bronze / Silver / Gold layers, plus a secure drag-and-drop upload flow that automates file ingestion and database processing, replacing manual handling with a repeatable, governed pipeline.

Secure upload: Azure Web AppsDrag-and-drop intake, validated & authenticated

Bronze: rawFiles landed and retained as received

Silver: cleanedStandardized, validated, database-ready

Gold: reportingCurated tables feeding Power BI

BI · Automation

Reporting & KPI Automation

Automated data extraction, transformation, dashboard refreshes, and KPI reporting using SQL, Python, Power BI, and Tableau, turning recurring manual reports into a hands-off pipeline.

EXTRACTSQL / Python

TRANSFORMKPI definitions

REFRESHPower BI / Tableau

Operations · Supply Chain

Logistics Analytics & SAP EWM Support

Analysis of inbound and outbound logistics with a third-party logistics (3PL) partner, improved operational reporting, and support for an SAP EWM transformation through testing, validation, and documentation.