Esplorazione
Context & ObjectiveClarifying the problem, the decision to improve, the users involved and the expected outcome.
Data & Analytics
Patrones Lab is a data analytics lab focused on real-world, everyday phenomena.
It brings together independent projects built with public data, with an emphasis on finding patterns, explaining behavior and communicating insights with context.
The goal is to ask better questions, prepare reliable data, build reproducible analyses and turn results into clear visual outputs.
I’m Malcolm Di Pietro Cagliari, an actuary and Data & Analytics professional. My background brings together Business Intelligence, corporate reporting, data modeling, and predictive analytics, with experience across banking, insurance, and aviation.
I focus on connecting business needs with data-driven solutions: defining KPIs, structuring information, building dashboards, and developing models that make complex situations easier to understand and support better decisions.
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 neighbourhoods.
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 soccer 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 centre, neighbourhoods and geographic neighbourhood metrics.

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

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