From Siloed Stats to Unified Player Value: The Indian Cricket League (ICL) Transformation
Project Overview
The Indian Cricket League (ICL) is one of the world’s most prestigious and data-driven sports leagues. Its success depends on accurate insights into player performance, fitness, and value during high-stakes auctions. However, with performance, biometric, and financial data scattered across multiple systems, the league lacked a unified view of player performance. To address this, ICL launched a transformative analytics initiative using Microsoft Fabric to integrate all data sources and deliver real-time, actionable insights through a unified Player Value Score.
The Challenge
ICL’s data world was in chaos. Performance stats, fitness data, and salaries all lived in separate, mismatched systems — no one spoke the same data language. Analysts spent weeks trying to piece it all together, often confusing players like “R. Sharma” and “Rohan Sharma.” By the time reports were ready, they were outdated and unreliable. Trust eroded, decisions suffered, and costly auction mistakes followed.
-
Scattered Data Sources: Performance, fitness, and salary data existed in disconnected systems with no common structure.
-
Inconsistent Player Identity: Different naming formats (“R. Sharma” vs. “Rohan Sharma”) made it impossible to link information accurately.
-
Slow, Manual Reporting: Analysts spent weeks compiling data, leading to outdated insights.
-
Low Data Trust: Teams questioned report accuracy, weakening confidence in decisions.
-
Costly Outcomes: Poor data reliability led to misguided auction choices and financial losses.
Solution Overview
he ICL data transformation story is about turning chaos into clarity. By building an end-to-end analytics ecosystem on Microsoft Fabric, we unified disconnected data streams — from stadium sensors to salary sheets — into one trusted view of every player.
Transformation Logic – Spark Takes the Field'
-
Apache Spark is the powerhouse behind real-time player stats.
-
One PySpark function now processes terabytes of JSON data, aggregates runs, wickets, and speeds, and joins it with salary and biometric info.
-
What once took analysts four weeks now runs in minutes — fast, reliable, and repeatable
Architectural Choice – The Lakehouse Foundation
he ICL data transformation story is about turning chaos into clarity. By building an end-to-end analytics ecosystem on Microsoft Fabric, we unified disconnected data streams — from stadium sensors to salary sheets — into one trusted view of every player.
-
The Lakehouse became the league’s single source of truth — breaking silos between teams, vendors, and departments.
-
It unites structured (Excel), semi-structured (JSON), and streaming data in one space.
-
Features like unified storage, easy Power BI access, and scalable compute made it the backbone of ICL’s data modernization.
Data Reliability – Delta Lake Builds Trust
-
The Lakehouse became the league’s single source of truth — breaking silos between teams, vendors, and departments.
-
It unites structured (Excel), semi-structured (JSON), and streaming data in one space.
-
Features like unified storage, easy Power BI access, and scalable compute made it the backbone of ICL’s data modernization.
End-to-End Value – The Power of One Platform
-
From raw sensor feeds to the final Player Value Score, every step is automated within Microsoft Fabric.
-
Coaches get daily insights on fatigue and form; executives get a single, reliable score to guide auction bids.
-
The league has moved from gut-feel to data-driven confidence, powered by one unified platform.
A comprehensive executive presentation was developed to visually showcase this transformation — highlighting the architecture, tooling choices, and the business impact of the unified analytics platform.
Strategic Tooling – From Manual Uploads to Automation
-
The Finance team’s salary sheets (Player_Contracts.xlsx) are now ingested through Dataflow Gen2, a low-code tool that cleans and formats data automatically using Power Query.
-
No matter when new files arrive, they’re standardized instantly — no waiting for IT.
-
For complex feeds like Ball_by_Ball.json and Player_Biometrics.csv from 8 stadiums, Fabric Pipelines handle the heavy lifting — automating large daily ingestions at scale.