The Arena of Inspiration: Why I Built a New Sumo Dashboard

As a Finance Analyst, I live in spreadsheets, pivot tables, and dashboards. My world is about taking complex data, finding the patterns, and presenting a clear story. Recently, my interest shifted from quarterly earnings to rikishi (Sumo wrestlers).

This November, my friends and I are heading to Japan to see the final Grand Sumo Tournament (Basho) of 2025 in Fukuoka! We’ve all recently gotten hooked on the sport, and naturally, our group chat exploded with stats and predictions.

I started looking for online dashboards we could use to easily track our favorite wrestlers and make informed predictions. What I found was often overly technical, cluttered, or just not user-friendly.

I didn’t need a complex academic tool; I needed a simple, clean dashboard that anyone in our group could use to see the unique factors—height, weight, and winning techniques—that influence the bouts. I wanted to share something easy for my friends to get excited about, and I wanted to learn to use coding in the process.

AI: The Ultimate Code Shortcut

My biggest obstacle was simple: I had strong analytical skills from my finance background, but no way to actually obtain the historical Sumo data. The solution came when I found a public Sumo API. The data was available; I just needed a way to ask for it. I decided to treat this project as my personal coding crash course, with Gemini as my technical co-founder. I didn’t master Python; I used AI to write the Python. I’d give it the prompt: “Connect to the data source, extract the entire history of bouts, and save it to a CSV file.” My ‘Aha!’ moment came when I successfully ran that first major extraction, seeing thousands of bout records instantly appear in my Google Drive. The barrier was broken, and I knew I could build a simple, powerful tool for the Fukuoka trip!

The Sumo Stats Pipeline: From Raw Data to Live Dashboard

Using my finance background in process design, I structured the data pipeline:

1. Extraction: Python code (written by Gemini) connects to the Sumo-API and pulls the raw data as a CSV.
2. Automation: I upload the CSV to Google Drive. Gemini then helped me write an App Script that automatically imports and updates the data into Google Sheets, keeping the dashboard current!
3. Visualization: I imported the data from Google Sheets into Looker Studio (Google’s dashboard tool), where I applied my analyst skills to design the visual layout—simple, clean, and focused on our key questions.

Sumo Stats is Born! Unique Insights for the Fukuoka Draft

The power of this dashboard lies in the unique insights we can now use to impress (and probably annoy) each other with predictions during the Fukuoka tournament. Plus, these stats will be critical for the Sumo Stable/Draft we’re planning, complete with trades and replacements throughout the tournament!

Here are a couple of my favorite findings so far:

1. Height and Weight Match-up Dynamics: It’s not a simple case of “heavier is better.” I found that the small rikishi actually perform quite well against the very heaviest opponents, often outmaneuvering them. However, they tend to struggle the most against the medium-weight wrestlers, who seem to possess the perfect balance of mass and agility to counter them. This discovery proves that it’s not just about size; it’s about the match-up dynamics.
2. The Daily Bout Winning Trend: By analyzing daily win/loss ratios across tournaments, I noticed a fascinating trend: some rikishi are truly “morning fighters” or “closers.” Certain wrestlers do exceptionally well on the early days of a tournament but fade later, while others are slow starters who dominate the final weekend. Tracking these patterns will give us a huge edge in our Stable/Draft picks!

The dashboard also provides deep dives into Kimarite (winning techniques) ratios, allowing us to see which technical moves are the most reliable. We’re going to be the most prepared group heading into Fukuoka!

Your Skills Are Transferable: A Call to Action

I started this project to create a simple tool for a trip with friends, with zero confidence in my coding ability. I finished it with a live, sophisticated dashboard and a newfound appreciation for what I can accomplish with AI assistance.

This journey is proof that:

1. Your professional skills are powerful, and they are transferable.
2. AI is an indispensable tool for turning personal ideas into reality.
3. You can and should use AI to adapt the skills you already have to new challenges!

If I can use my skills in SQL, pivot tables, and financial analysis to build a sophisticated Sumo dashboard, imagine what you can build by applying your expertise to your own passion project. Go find your AI co-pilot, and start building!