Pablo Pilanski
Home
Data systems & analysis

Data analyst

I analyze audiences and sports performance with SQL, Python, Tableau and Power BI. I work from data capture and modeling through to reports for programming teams, coaches and sporting directors. My cases show how I compare movies, evaluate matches and present findings.

Turning hard data into decisions

Three real reads from my work with synthetic values. A schedule builds itself, a curve moves a premiere slot and a scouting profile recommends a role.

FAST schedule engine · tier placement and cooldownSynthetic data
FAST schedule engine · tier placement and cooldownMonTueWedThuFriSatSun06-09CCCCCBB09-12CBCBCBB12-15BBBBBA×15-18BCBB×AA18-21A · F-07AAAAAA21-24BF-07 ×BABBBFixed primetimeTier ATier BTier CCooldown active · 72 h

Top-tier content is reserved for the fixed primetime (18-21) and the cooldown blocks repeating a title within 72 h. The grid fills itself under both rules; the programmer only reviews exceptions.

Linear programming · hourly consumption, weekday vs weekendSynthetic data
Linear programming · hourly consumption, weekday vs weekendPrime 18-21050100+4206h10h14h18h22h24hWeekendWeekday

Weekends pull consumption almost three hours earlier and the plateau starts at 3pm instead of 6pm. This curve moved Saturday premieres to the afternoon.

Scouting · percentile profile vs category cohortSynthetic data
Scouting · percentile profile vs category cohortCohort medianBall progression91Recoveries84Passes into the box71Defensive 1v158Shooting from range44Aerial duels270255075100

An average hides the role. The profile combines elite ball progression and recoveries with below-median aerial play, pointing to a progressive number 8.

Projects

Movie Performance on TV

Data analyst

For a multinational broadcaster, I designed a Tableau report that compares movie performance by airing, title and channel through scores and operating filters.

In production2026

Video Rental Analytics

Data analyst

I built this Unicorn Academy data bootcamp final project from Sakila and a fictional Blockbuster case, with six views covering sales, stores, costs and online expansion.

Prototype2026

Football Performance Data

Data analyst

For Alondras CF I built an end-to-end environment covering video and field capture, event processing and performance reports for sporting direction and the coaching staff.

In production2025

Video Analysis & Scouting

Data analyst

I co-designed a match performance index with a collaborator and produced video analysis and scouting reports covering teams, players and set pieces.

In production2023-2025