analytical by nature
organized by habit
curious by design
Hi, I’m Jake — a detail-driven data and operations specialist who loves turning chaos into clean systems and raw data into real insight.
With a background in managing complex projects, streamlining processes, and editing everything from technical documentation to team workflows, I’ve built a career on clarity: clear communication, clear information, clear results. Whether I’m working in SQL, Excel, or Tableau, my goal is the same — to help teams work smarter and make decisions backed by well-organized, well-understood data.
I’ve created dashboards on housing trends, designed systems that keep people (and data) on track, and developed a serious appreciation for a well-structured spreadsheet. I enjoy simplifying complexity, finding the story in the numbers, and building tools that make work feel less like... well, work.
When I’m not refining a process or querying a database, I’m probably copious amounts of coffee or playing an intense game of "What's in your mouth?!" with my dog.
Let’s connect — especially if you're looking for someone who blends communication, coordination, and analytical thinking with a bit of humor and a lot of precision.
SQL Meets Suburbia
Ever wondered what insights lie behind Zillow’s mountain of real estate listings? This project tackles that question by transforming raw CSVs into a structured SQL database and then into interactive Tableau dashboards. From price trends to school proximity, I used MySQL and Tableau to explore the dynamics of the U.S. housing market — one query at a time.
view more projects
Selling to America
Retail Insights with Excel's Full Power
Flip on the news and you’ll likely hear talk of China challenging America’s economic crown. But for now, the U.S. remains at the forefront of global consumer spending — and this project dives into the numbers behind that accomplishment. Using Excel as my analytical scalpel, I dissected a simulated US online retail dataset to unearth the trends, behaviors and metrics that power e-commerce.
Prime Time
Unboxing Amazon Sales with SQL & Tableau
Amazon isn't just a retailer — it's a data machine. From order fulfillment to shipping success rates, the company leaves a breadcrumb trail of metrics. In this project, I rolled up my sleeves and dove into a simulated Amazon dataset to uncover the KPIs behind the clicks. Think of it as an unboxing video for data enthusiasts everywhere.
Excel in Aisle 5
Walmart Analytics on a Budget
Sometimes, less really is more — especially in Excel. In this project, I dive into a lean yet telling dataset simulating Walmart customer behavior. With limited fields and a dash of creativity, I assembled a full suite of analysis, KPI summaries, and dashboards to extract insight from the everyday. The goal? Show how even smaller datasets can pack a big punch when paired with the right structure and logic.
Tableau Public
See projects past and present on my Public Tableau, where I display projects from these projects and beyond.