DENIS IL.
Analytics Labs

The Labs

A growing research space for experiments in data engineering, AI analytics, and autonomous systems.

Data Engineering

Pipeline architecture, lakehouse experiments, and storage format research.

Vector DWH Index

Experiment

What if you could find similar business situations from history without writing a query? This experiment embeds aggregated metrics as vectors in ClickHouse, enabling semantic similarity search across time periods, cohorts, and segments.

EmbeddingsClickHouseAnomaly Detection

AI Analytics

LLM reasoning over structured data, autonomous reporting agents, and semantic layer experiments.

Semantic SQL Layer

Research

LLMs are remarkably good at reasoning over structured data — when given the right abstraction. This experiment builds a semantic layer that maps business concepts to SQL constructs, allowing Claude to generate reliable, governed queries without hallucinating column names.

LLMSQLDWH

Autonomous Report Agent

Prototype

A LangChain agent that runs on a schedule, queries the DWH for KPI deviations, decides if they're significant, and writes an executive summary with root-cause hypotheses. No human in the loop.

ClaudeLangChainKPI

Sports Analytics

Performance modelling, event stream analysis, and predictive systems for competitive sports.

Coming soon

Experiments and research in this category are being scoped.

Research

Deep dives into emerging data infrastructure patterns and architectural trade-offs.

Coming soon

Experiments and research in this category are being scoped.

Experiments

Short-cycle prototypes and proof-of-concept implementations.

Coming soon

Experiments and research in this category are being scoped.