← Back to blog
🌽
For the CornBelters

A Shared Analytics
Workspace for Interns

Built to help Kernelytics interns upload data, analyze faster, and publish better work

What makes this a fit

Established program

Kernelytics is already real

The 2025 Kernelytics blog says the program returned for a fourth season and was built around 9 summer interns with different baseball and analytics backgrounds.

Real analysis

Interns are doing advanced work

Projects included UZR, catch probability, xwOBA, Stuff+, clutch hitting analysis, power rankings, and a KCL Baseball Savant concept.

Better workflow

A shared platform helps everyone

Instead of each intern working from separate files and one-off logic, the team can share data, queries, definitions, and outputs in one place.

How this helps interns

Learn modern tools

Interns get hands-on experience with BigQuery, shared datasets, repeatable SQL, and dashboard-style outputs instead of only spreadsheet work.

Spend less time cleaning

Uploaded files can flow into common tables, so interns spend more time analyzing baseball and less time rebuilding inputs every week.

Publish more polished work

Shared definitions and reusable tables help blog posts, league reports, and visuals stay more consistent across the full Kernelytics team.

What the workspace would include

Upload zone
A shared place for CSV exports, game data, player files, and other intern data drops.
BigQuery tables
Organized raw, cleaned, and reporting-ready datasets for hitters, pitchers, defense, and league metrics.
Analysis layer
Reusable SQL, starter queries, and optional notebook support for deeper projects.
Output layer
Dashboards and article-ready outputs that are easier to share across interns and staff.

Simple structure

  • raw dataset for source uploads
  • staging dataset for cleaned transformations
  • mart dataset for finalized metrics and reporting tables
  • sandbox dataset for intern experimentation
  • shared storage bucket for file uploads
  • dashboard layer for easy viewing and sharing

Why this is affordable

1 TiB
free BigQuery query processing each month
10 GiB
free BigQuery storage each month
Free
batch loads into BigQuery using the shared default pipeline
Low risk
cost controls can be used to keep intern activity within budget
File uploads
Very low
Storage
Low
Queries
Manageable
AI tooling
Selective

Built for the current intern mix

The 2025 Kernelytics group included interns studying statistics, finance and business analytics, computational modeling and data analytics, sports administration, data science, and computer science and mathematics, which makes a shared workspace especially useful because it supports both technical and less-technical contributors.

For data-focused interns

Query data directly, test new models, and build reusable metrics.

For baseball ops interns

Use curated tables and dashboards without needing to engineer raw datasets from scratch.

For content-focused interns

Pull trusted numbers and visuals into blog posts, weekly updates, and shareable reports.

How the team could use it right away

Weekly reports

Standardized hitter, pitcher, defensive, and league leaderboards that update from the same data foundation.

Blog content

Cleaner tables and repeatable calculations for Kernelytics articles, player spotlights, and game recap insights.

Future projects

A better platform for things like KCL Baseball Savant-style tooling, expected stats models, and scouting summaries.

Next steps

Get on the project
and get started

Contact Jarret to have people added to the new Google Cloud project and to receive details on how to get started.

jrodgers@cornbeltersbaseball.com

1 / 8