Sports Analytics · Business Intelligence
Business Analytics & Sports Management student turning raw data into actionable insights — building tools with Python, SQL, and Power BI at the intersection of sports and data science.
Multi-page Power BI dashboard analyzing fan behavior, ticketing, and social media data using MySQL and DAX.
Built a proxy Game Attractiveness Score using SQL and Tableau to analyze scheduling and opponent factors driving home game demand.
Python-based scoring predictor using live web-scraped stats from Basketball-Reference with home/away adjustments.
A retrieval-augmented generation agent that answers plain-English NBA questions grounded in real 2025-26 season data via Claude.
Tracked and analyzed 112 of my own shot attempts from film — location, play type, contest level — to uncover my true shooting profile.
A multi-page analytics dashboard built with synthetic sports data
A multi-page Power BI analytics dashboard using AI-generated ticketing, social media, and fan survey data. Used modeled datasets in MySQL, SQL joins, and DAX measures to analyze relationships between fan engagement, revenue, and game demand — replicating how a professional sports organization might approach business intelligence.
Used AI to generate synthetic data of realistic fan datasets. Four CSV files with 100+ rows each:
Datasets were created into a MySQL database to ensure all data was isolated in a structured schema. Two tables were designed to support ticketing and social analytics:
CREATE DATABASE IF NOT EXISTS ticketing_analytics;
USE ticketing_analytics;
CREATE TABLE social_metrics (
date DATE,
followers INT,
engagement_rate FLOAT,
posts INT,
video_views INT
);
CREATE TABLE ticket_sales (
game_id INT PRIMARY KEY,
date DATE,
opponent VARCHAR(100),
attendance INT,
revenue FLOAT
);
game_id acts as a primary keydate serves as the relational join key between ticket and social dataCSV files were directly imported into MySQL:
LOAD DATA INFILE '.../social_metrics.csv' INTO TABLE social_metrics FIELDS TERMINATED BY ',' ENCLOSED BY '"' IGNORE 1 ROWS; LOAD DATA INFILE '.../ticket_sales.csv' INTO TABLE ticket_sales FIELDS TERMINATED BY ',' ENCLOSED BY '"' IGNORE 1 ROWS;
To analyze the relationship between digital engagement and ticket performance, a relational join was performed:
SELECT
t.date,
t.opponent,
t.attendance,
t.revenue,
s.engagement_rate,
s.video_views,
s.posts
FROM ticket_sales t
JOIN social_metrics s
ON t.date = s.date;
Tools & Technologies
Exploring scheduling and opponent factors that influence fan interest in home games
This project explores how scheduling and opponent factors influence fan interest in Boston Celtics home games. Using SQL for data preparation and Tableau for visualization, the goal is to uncover patterns in demand and demonstrate how data can support decision-making in sports business operations.
The dataset was sourced from Basketball Reference and includes Celtics game schedule information. Data was cleaned and structured in SQL, with key fields including game number, opponent, game timing, and indicators such as home/away and special event games. The dataset was filtered to focus on home games only.
Data Before Cleaning (CSV)
1. Drop Unwanted Columns
2. Filtered Home Games
3. Split Date Column
A custom "Game Attractiveness Score" (G.A.S) was developed as a proxy for demand due to limited attendance variability in the dataset. The score assigns weighted values based on key demand drivers including weekend games, marquee opponents, and special game contexts.
Attractiveness Score Formula
Scoring Metrics
Tools & Technologies
A live data-driven model for predicting NBA player scoring output
Using online data from Sports Reference, can there be a model that accurately predicts an NBA player's Points Per Game on any given night during the NBA season?
Found player and team statistics from Sports Reference for the model:
Predicted_PPG = Current_PPG - (DRtg_ADJ) +/- (Home Court Factor)
Built guided user parameters so the model accepts a player name, team abbreviation, and game location (Home or Away). Live web scraping pulls Team PPG, Individual PPG, and Team Defensive Rating directly from Basketball-Reference.
Abbreviation Dictionary
Main Function
Tools & Technologies
A retrieval-augmented generation system for querying the 2025-26 NBA season in plain English
Instead of manually digging through stat tables, this agent lets you ask plain-English questions and get answers grounded in real data — searching across 9 Basketball Reference datasets, retrieving the most relevant chunks, and using Claude to generate a cited, structured answer.
Nine Basketball Reference datasets, embedded directly as structured text — no external database or file reads required.
scikit-learn TF-IDF vectorizer scores each chunk against the user's questionClaude reads only the retrieved passages — never its own training memory — and writes a structured, cited answer referencing the source document and date for every stat it uses.
Tools & Technologies
Turning a season of film study into a data-driven shooting profile
After finishing my third college basketball season, I wanted to take a deeper look at the types of shots and offensive opportunities I received throughout the year. Our team uses Synergy Sports Technology to review film, which tags shot types like "Spot-Up" or "Cut" — but I wanted to go a step further and understand not just what shot I took, but how and where I got it, the offensive context around it, and the quality of the look. From a player-development standpoint, this let me identify strengths, weaknesses, and where I could improve.
Reviewed all 112 offensive possessions in which I shot the ball, manually tracking six categories per shot:
Built two reusable functions — one to summarize shot data by any grouping column, and one to plot a grouped bar chart of shot percentage with Plotly Express. Reused across every chart in the script.
def summarize_shot_data(df, group_col):
"""
Summarizes shot data by the given grouping column(s),
calculating total shots, made shots, and make percentage.
"""
summary = (
df.groupby(group_col)
.agg(
total_shots=('result', 'count'),
made_shots=('result', lambda x: (x == 'Make').sum()),
shot_percentage=('result', lambda x: (x == 'Make').mean() * 100),
)
.reset_index()
)
summary['shot_percentage'] = summary['shot_percentage'].round(1)
return summary.sort_values(by='shot_percentage', ascending=False)
def plot_shot_percentage(summary, x_col, color_col, title, palette):
"""
Builds a grouped bar chart of shot percentage, split by
x_col and colored by color_col. Reused for every chart.
"""
fig = px.bar(
summary, x=x_col, y='shot_percentage', color=color_col,
color_discrete_sequence=palette, barmode='group',
text='shot_percentage', title=title, template='plotly_white',
)
fig.update_traces(texttemplate='%{text}%', textposition='outside')
return fig
Tools & Technologies
Sharing sports data insights, charts, and analysis. Follow along for more.
A class project on the MLB has me thinking. Does money buy rings? 11 of 15 World Series champs ranked top 9 in payroll.
Breaking down the 2025-26 Celtics through Dean Oliver's Four Factors. FG% drove wins in December. OREB rose in February to compensate for poor shooting — and it worked!
I'm Declan Davis, a Business Analytics & Information Systems and Sports Management student at Suffolk University's Sawyer Business School (anticipated May 2027) with a passion for using data to drive decisions in the sports world.
I'm currently a Business Intelligence and Operations Intern with the Boston Celtics, and I've previously worked with The Tournament (TBT/TST) and ShotQuality. Outside of internships, I build fan intelligence dashboards and predictive scoring models for the NBA — projects that have real-world relevance in sports strategy and operations.
My toolkit includes Python, SQL, MySQL, Power BI, DAX, and Excel — and I'm always looking for new ways to apply data science to sports problems.