// about

Bill Campbell

Sr. BI Developer · Sr. Data Steward · Jukebox Restoration Enthusiast · Cyclist

Jukeboxes and SQL! Not a combination you hear often, but both are basically the same job: figure out why something isn’t working, find the elegant solution hiding inside the mess, and make it run smoothly enough that nobody has to think about it again.

My journey into data began in 2018, spanning BI, solution engineering, and data stewardship. I love SQL joins and window functions. What keeps me engaged isn’t the dashboards at the end, it’s the query that gets you there. I currently work in SQL, Python, and LookML, and I lean into AI wherever it makes the work sharper or faster. I spent my early days in data creating automation with VBA and Excel. Amazing what you can build when that’s all you have.

When I’m not banging away at a keyboard or recapping an amp, you can usually find me on a bicycle or kayak, adding miles to the fitness stats.

Tools & technologies

SQL Python Looker Excel / VBA AI Problem Solver

// weather, wherever you're reading this from

fetching…
// activity

Fitness Stats

Personal stats synced from Strava

All-time stats
Miles ridden
4,114.4
235 rides
Bike elevation
47,256 ft
feet climbed cycling
Miles kayaked
66.5
17 paddles
Total activities
252
rides + kayaks
Avg miles / ride
17.5
per ride average
Avg ride speed
12.9 mph
weighted average
Sep 2026 — weekly breakdown
Week Rides Bike mi Elev ft Avg mph Kayaks Kayak mi Avg mph
Wk 1 1 14.1 117 12.6 -- -- --
Total 1 14.1 117 12.6 -- -- --
Year × Month
2026
Month Rides Bike mi Elev ft Avg mph Kayaks Kayak mi Avg mph
Feb 1 14.6 105 11.1 -- -- --
Mar 2 29.0 245 12.2 -- -- --
Apr 1 14.4 130 11.9 -- -- --
May 1 10.9 64 6.1 1 3.6 2.9
Jun 8 141.6 1,329 13.4 1 4.2 2.6
Jul 11 200.0 1,936 12.7 -- -- --
Aug 8 202.1 2,521 12.6 -- -- --
Sep 1 14.1 117 12.6 -- -- --
2026 Total 33 626.7 6,447 12.6 2 7.8 2.7
2025
Month Rides Bike mi Elev ft Avg mph Kayaks Kayak mi Avg mph
Feb 1 10.3 119 13.5 -- -- --
Mar 6 117.9 1,138 13.1 -- -- --
Apr 3 65.0 641 12.9 -- -- --
May 7 89.1 835 11.9 -- -- --
Jun 7 108.8 1,076 12.1 -- -- --
Jul 5 37.9 369 12.3 -- -- --
Aug 6 153.4 1,905 13.9 -- -- --
2025 Total 35 582.4 6,083 12.9 -- -- --
2024
Month Rides Bike mi Elev ft Avg mph Kayaks Kayak mi Avg mph
Feb 5 33.3 238 12.3 -- -- --
Mar 8 112.1 926 12.4 -- -- --
Apr 8 138.8 1,288 12.5 -- -- --
May 10 212.0 2,370 13.3 -- -- --
Jun 23 403.9 4,153 12.9 1 3.0 2.7
Jul 14 322.2 3,355 13.7 -- -- --
Aug 11 322.0 3,863 14.0 -- -- --
Sep 8 190.5 4,964 13.1 -- -- --
Oct 2 30.9 273 12.2 1 2.5 2.7
Nov 1 17.3 173 14.2 -- -- --
2024 Total 90 1,783.0 21,603 13.2 2 5.5 2.7
2023
Month Rides Bike mi Elev ft Avg mph Kayaks Kayak mi Avg mph
Jan 1 12.1 109 12.0 -- -- --
Feb 3 44.8 415 11.7 -- -- --
Mar 2 32.4 311 12.1 -- -- --
Apr 1 15.2 101 11.2 -- -- --
May 6 98.6 1,930 12.3 -- -- --
Jul 6 59.1 986 12.1 -- -- --
Aug 2 44.6 490 14.2 -- -- --
2023 Total 21 306.8 4,342 12.4 -- -- --
2022
Month Rides Bike mi Elev ft Avg mph Kayaks Kayak mi Avg mph
Jan 5 60.5 653 11.6 -- -- --
Feb 5 60.7 548 11.9 -- -- --
Mar 9 112.4 1,279 12.6 -- -- --
Apr 5 104.5 1,275 12.9 1 3.4 3.2
May 2 24.9 294 13.2 1 2.1 2.9
Jun 3 24.0 158 12.9 2 10.2 2.7
Aug 2 22.4 264 12.9 -- -- --
Sep 3 52.3 648 12.8 -- -- --
2022 Total 34 461.7 5,119 12.5 4 15.7 2.8
2021
Month Rides Bike mi Elev ft Avg mph Kayaks Kayak mi Avg mph
Aug 3 37.6 327 13.3 -- -- --
Sep 14 223.4 2,328 12.6 5 14.8 3.5
Oct 5 92.8 1,008 12.5 3 16.7 3.0
Dec -- -- -- -- 1 6.0 3.2
2021 Total 22 353.8 3,663 12.6 9 37.5 3.2
// workshop

Jukebox rebuilds

Classic machines brought back to life

All builds 3 machines
USC1
1970 · Seeburg
Teardown underway. Mechanical changer and amp recap in progress. Suspecting more mechanical issues than electronic on this one.
In Progress
→ View build
R-93
1987 · Rowe AMI
This is a 1987 Rowe AMI R-93 located in The Red Key Tavern (Indianapolis Indiana). This was the last machine that wasn't a TouchTunes owned by this vending company. After being nonfunctional for 2+ years, they decided to transfer ownership to the Red Key. Now we could work on it. This machine was built at the crossroads of two eras digital and analog. This machine can take a slightly modified off the shelf Pioneer 6 disc changer and play CD's in addition to 45's. The CD player was removed years ago after failure. But the real issue here is the volume is uncontrollable, fine for a bit then goes full blast. The vending company removed all there locks, so we had to source new ones for the machine as well.
Complete
→ View build
3100
1967 · Wurlitzer
Cabinet cleaned up, Amp recapped, Fixed record lift arms, and solenoid on selector ring. Replaced needle, drive belts, lubed motor. Replaced broken buttons.
Complete
→ View build
    // travel

    Places & photos

    Albums by trip — filter by tag

    Portugal Fall 2022 cover photo
    Portugal Fall 2022
    2022 · Lisbon PT, Cordaba ES, Seville ES, Grenada ES, Lagoa PT
    Denver CO Winter 2020 cover photo
    Denver CO Winter 2020
    2020 · Denver
    Bonita Springs FL Spring 2019 cover photo
    Bonita Springs FL Spring 2019
    2019 · Bonita Springs
    NoLa Fall-2017 cover photo
    NoLa Fall-2017
    2017 · New Orleans
    Admin

    Admin panel

    Manual controls

    This section requires admin login.