Skip to content
View ludodelot's full-sized avatar
🎯
Focusing
🎯
Focusing

Block or report ludodelot

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
ludodelot/README.md

Ludovic Delot: Business Intelligence Analyst, Power BI Developer, Data Analyst and AI Developer

Business Intelligence Analyst · Power BI Developer · Data Analyst · Analytics & AI Engineer

📍 Mexico City  ·  🇲🇽 🇫🇷 Mexican & French citizen (EU work rights)  ·  🗣️ Spanish · English · French

Connect on LinkedIn Email See featured projects

About · Impact · Projects · Stack · How I work · Experience · Education

About

Business Intelligence and Data Analyst with 4.5+ years in data (BSc in Business Intelligence plus BI roles), 90+ dashboards and 115+ automations developed. I build end-to-end data products: Python ETL, data modeling (star schema, DAX, TMDL), governed KPIs, Power BI dashboards and self-service reporting, plus generative AI and LLM agents that document, check and automate the repetitive parts.

At LVMH (luxury & beauty) I proposed and led the move from Excel reporting to a 20+ dashboard Power BI product on a 25-table semantic model, now versioned as PBIP in Git. Before that: CPFR, demand and inventory analytics at Groupe SEB, RPA and automation ROI at El Puerto de Liverpool, and research analytics with the OpenAI API at EGADE Business School. MSc in Finance (Rennes School of Business) and BSc in Business Intelligence (Tec de Monterrey).

Tip

Now: Data & BI (Power BI) at LVMH Beauty Tech · building a public BigQuery + dbt warehouse · shipping Claude Code skills for Power BI work.

Core skills (full keyword list)

Business Intelligence · Power BI · DAX · Power Query · TMDL / PBIP · Tableau · Data Modeling · Star Schema · ETL / ELT · Data Visualization · Dashboard Development · KPI Definition & Governance · Self-Service Analytics · Data Quality
Analytics · SQL · Python · R · pandas · Statistics · Machine Learning · Demand Forecasting · Time Series · Supply Chain Analytics (CPFR) · Commercial & Retail Analytics · Financial Analysis
Data platforms · Google Cloud (GCP) · BigQuery · dbt · Snowflake · PostgreSQL · MySQL · AWS · SharePoint · Git · GitHub Actions
AI & automation · Generative AI · LLM Agents · Claude Code · Model Context Protocol (MCP) · OpenAI API · Agent Skills · RPA (UiPath)
Ways of working · Stakeholder Management · Requirements Gathering · Documentation · Cross-functional BI Delivery · Training

Selected impact

4.5+ years in data; 90+ dashboards developed; 115+ automations developed; reporting that reaches 30 countries through worldwide and EMEA models, built from Mexico, France and Spain; 25,000+ SKU-store combinations across 300+ stores; two Power BI custom visuals published

Featured work

Public repositories. Employer work stays private; these projects use public or synthetic data.

Power BI engineering

Power BI custom visual: pick fields in the order you mean

Ordered FP Selector
Custom Power BI visual: report readers choose Field Parameter items in the order they want, reorder with ↑/↓ and keep that state between sessions. Grouped catalog, selection limits, .pbiviz release.

TypeScript Power BI Visuals SDK Field Parameters

Power BI custom visual: rows and columns swapped in one click

Transpose Matrix Pro
The native matrix, rebuilt: one-click transpose with no DAX or re-query, blank/zero filtering, hierarchies and subtotals, field parameters, cross-filtering and an accessible grid.

TypeScript DataViewMatrix Selection API

Claude Code skill: TMDL and PBIR to living documentation

pbip-doc
Claude Code skill that documents a Power BI project from its source: reads TMDL and PBIR, traces measure dependencies, flags orphans and circular DAX, writes Markdown docs and a quality report.

Claude Code TMDL PBIR DAX lineage

Claude Code skill: Power BI report to PDF user manual

pbip-manual
Turns a PBIP report into a 16:9 PDF user manual in English, Spanish, Italian and French: one page per report page with wireframe, zones, sources, refresh and main KPI. Offline, read-only.

Python reportlab PBIR unit tests

Data modeling & SQL

SQL dimensional model that catches a 3.19x freight error

Northwind Star Schema
Star schema from a flat sales export, six analytical queries and twelve data-quality assertions. The export mixes two grains: summing freight at the wrong one overstates it 3.19×, and the build fails if any check does.

PostgreSQL BigQuery dimensional modeling data quality

BigQuery and dbt warehouse from staging to marts

ecom-warehouse-dbt · in progress
Modern data stack on public e-commerce data: BigQuery + dbt with staging → marts, explicit grain, data tests, lineage and a KPI layer (GMV, AOV, conversion, retention).

BigQuery dbt SQL analytics engineering

AI agents & LLM tooling

Multi-agent system from demand to purchase orders

Commercial & Demand AI Agent Network
Specialist AI agents coordinate demand planning, procurement, inventory and supplier agreements through typed, auditable messages, with human approvals. Synthetic retailers and brands.

multi-agent LLM demand planning supply chain

Agent skill whose validator blocks claims without evidence

ATS Resume Tailor
Agent skill that tailors CVs to a job posting from one master profile. Every bullet cites an evidence id and a validator fails the build on any unsupported number, title or date.

agent skill Python CI zero deps

Agent skill that turns a vault into durable AI memory

Obsidian MOC Memory
Turns an Obsidian vault into persistent memory for AI agents: Map-of-Content retrieval, no-duplicate capture, and deterministic lint and index scripts. The LLM judges, scripts enforce rules.

agent skill AI memory Python Obsidian

MCP server in TypeScript exposing tools an LLM can call

Product Research MCP Server
Model Context Protocol server that gives an AI assistant search_products and get_product tools over stdio. Strict TypeScript, Zod validation, Vitest tests, ESLint. Mock catalog.

MCP TypeScript Zod Vitest

Data science, forecasting & quantitative finance (10 more projects)
Project What it shows Stack
Optimal tech portfolio CAPM, Fama-French 3-factor, Markowitz frontier and EMH tests on 10 assets, 2016–2025 R · Quarto
Decathlon premium-member prediction Cross-continent customer analytics and a Random Forest classifier (85.7% accuracy) Python · scikit-learn
Applied AI for business (HSBC case) RFM clustering, classifier comparison, an LLM chatbot and GPT-generated executive reports Python · LLM
BlaBlaCar driver analytics Behavior indices and Premium Club prediction on 97k trips Python · classification
Gold futures forecasting SES, Holt, Holt-Winters and auto-ARIMA; Holt-Winters multiplicative wins on RMSE, MAE and MAPE R · time series
Clustering portfolios Portfolios from 105 US stocks with K-Means and hierarchical clustering over market and ESG features Python · clustering
Semiconductor econometrics Return transmission and herding: PCA, robust OLS, CSAD, EGARCH R · econometrics
PPP: Mexico × France Tests absolute purchasing power parity 2020–2024 and explains the rejection R · OLS
NYC real estate + Snowflake R exploratory analysis and a documented Snowflake lakehouse pipeline R · Snowflake
Excel → MySQL ETL ETL from spreadsheets into MySQL plus business SQL queries MySQL · SQL

Stack

BI & MODELING
Power BI DAX Power Query TMDL · PBIP Tableau Excel

DATA ENGINEERING & ANALYSIS
Python SQL R pandas BigQuery dbt Snowflake Google Cloud AWS

AI & ENGINEERING
Claude Code MCP OpenAI API TypeScript UiPath Git GitHub Actions

How I work

Pipeline: sources, Python ETL with data-quality checks, a semantic model in DAX and TMDL versioned as PBIP in Git, Power BI with governed KPIs, and an AI layer of agents, skills and MCP

  • One definition per KPI, written down before the visual is built.
  • Models live in Git and get reviewed like code.
  • AI cites its sources and never invents a number.

Experience

LVMH
Feb 2025 – present
Mexico City · France · Madrid

Data & Business Intelligence (Power BI) Intern · Beauty Tech, Global Data & AI · Madrid · Jun 2026 – present
Commercial Business Analyst Trainee · Mexico City, then remote from France · Feb 2025 – Jun 2026

  • Proposed and led the Excel → Power BI transformation for Loewe and Acqua di Parma: 4 → 20+ automated dashboards and one shared reporting source for Mexico.
  • Built the 25-table model (sell-out, stock, e-commerce, POS, launches, incentives, commissions, forecasts, quotas) and an MTD summary used by the GM LatAm, senior KAMs and Retail Managers.
  • Cut recurring reporting prep from hours to minutes with Python ETL over Google Cloud (GCP) and SharePoint sources; wrote the DAX measures and led versioning of the worldwide Loewe and LVMH Iberia models in PBIP with Git.
  • Built data-model changes and BI projects presented to the Loewe executive committee.
  • Coordinate BI delivery across Business, Data, IT and Beauty Tech: requirements → KPI definitions → model logic → documentation → data-quality controls. Trained three people to automate the UK ETL.

El Puerto de Liverpool
Aug 2024 – Feb 2025
Mexico City

Automation Business Analyst · Digital CoE, Finance

  • Evaluated the ROI of a $27K USD UiPath Insights investment; the business case showed it was not worth pursuing.
  • Built RPA ROI dashboards and performance monitoring for automation projects.

EGADE Business School
Aug 2024 – Dec 2024
Mexico City

Data Analyst Intern · Faculty & Research Intelligence

  • Power BI dashboards for publication output, SDG alignment, career development and tenure.
  • Python cleaning and EDA; OpenAI API to classify academic articles.

Groupe SEB
Feb 2024 – Aug 2024
Mexico City

National CPFR Supply Chain Data Analyst

  • Demand and inventory analysis over 25,000+ SKU–store combinations for the second-largest mass-retail client, in R and Excel.
  • Flagged out-of-stock, excess and slow-moving patterns across 300+ stores for Sales, Supply Chain and Planning.

Education

MSc International Management & Finance · Rennes School of Business
Quantitative finance, econometrics, data science, forecasting, portfolio optimization, risk simulation, AI/fintech.

BSc Business Intelligence · Tecnológico de Monterrey · 97/100 · 3.8/4.0 GPA
Databases, Power BI and Tableau, Python and R, data mining, risk analysis. President of the Business Intelligence Student Committee.

Certifications & honors

Certifications · Microsoft Azure AI Fundamentals (AI-900) · Google Cloud Foundations · Introduction to AWS · SQL for Finance Professionals · Financial Statements in Power BI · Claude Code 101

Honors · Winner, Banorte Ideation & Prototyping Challenge · Winner, Patagonia Conscious Capitalism & Story Prototyping Challenge · Winner, CDL campus phase (INC MTY 2023) · Highest entering GPA scholarship, Tec de Monterrey

GitHub activity

Contribution calendar for the ludodelot GitHub account, with annual total and longest streak

Regenerated daily by a GitHub Action in this repo from the public contribution calendar.


Let's turn data into decisions. Always happy to talk BI, analytics engineering and AI.

Connect on LinkedIn Email Back to projects

Popular repositories Loading

  1. FieldParameterSelector-PowerBI-Visual FieldParameterSelector-PowerBI-Visual Public

    Power BI visual for selecting and reordering Field Parameter items, with grouped choices and persistent selection.

    TypeScript 1

  2. r r Public

    Collection of R scripts for statistical analysis and data exploration.

  3. rsb_msc_ts2026_finance_team1 rsb_msc_ts2026_finance_team1 Public

    Gold futures time series forecasting in R, comparing exponential smoothing and ARIMA models.

    HTML

  4. blablacar-data-science-analysis blablacar-data-science-analysis Public

    BlaBlaCar driver and trip analysis with exploratory insights and Premium Club subscription prediction.

    Jupyter Notebook

  5. canon-gear-finder canon-gear-finder Public

    Interactive React app recommending Canon camera and lens combinations by use, skill level and budget.

    JavaScript

  6. transpose-matrix-pro transpose-matrix-pro Public

    Power BI Custom Visual — modern matrix with one-click transpose, blank/zero filtering, hierarchies, and Microsoft 365-style design

    TypeScript