Celtics Championship DNA

📊 Championship Dominance Ranking

SELECT team_name, year, wins, losses,
ROUND(win_pct * 100, 1) as win_pct,
RANK() OVER (ORDER BY win_pct DESC) as dominance_rank
FROM championship_teams
ORDER BY win_pct DESC

Rank	Team	Year	Record	Win %	PPG
1	2024 Celtics	2024	64-18	78.0%	120.6
2	2020 Lakers	2020	52-19	73.2%	113.4
3	2023 Nuggets	2023	53-29	64.6%	115.8
3	2022 Warriors	2022	53-29	64.6%	111.0
5	2021 Bucks	2021	46-26	63.9%	120.1

Key Insight: The 2024 Celtics posted the best regular season record among recent champions with a 78.0% win rate, winning 64 games. This 14-game improvement over the 2020 Lakers (2nd place) demonstrates exceptional dominance throughout the season.

⚡ Offensive Firepower

Team	PPG	FG%	3P%	APG	Rating
2024 Celtics	120.6	48.7%	38.8%	26.9	Elite Offense
2021 Bucks	120.1	48.7%	38.9%	25.5	Elite Offense
2023 Nuggets	115.8	50.4%	37.9%	28.9	Strong Offense
2020 Lakers	113.4	48.0%	34.9%	25.4	Good Offense
2022 Warriors	111.0	46.9%	36.4%	27.1	Good Offense

Key Insight: The Celtics led all recent champions in scoring at 120.6 PPG, combining elite three-point shooting (38.8%) with balanced offense. Their 26.9 assists per game shows team-oriented play.

🎯 Ball Movement & Security

Team	APG	TOV	AST/TO Ratio	Ball Security
2024 Celtics	26.9	11.9	2.26	Excellent
2023 Nuggets	28.9	14.5	1.99	Good
2021 Bucks	25.5	13.8	1.85	Good
2022 Warriors	27.1	14.9	1.82	Good
2020 Lakers	25.4	15.2	1.67	Average

Key Insight: The Celtics' 2.26 assist-to-turnover ratio was the best among recent champions, indicating superior ball control and smart decision-making. They generated assists while minimizing mistakes.

📋 Methodology

Data Sources: Team statistics scraped from Basketball-Reference.com for NBA champions from 2020-2024.

Database: SQLite database with normalized schema (championship_teams table) containing 14 key performance metrics per team.

SQL Techniques Used:

Window functions (RANK() OVER) for comparative rankings
CASE statements for categorical classification
Aggregate functions and calculated metrics (win percentage, ratios)
Multi-criteria composite scoring formula

Key Finding: The 2024 Celtics rank #1 across multiple dimensions: highest win percentage (78.0%), most points per game (120.6), and best composite championship score (88.6), establishing them as the most dominant recent NBA champion.

🏆 Celtics Championship DNA

📊 Championship Dominance Ranking

⚡ Offensive Firepower

🎯 Ball Movement & Security

📋 Methodology