⟶ Portfolio / Data storytelling

Why a Kansas comeback?

Project
Data storytelling
Subject
KU Football
Role
Research + analysis
Course
JMC research in DMC
3 seasons
of stats
one story
⟶ / 01 — The numbers I found

A few headline stats.

46.35 %
Increase in offensive yards during the 2022–23 season
5,799
Total offensive yards in the 2023–24 season
3,121
Total passing yards in 2023–24 — a major year-over-year jump
3 ×
Seasons analyzed — 2021–22, 2022–23, 2023–24
⟶ / 02 — Why this project

Why this data, this story.

What initially drew me to this project was the rising momentum behind the University of Kansas football team — and the new stadium going up alongside it. I wanted to research how much the team has actually improved across three categories: offensive yards, defensive yards, and team leaders within both.

The hypothesis going in: if the program is genuinely on the rise, the numbers will say so. If the buzz is just hype, I’d find that too.

What I learned: there was a near-50% jump in offensive yards during the 2022–23 season — a single-season improvement big enough to argue, on the data alone, that something has fundamentally shifted. The story wasn’t a vibe. It was in the box score.

⟶ / 03 — How I built it

Four parts of the research process.

/ 01

Data collection

Pulled season stats for 2022–23 and 2023–24 from the official KU Athletics website. Copied raw data into Google Sheets. Cleared formatting, then went through every category and removed stats that didn’t serve the story — the cuts mattered as much as the keeps.

/ 02

Calculations & cleanup

Calculated percent change between seasons using (New − Old) / Old × 100 for passing and rushing yards. Sorted each season by KU colors so the data felt like the story even before any chart was built. Built a records-per-season sheet as supporting context for the script.

/ 03

Visualization in Flourish

Built stacked bar charts and a stacked-icon visualization in Flourish — with the icons changed to footballs and color-coded red (gains) vs. blue (losses). For team-leader data, my partner Brynn built interactive bubble charts with each player’s name, position, photo, and stats — three charts per season, nine total.

/ 04

Story assembly

Took the Flourish exports into Adobe Illustrator to add typography and alternate the color treatments, then dropped everything into a Google Slides presentation as the final deliverable. The visuals carried the headline stats — but the script wove individual player stories in to keep the data from feeling like just numbers.

⟶ The headline insight
46.35% jump in offensive yards in the 2022–23 season — the number that anchored the entire story.
— Source: KU Athletics, season totals 2021–22 → 2023–24
⟶ / 04 — The three main insights

What the data said.

  • / 01 Defensive yards allowed decreased across the three seasons — meaning fewer yards given up by KU’s defense, season over season.
  • / 02 Offensive yards jumped sharply — the 46.35% gain in 2022–23 plus a follow-up 1.86% increase in 2023–24 showed sustained, not flashy, improvement.
  • / 03 Top performers held the line. The number-one leader in passing, rushing, and tackles stayed pretty consistent each season — and grew. Stability at the top is what fuels the comeback.
⟶ / 05 — The takeaway

Data storytelling isn’t “add a chart to the deck.” It’s deciding which numbers earn the spotlight, and which ones get cut so the ones that matter can land.

  • The cuts are the story. I deleted more data than I kept. The percentage that didn’t make the slides is what made the slides work.
  • One headline stat per project. 46.35% became the anchor. Everything else either supported it or didn’t make the final draft.
  • Anecdotes fill in for emotion. Numbers explain what; player stories explain why anyone should care. The two have to share the page.
  • Your tool stack should match your story. Sheets for the math, Flourish for the visuals, Illustrator for the polish, Slides for the room. Use each one for what it’s good at.
⟶ The headline insight

46.35 %

jump in offensive yards in the 2022–23 season — the number that anchored the entire story.

Source: KU Athletics, season totals 2021–22 → 2023–24
⟶ / 04 — The three main insights

What the data said.

/ 01
Defensive yards allowed decreased across the three seasons — meaning fewer yards given up by KU’s defense, season over season.
/ 02
Offensive yards jumped sharply — the 46.35% gain in 2022–23 plus a follow-up 1.86% increase in 2023–24 showed sustained, not flashy, improvement.
/ 03
Top performers held the line. The number-one leader in passing, rushing, and tackles stayed pretty consistent each season — and grew. Stability at the top is what fuels the comeback.
⟶ Up next

More case studies.