TennisData Doesn't Lie: The Journey from Excel Spreadsheets to Modern Football Tactics

Data Doesn't Lie: The Journey from Excel Spreadsheets to Modern Football Tactics

core_answer: Bài viết kể về hành trình 9 năm của một nhà phân tích dữ liệu bóng đá, từ việc theo dõi pressing của Manchester City năm 2017 đến nghiên cứu bóng đá không khán giả năm 2020 và Euro 2021.
key_facts: Man City chỉ để Bournemouth chạm bóng 3 lần trong vòng cấm ở trận tháng 12/2017.; Mô hình dự đoán World Cup 2018 xếp Brazil số 1 với 23,4% nhưng Pháp vô địch.; PPDA Premier League giảm từ 9,8 xuống 11,6 khi không có khán giả năm 2020.; Đan Mạch tạo xG cao nhất vòng bảng Euro 2021 (3,6) dù thua Phần Lan.
source: Sports Illustrated (SI) - 2019 | Cross-checked: VuaBong.vn
related_qa: q: Vì sao dữ liệu pressing quan trọng trong phân tích bóng đá?, a: Chỉ số PPDA cho thấy mức độ pressing và kiểm soát không gian của đội bóng, giúp đánh giá chính xác hơn hiệu quả chiến thuật.; q: Bóng đá không khán giả ảnh hưởng thế nào đến lối chơi?, a: Không có áp lực khán giả, các đội chơi chậm và thận trọng hơn, PPDA giảm từ 9,8 xuống 11,6 theo nghiên cứu của tác giả.; q: Vì sao mô hình dự đoán World Cup 2018 của tác giả thất bại?, a: Mô hình thiếu biến số về chiều sâu đội hình và trạng thái tinh thần của các ngôi sao, dẫn đến dự đoán sai nhà vô địch.

I still remember that December 2026 night, sitting in front of a computer screen with an Excel spreadsheet full of Manchester City's pressing numbers in their match against Bournemouth. Pep Guardiola's team allowed the opponent to touch the ball only 3 times in the penalty area throughout 90 minutes. A number that shattered every stereotype about "attacking football lacking safety." That night, I wrote a 2,000-word analysis, using xG (1.8 vs 0.4) to prove Man City didn't just win through luck. The article was shared by a major Twitter account, reaching 15,000 reads in 24 hours. Immediately, I built an Excel spreadsheet tracking pressing for all 20 teams each round — a habit I maintained until 12th grade. My background began in 2026 when I joined Sports Illustrated as a fact-checker. This job established writing discipline from early-career observation. I learned that every tactical assessment must include at least 2 quantitative metrics, and I always cross-reference on-field results with expected data to avoid emotional conclusions. Data doesn't lie; it's the people reading data who make excuses. But the 2026 World Cup taught me a bitter lesson. Before the tournament, I built a prediction model using historical data from 6 major tournaments, using Elo ratings and qualifying records. The model ranked Brazil as the number one contender with a 23.4% championship probability. I was so confident that I wrote a long post on my personal blog declaring "data has identified the champion." But Brazil was eliminated in the quarterfinals by Belgium (losing 1-2), while France — my model's 4th pick with 11.2% — won the title. I realized the model lacked variables for squad depth and the mental state of star players. In 2026, I learned that a 95% probability still has 5% that can smile. Within a month after the tournament, I collected data on each player's club minutes before the tournament, added it to the model, and rewrote the entire algorithm from scratch. The dead football season of 2026 was the biggest turning point in my analytical career. In June 2026, when the Premier League restarted after the COVID-19 pandemic in "behind closed doors" experiments, I decided to conduct a comparative study of 100 pre-pandemic matches and 50 post-restart matches in the Premier League. The results were shocking: average pressing per match (PPDA) dropped from 9.8 to 11.6 — meaning teams played slower and more cautiously without crowd pressure. Expected goals from set pieces dropped 14%, while free-kick conversion rates increased 18% due to reduced psychological pressure. From empty stadiums, I could hear the breathing of the match. The no-audience season is the cleanest laboratory football has ever had. I published a 2,500-word analysis proposing that clubs should adjust their pressing tactics when playing home matches without fans. This article coincidentally caught the eye of an analyst at Brisbane Roar, who later contacted me and offered an internship. Euro 2026 was an internal battle with veteran journalists. In June 2026, when Denmark experienced a disappointing opening match against Finland (losing 0-1) after Christian Eriksen's incident, veteran journalists in the newsroom wrote articles criticizing coach Kasper Hjulmand for "lacking tactical courage." I analyzed the data and discovered Denmark created the highest total xG in the group stage (3.6) across three matches, only behind France and Spain. I wrote a rebuttal, using pressing data and shot-creating actions to affirm Denmark's performance wasn't bad at all — they were just unlucky. The editor-in-chief, a "what you see is what you get" traditionalist, rejected my article citing "it goes against common perception." A week later, Denmark reached the semifinals. My article was published and became the most-read article of the month with 45,000 visits. The first data rebellion wasn't aimed at overthrowing anyone — just proving that numbers deserve to be heard. After the 2026 World Cup, I completely removed the word "surprise" from my analytical vocabulary. Instead, I learned to view every result through the lens of probability. Transfers are where people pay hundreds of millions to buy a row in a data table. In the transfer market, signing fees for free agents are more toxic than transfer fees; they circumvent the core scrutiny of FFP. The 5-substitution rule helps deeper squads, but also turns the final 20 minutes into attrition warfare. Data directly provided to betting companies is the darkest side effect of sports digitalization. From empty stadiums, I could hear the breathing of the match. The no-audience season is the cleanest laboratory football has ever had. That was when I realized football isn't just about beautiful goals or spectacular saves. Football is numbers, probabilities, models that can be wrong but can always be improved. I never write articles without specific data. Every tactical assessment must include at least 2 quantitative metrics, and I always cross-reference on-field results with expected data to avoid emotional conclusions. I began publicly disclosing the "model limitations" section at the end of every article, always providing confidence intervals instead of absolute assertions. This makes my articles more credible in the eyes of data-savvy readers. Correlation is not causation. This is the biggest lesson I've learned from 9 years of observing the sports industry. When Denmark lost to Finland, many rushed to conclude they were weak. But xG data showed they created more chances. When Man City pressed intensely, many thought they played defensively. But data showed they had complete ball control. Data doesn't lie; it's the people reading data who make excuses. And I, as an analyst, always try to listen to what data actually wants to say, rather than imposing what I want to hear. The final lesson: never underestimate the power of an Excel spreadsheet. From Man City's pressing numbers in 2026 to the World Cup 2026 prediction model, from the no-audience football research in 2026 to the battle with veteran journalists at Euro 2026 — everything started with a spreadsheet and a belief that numbers deserve to be heard. And when you listen closely enough, you'll hear the breathing of the match, the pulse of tactics, and even the whispers of the future.

Data Doesn't Lie: The Journey from Excel Spreadsheets to Modern Football Tactics

Data Doesn't Lie: The Journey from Excel Spreadsheets to Modern Football Tactics

Cầu thủ liên quan