Resources

Deep dives, real-world analyses, and case studies showing what MCP servers actually do — with real data, real queries, and real results.

📚 Capability Deep Dives

Detailed walkthroughs of each analytics domain — what you can do, how it works, and when to use it.

Power BI

Power BI & Semantic Models

Connect to Power BI datasets and SSAS tabular models. Explore DAX measures, query business metrics, and analyze model structure through conversation.

Read guide → Database

Database Intelligence

Query SQL databases with natural language. From AdventureWorks to enterprise data warehouses — ask questions and get instant results.

Read guide → Statistics

Advanced Statistics

Hypothesis testing, regression, Bayesian inference, survival analysis, SPC charts, and document generation — the complete statistical toolkit.

Read guide → Finance

Quantitative Finance

Options pricing, portfolio optimization, bond analytics, XVA, CDO tranches, and volatility model calibration — institutional-grade financial tools.

Read guide → Optimization

Operations Research

Linear programming, vehicle routing, job-shop scheduling, bin packing, and constraint satisfaction powered by Google OR-Tools.

Read guide → Strategy

Revenue Growth Management

Optimize pricing, promotional strategy, and product portfolios. Monte Carlo simulations, elasticity analysis, and competitive scenario modeling.

Read guide →

🔍 Case Studies

End-to-end analyses demonstrating MCP servers solving real problems with real data.

Structured Finance

Securitization Portfolio Analysis

A complete structured finance workflow — pooling residential mortgages, pricing CDO tranches, running Monte Carlo stress tests, and calculating regulatory capital under FRTB.

Read case study → Graph Analytics

Breach Detection with Graph Analysis

Using iGraph MCP to model network traffic as a graph, detect anomalous connections through community analysis, and identify potential security breaches via link prediction.

Read case study → Editorial

The Pulse of Boston

A five-chapter data investigation into Boston crime patterns — spatial analysis, temporal rhythms, predictive algorithms, and patrol route optimization. Full editorial treatment.

Read investigation → Verification

Formal Verification with Lean 4

Prove financial formulas and optimizer constraints correct — not test, not validate, prove. Type-check expressions, search Mathlib, and auto-fill incomplete proofs.

Read guide →

📊 Data Analyses

Standalone analyses produced entirely through MCP server conversations — each with real data, real queries, and reproducible results.

Nordic Statistics

Nordic Demographic Analysis

Population trends, age distributions, and migration patterns across Norway, Sweden, Finland, Denmark, and Iceland — queried live from SSB/SCB/StatFI/DST APIs.

View analysis → Nordic Statistics

Norwegian Wage Analysis

Wage distribution and earnings trends from Statistics Norway (SSB). Sector comparisons, gender gaps, and regional variations from official microdata.

View analysis → Nordic Statistics

Government & Education Spending

Public finance and education expenditure across Nordic countries. Budget allocations, per-pupil spending, and cross-country benchmarking from official statistics.

View analysis → Structured Finance

LendingBank Securitization Model

Full securitization analysis — mortgage pool composition, tranche waterfall, credit enhancement, and Monte Carlo loss modeling for a hypothetical RMBS structure.

View analysis → Data Science

Wine & Temperature Analysis

Statistical analysis exploring the relationship between wine characteristics and serving temperature — regression models, hypothesis testing, and visualization.

View analysis → Data Science

Tornado Magnitude Analysis

Distribution analysis and magnitude modeling of US tornado data — extreme value statistics, temporal trends, and geographic patterns.

View analysis → Data Science

Roy Kent F-bomb Analysis

A statistical deep-dive into Roy Kent's profanity patterns across Ted Lasso seasons — frequency analysis, episode trends, and sentiment correlation.

View analysis → Graph Theory

Graph Density Visualization

Interactive exploration of graph density, connectivity, and structural properties — generated with iGraph MCP server's 2D/3D rendering capabilities.

View visualization →

MCP Training Course

An 11-chapter hands-on course covering installation, core concepts, statistics, optimization, finance, graph analysis, Nordic data, and more.

Start the Course Download Servers