Go Back  Bike Forums > Bike Forums > Hybrid Bicycles
Reload this Page >

Hybrid market data spreadsheet

Notices
Hybrid Bicycles Where else would you go to discuss these fun, versatile bikes?

Hybrid market data spreadsheet

Old 11-07-20, 03:43 PM
  #1  
interungulate
Senior Member
Thread Starter
 
interungulate's Avatar
 
Join Date: Nov 2014
Location: SF Bay Area and Santa Barbara, CA
Posts: 106

Bikes: 2015 Womens CAAD10 5 (now a 1-by SRAM system)

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 1 Post(s)
Liked 2 Times in 2 Posts
Hybrid market data spreadsheet

Hello! I put together a sort of market research spreadsheet with components/descriptors for 285 hybrid models across 19 US-available manufacturers with data from September 2020, and I wanted to share the data in case someone else could use it.

Both the dataset itself (Excel file) and an explainer about methodology and stuff is available at setsailfor.space/hybrid-market-spreadsheet-explainer. Some things of note: I included models advertised as hybrid, fitness, commuter, city, urban, and anything that sounded like those words, but excluded fixies, electric bikes, and stuff marketed specifically as road or mountain, and also excluded anything with drops. These were a little arbitrary as distinctions, but I think they make sense in separating out the groups of models that would obscure trends in the data.

I'm going to use this data to finish up a first-time hybrid buyer's guide, but otherwise had pretty much no set goal for it. Since it's all off of manufacturers' public websites, I think I'm legally allowed to say you can just download the dataset and do whatever you want with it. No guarantees on it being completely typo-free, but I did try pretty hard.

[edited for formatting]
interungulate is offline  
Likes For interungulate:
Old 11-07-20, 08:30 PM
  #2  
crn3371
Member
 
Join Date: Oct 2020
Posts: 40
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 27 Post(s)
Likes: 0
Liked 13 Times in 10 Posts
Wow 😱
crn3371 is offline  
Likes For crn3371:
Old 11-08-20, 07:13 AM
  #3  
fishboat
Senior Member
 
Join Date: Feb 2016
Location: SE Wisconsin
Posts: 892

Bikes: Lemond '01 Maillot Jaune, Lemond '02 Victoire, Lemond '03 Poprad, '79 AcerMex Windsor Carrera Professional(purchased new), '06 Bianchi Volpe, '88 GT Tequesta(purchased new), '01 Bianchi Grizzly, 1993 Trek 970 drop bar conversion

Mentioned: 8 Post(s)
Tagged: 0 Thread(s)
Quoted: 326 Post(s)
Likes: 0
Liked 194 Times in 114 Posts
Nice work up and a fair amount of work..thanks for putting this together. I was a market-logistics-data analyst prior to retiring. Much of my work involved modeling global logistics networks. I've not heard of Flourish, though I've been out of that business for a while now. I used Tableau for most of my visualizations. Modeling was done in software that is a world apart from Tableau/Flourish.

In any event, I like the plots..very interesting and nicely done. I would typically use plots like this to get a feel of what the data was saying and to emphasize specific points in a presentation(the sunburst diagram on market segmentation is nice). My audience (consumers of my work) was generally upper management and C-level folks. While a few (very few) were data-oriented, in general they had little patience for digging into lots of plots to answer questions..that's what they had me for. Often I would prepare one or more user-driven dashboards that was easy to filter down and answer (their) questions. I'd have a graphical workup with a half dozen filters (on/off, sliding scale..etc..) that would quickly narrow things down without them having to think too hard..questions are easy, answers actually require work.

With a couple filters clicked, one could answer a (completely arbitrary, I ride primarily road and mountain bikes) question like, "I want a triple crank, Tiagra components or above, rim brakes, and it has to fit 50mm tires..what bikes should I look at?" Four on/off filters would result in a list of Mfgs and models, along with price..etc..

fwiw..Tableau has "Tableau Public" software that anyone can use free..here's a gallery of all kinds of dashboards:
https://public.tableau.com/en-us/gal...&type=featured

Great work..if I were in the market for a new hybrid, this would be a gold mine of info..
fishboat is offline  
Old 11-08-20, 03:52 PM
  #4  
interungulate
Senior Member
Thread Starter
 
interungulate's Avatar
 
Join Date: Nov 2014
Location: SF Bay Area and Santa Barbara, CA
Posts: 106

Bikes: 2015 Womens CAAD10 5 (now a 1-by SRAM system)

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 1 Post(s)
Liked 2 Times in 2 Posts
Thanks for the tip about Tableau! I don't really do much data vis (clearly), Flourish popped up as a resource somewhere and was useful enough that I didn't look much further.

The answers are definitely more difficult to generate than the questions I'm trying to do a little more of those kinds of data-driven value judgments with the other write-up I'm working on that's more geared toward people who don't necessarily have experience in bikes, but here I tried not to get into that too much since I assume people interested in a granular spreadsheet would have more specific opinions going into it.

I'm also predominantly a roadie, and one of the things I really love about the hybrid market is the amount of diversity. I was kind of trying to mimic with the spreadsheet that user-driven dashboard you were talking about (since Excel has a pretty decent filtering system), but I have nowhere near the kind of data visualisation skillset to present that in a more visually appealing way. I'll definitely have a look at Tableau - I didn't have much luck with Flourish's filtering models, and that would be a great thing to add.
interungulate is offline  
Old 11-08-20, 05:02 PM
  #5  
fishboat
Senior Member
 
Join Date: Feb 2016
Location: SE Wisconsin
Posts: 892

Bikes: Lemond '01 Maillot Jaune, Lemond '02 Victoire, Lemond '03 Poprad, '79 AcerMex Windsor Carrera Professional(purchased new), '06 Bianchi Volpe, '88 GT Tequesta(purchased new), '01 Bianchi Grizzly, 1993 Trek 970 drop bar conversion

Mentioned: 8 Post(s)
Tagged: 0 Thread(s)
Quoted: 326 Post(s)
Likes: 0
Liked 194 Times in 114 Posts
There should be, at least there were, tons of video tutorials available on the Tableau website, or elsewhere. They have (had..I retired and left it all behind) a huge and enthusiastic user-base. I think Tableau was sold to Salesforce? in recent years, not sure if anything has changed. Tableau can use Excel as a datasource, or any of the common databases.
fishboat is offline  
Likes For fishboat:
Old 11-09-20, 11:51 AM
  #6  
Donlaw
Junior Member
 
Join Date: Jul 2014
Posts: 8
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 1 Post(s)
Likes: 0
Liked 2 Times in 2 Posts
Thanks for putting this together. Nicely done and very interesting.
Donlaw is offline  
Likes For Donlaw:
Old 11-11-20, 10:09 AM
  #7  
JaccoW
TallDutchUltraRomance :P
 
JaccoW's Avatar
 
Join Date: Oct 2011
Location: Rotterdam, The Netherlands
Posts: 1,745

Bikes: Batavus Randonneur GL, Gazelle Orange Excellent, Gazelle Super Licht, Gazelle Grand Tourist

Mentioned: 39 Post(s)
Tagged: 0 Thread(s)
Quoted: 573 Post(s)
Liked 506 Times in 323 Posts
Paging @RiddleOfSteel

Seems like we can gather some inspiration for our presentation from here.

He has made a comprehensive list of 66cm Koga-Miyata models in the The Koga-Miyata 66cm Club - A Comprehensive Listing thread and I have started something similar to this for the Show us your Koga-Miyata! thread using stated weight for certain models over the years.

Specifying models as hybrids has been a bit tricky over the years since the later 80's and early 90's had some crossover at times as well as clearer differentation between touring, mtb and hybrid models that would be called hybrids nowadays.




Last edited by JaccoW; 11-11-20 at 10:15 AM.
JaccoW is offline  
Likes For JaccoW:
Old 11-11-20, 12:49 PM
  #8  
RiddleOfSteel
Master Parts Rearranger
 
RiddleOfSteel's Avatar
 
Join Date: Mar 2015
Location: Seattle, WA
Posts: 3,373

Bikes: A rotating assembly...ha, get it???

Mentioned: 188 Post(s)
Tagged: 0 Thread(s)
Quoted: 1110 Post(s)
Liked 471 Times in 311 Posts
Indeed we can! Man, I never thought I'd be in the Hybrids sub-forum, but here I am. I wonder how similar the Koga-Miyata hybrid story is to the rest of the industry as it evolved from a few bicycle architypes, slowly becoming more defined as time went along.

After digging through the Koga-Miyata catalogs from 1984 through 2018, the differentiation between a hybrid, comfort, town & country, and (light) touring bike seemed primarily in name and handlebar type--upright vs. flat bar vs. butterfly bar (touring, trekking). At least in the 66cm offerings, the frame geometry was incredibly similar between all categories (and for several decades), as was the use of Deore LX as a groupset. Thinking back some more here, though, the step-through design evolved throughout those years to what they are today, which I think is good as a proper step-through is much more than a dropped top tube a la a vintage mixte frame (as lovely as those look).

Marktplaats over in the Netherlands is a great place to find Kogas as that is where they originated from. Nevertheless, cataloging 66cm frames had me looking at many non-race and non-touring models, in all of their fun (to me) names. The Prominence model was perennially offered in that 66cm size, so it was pretty cool to see one for sale--no company ever showcases the smallest and largest version of a bike model--it was a bit of a celebrity moment in that regard.

One of two 66cm Prominences are for sale presently, so I snagged a photo. Handsome bike, and this one has their "feather" suspension fork (think Cannondale Head Shok).

RiddleOfSteel is offline  
Likes For RiddleOfSteel:
Old 11-13-20, 09:06 PM
  #9  
interungulate
Senior Member
Thread Starter
 
interungulate's Avatar
 
Join Date: Nov 2014
Location: SF Bay Area and Santa Barbara, CA
Posts: 106

Bikes: 2015 Womens CAAD10 5 (now a 1-by SRAM system)

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 1 Post(s)
Liked 2 Times in 2 Posts
That weight trends graph is so interesting! I would not have guessed it would trend upward over the years, I wonder what that's about.

And cool to see the same general concept of research but applied over time with a specific manufacturer, that's a direction of data I hadn't even considered. Really interesting, thank you for linking!
interungulate is offline  
Likes For interungulate:
Old 11-16-20, 12:14 AM
  #10  
JaccoW
TallDutchUltraRomance :P
 
JaccoW's Avatar
 
Join Date: Oct 2011
Location: Rotterdam, The Netherlands
Posts: 1,745

Bikes: Batavus Randonneur GL, Gazelle Orange Excellent, Gazelle Super Licht, Gazelle Grand Tourist

Mentioned: 39 Post(s)
Tagged: 0 Thread(s)
Quoted: 573 Post(s)
Liked 506 Times in 323 Posts
Originally Posted by interungulate View Post
That weight trends graph is so interesting! I would not have guessed it would trend upward over the years, I wonder what that's about.

And cool to see the same general concept of research but applied over time with a specific manufacturer, that's a direction of data I hadn't even considered. Really interesting, thank you for linking!
I haven't entered all the data for the 2000 till now period but my guess is you will see a decrease again in the 2010+ period. In short, I remember bikes in this period and Dutch bikes in particular to just add more and more small luxuries to make the bike more comfortable i.e. full suspension touring bikes. But all that extra complexity only makes the bike heavier than it needs to be. And at the same time the frames are becoming stiffer to make them more stable tourers because people in Europe tend to tour with a full complement of Ortlieb panniers.
JaccoW is offline  
Likes For JaccoW:
Old 11-21-20, 11:58 AM
  #11  
BiciMan
Senior Member
 
Join Date: Apr 2015
Location: Ann Arbor, MI
Posts: 199

Bikes: '97 Bianchi CDI, '97 Specialized RockHopper, '13 Specialized Sirrus Pro, '13 Trek 8.5 DS, '13 BH EasyMotion NeoXtrem, '14 Trek Domane, '86 Schwinn AirDyne ;)

Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 25 Post(s)
Liked 6 Times in 6 Posts
Very nice work, Inter, and thank you for sharing. Also nice that you're inspiring other contributions. Agree that Tableau has been great for years now, though I also retired and stopped using it before it was sold. (Still have a Tableau t-shirt )
BiciMan is offline  
Likes For BiciMan:
Old 11-21-20, 05:21 PM
  #12  
fishboat
Senior Member
 
Join Date: Feb 2016
Location: SE Wisconsin
Posts: 892

Bikes: Lemond '01 Maillot Jaune, Lemond '02 Victoire, Lemond '03 Poprad, '79 AcerMex Windsor Carrera Professional(purchased new), '06 Bianchi Volpe, '88 GT Tequesta(purchased new), '01 Bianchi Grizzly, 1993 Trek 970 drop bar conversion

Mentioned: 8 Post(s)
Tagged: 0 Thread(s)
Quoted: 326 Post(s)
Likes: 0
Liked 194 Times in 114 Posts
Originally Posted by BiciMan View Post
Very nice work, Inter, and thank you for sharing. Also nice that you're inspiring other contributions. Agree that Tableau has been great for years now, though I also retired and stopped using it before it was sold. (Still have a Tableau t-shirt )
"In God we trust, everyone else bring data.." ..went to a couple user meetings..Vegas and Wash DC..heck of a show both times. Attendance went from 500ish to 3000+ in the matter of a couple years..crazy growth. Lost track of it when I retired in '16.
fishboat is offline  

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Thread Tools
Search this Thread

Contact Us - Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service - Do Not Sell My Personal Information -

Copyright 2018 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.