Unleash the Power of Your Data Using Open Source Business Intelligence

Christopher Lavigne (Breadboard BI, Inc.)

Business:
Together, YachtWorld.com and Boats.com are the single most powerful and effective online global marketing solution for the boating industry. With over 140,000 new and used boat listings worldwide offered by over 4,000 brokers, dealers and builders in 115 countries, YachtWorld.com and Boats.com are visited by over 4 million boating consumers every month who click through over 95 million page views.

Challenge:
Like many companies, YachtWorld.com and Boats.com were collecting large quantities of data from their diverse operational systems – millions of daily web page views, as well as significant volumes of sales lead emails and toll free calls to their affiliated brokers, dealers, and builders. The web-related data resided in very large log files, the call and email data was distributed across multiple, heterogeneous MySQL and Oracle databases, other supporting data was found in various flat files. The final challenge – the solution needed to be built within a reasonable budget.

Solution:
YachtWorld.com and Boats.com required a flexible, highly-scalable, maintainable market intelligence solution that could bring together all the data, and present the information in an easy to use format. This required a centralized data warehouse from which users could perform sophisticated analysis based on cubes, dashboards, and reports. Both open source and proprietary database and business intelligence solutions were considered during the selection process. MySQL was chosen as the database engine; the Pentaho business intelligence suite was chosen to provide extract, transform, load (ETL) and analysis/reporting functionality.

Both selections were based on functionality (especially MySQL 5.1 partitioning); large, active user-bases; existing internal expertise with the engine (MySQL); the long-term viability of the companies; and the availability of professional support subscriptions. Breadboard BI, Inc. (http://www.breadboardbi.com) provided the project management and consulting services necessary to architect and build the solution. They were chosen based on a proven track-record of delivering scalable business intelligence solutions, as well as their MySQL and Pentaho partnerships and certifications.

Results:
The new YachtWorld.com and Boats.com solution, named BoatsReports, represents a 100% open source stack – from the Linux operating system on the servers, to the MySQL database, to the Pentaho data integration and presentation layers. This stack required zero upfront investment in database or business intelligence software licenses (usually running well into USD six figures), making it easier to receive internal project approval. In addition, the open architecture of this stack made it easy to integrate with existing systems. Although a contingency plan was developed to swap out open source tools for proprietary or custom-developed solutions, these alternate plans were not needed.
Conclusion:
Boats.com and YachtWorld.com have affordably transformed their oceans of disparate data into a comprehensive market intelligence product based on open source technologies. The actionable information in BoatsResults offers internal analysts and external partners with previously unavailable insights. Making use of previously unavailable information with the help of open source tools, this powerful solution has quickly proven invaluable in the decision making process for production, sales and marketing strategies. Because of the size of the Boats.com & YachtWorld combined data set, the data in aggregate form now represents some of the most comprehensive benchmark data in the boating industry – by itself a valuable commodity allowing for unmatched competitive analysis. A secondary result of the new solution has been that it has exposed data issues in the source systems. Several projects have been undertaken to further improve operational data, allowing customers to be better-served.

More Details:
More details can be found in a case study at http://www.breadboardbi.com/white_papers/case_study_boats.pdf.

Photo of Christopher Lavigne

Christopher Lavigne

Breadboard BI, Inc.

Christopher Lavigne is a managing partner at Breadboard BI, Inc. (www.breadboardbi.com). At Breadboard, he leads the creation of superior quality, rapidly developed, affordable business intelligence systems based on commercial and open source tools. Mr. Lavigne has worked for a number of major companies including Cargill, PeopleSoft, PricewaterhouseCoopers, and Oracle. He has published a number of white papers focusing on developinng enterprise business intelligence solutions using open source tools. Mr. Lavigne has also spoken at major conferences, including LinuxWorld in San Francisco. He earned a Masters degree from Virginia Tech and holds a number of certifications.

Comments on this page are now closed.

Comments

Picture of Sheeri K. Cabral
Sheeri K. Cabral
07/30/2009 9:09am PDT

Or watch the whole video on YouTube (much easier) at www.youtube.com/watch?v=Xlh...

Picture of Sheeri K. Cabral
Sheeri K. Cabral
07/06/2009 5:26pm PDT

Download the 96 Mb .mov file at technocation.org/node/755/d... or, if you are more patient, wait (15-20 min) for the streaming to occur at technocation.org/node/755/play

Co-presented By:

O'Reilly Media MySQL/Sun Microsystems
  • Kickfire
  • Virident
  • Infobright, Inc
  • JasperSoft
  • Intel
  • Advanced Micro Devices
  • BIRT Exchange by Actuate
  • Calpont
  • Canonical
  • Continuent
  • Dolphin Interconnect Solutions
  • Facebook
  • HiT Software, Inc.
  • IBM
  • iDashboards
  • Oracle
  • Pentaho
  • R1Soft
  • Schooner Information Technology
  • SQLstream
  • Ticketmaster
  • Zmanda, Inc.
  • Linux Journal

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at scordesse@oreilly.com

Download the MySQL Sponsor/Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@ oreilly.com

Press and Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com

MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.

Contact Us

View a complete list of MySQL contacts.