Discovery
Context and objectiveUnderstanding the problem, the decision to improve, the users involved and the expected outcome.
Data & Analytics
Patrones Lab is a data analysis lab focused on everyday, real-world phenomena.
It develops independent projects built from public data, with a focus on identifying patterns, describing behavior and communicating findings in context.
The goal is to ask questions, prepare data, build clear analyses and produce visual results.
I’m Malcolm Di Pietro Cagliari, an actuary and Data & Analytics professional. My background combines Business Intelligence, corporate reporting, data modeling and predictive analytics, with experience in banking, insurance and aviation.
I specialize in connecting business needs with data-driven solutions: defining KPIs, structuring information, building dashboards and developing models that help people better understand what is happening and make decisions with more context.
A selection of applied projects built with public data, documented methodology and visual outputs. Use the filters to explore by discipline, tool or deliverable type.
Analysis of air traffic in Spain using public AENA data, focused on volume, airport-level patterns and differences across traffic categories.
Exploratory analysis of Airbnb in London to compare prices, accommodation types, availability, minimum stays and differences between neighborhoods.
Analysis of reported Chicago taxi trips to study duration, demand, geospatial distribution and operational patterns.
Supervised classification of listings as relatively expensive or inexpensive within each accommodation type.
Interactive Looker Studio dashboard for exploring Chicago taxi trips, operational indicators, hourly patterns and pickup-dropoff routes.
Logistic regression model that estimates the probability of each shot becoming a goal using public StatsBomb data, match-level validation and application to the Qatar 2022 World Cup.
Open project
Probabilistic Expected Threat model in football using public StatsBomb data. It estimates the probability of a goal in the next 5 actions.
✅ published
Unsupervised K-means clustering applied to credit card fraud detection.
✅ published
Supervised logistic regression model for credit card fraud detection.
✅ published
Unsupervised DBSCAN clustering to detect potential credit card fraud patterns.
Open project
Analysis of 2022 World Cup statistics using public StatsBomb data, focused on summarizing individual performances and comparing players through percentile radar charts.
Geospatial analysis of Chicago taxi trips, focused on identifying activity hotspots, urban routes and the territorial concentration of demand.

Interactive Power BI dashboard on Spotify Charts to analyze streams, rankings, temporal trends and the geographic distribution of music.
✅ published
Interactive Power BI report for analyzing supplier spend, monthly trends, category distribution, savings and geographic distribution.
Simulation of one million 2026 World Cup scenarios using Elo ratings to estimate the probability of reaching the semifinals, playing the final and becoming champion.
Classification model for estimating economic damage in weather events, comparing logistic regression with a neural network.
Geospatial analysis of Airbnb prices in London using distance to the city center, neighborhoods and geographic neighborhood metrics.

Simulation of one million LaLiga 2026/27 scenarios using Elo ratings to estimate the probabilities of the championship’s most important outcomes.

A goal model using the Poisson distribution to calculate each team’s attacking and defensive strength, combined with Monte Carlo simulation to estimate championship probabilities.
For professional opportunities, analytics collaboration or BI, machine learning and dashboard projects.
Send me a message and I’ll get back to you shortly.