addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwchatcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-crosscrosseditemptyheartfacebookfolderfullheartglobegmailgoogleimagesinstagramlinklocation-pinmagnifying-glassmailminusmoremuplabelShape 3 + Rectangle 1outlookpersonplusprice-ribbonImported LayersImported LayersImported Layersshieldstartrashtriangle-downtriangle-uptwitteruseryahoo

Michael Chen on: Extracting Big Intelligence out of Big Data through Excel

Extracting Big Intelligence out of Big Data through Excel

Michael J Chen, founder and technical lead of BiBo Labs Inc, will have an open discussion on the extraction of data out of MongoDB into rich formula based Excel worksheets while incorporating formulas, aggregates, crosstabs, pivots, and charts.

Over the years, Big Data has primarily been focused on simplifying the capture and sharding of data at the expense of simplified standardized reporting.

This discussion is about how Segovia can supplement some of the pitfalls of NoSQL with an enterprise reporting framework. Through Segovia, developers, DBA’s and analysts can painlessly create sophisticated Excel report out of MongoDB.

You can see a vimeo about what will be presented: Part I, Part II.

Michael J Chen is the founder and technical lead of BiBo Labs Inc. One of his responsibilities at BiBo Labs is development of their enterprise reporting product, Segovia. He currently maintains the data abstraction layer between Segovia and a variety of different data sources including relational and NoSQL databases.

Michael was the CTO at Prima Royale Enterprises, a footwear manufacturer specializing in OEM sales and development. During his tenure at Prima, Michael developed an enterprise supply chain portal for Prima and all their respective trading partners (factories, sub- contractors, buying agents, and retailers). Prior to Prima, Michael worked in enterprise asset management and licensing at Disney Consumer Products. There he maintained a database and rendering repository on behalf of Disney Feature Animation to all of the Disney licensees for all product categories.

Michael received his education in computer science from his father at a very young age on the IBM mainframe in COBOL, Assembly and DB2. He eventually continued onto more modern languages as time progressed. He received his undergraduate degree in business administration from USC’s Marshall School of Business. Michael can be reached at [masked].

BiBo Labs Inc. is an enterprise software company primarily focused on reinventing the software development lifecycle through the different types of frameworks and utilities. BiBo Labs Inc. is a spinoff from Prima Royale Enterprises, a footwear manufacturer specializing in OEM footwear for large chain stores (JC Penney, Kohls, Sears, K-Mart). A significant portion of the key technology within BiBo was developed from the enterprise supply chain system Prima Royale had adopted for the past 10 years.

Company Links:



founded in 2007 by Gil Elbaz, co-founder of Applied Semantics (which launched ASI's AdSense product). Applied Semantics was acquired by Google in 2003. Gil has had a lifelong passion for organizing and structuring information, and building smart tools which can make better sense of data. To that end, he set out to develop an open data platform and community in an effort to maximize data accuracy, transparency, and availability. Fellow data lovers -- Tim Chklovski, chief scientist & founding engineer, Eva Ho, an ex-Googler, along with Bill Michels, former GM of Yahoo BOSS, have joined him in this ambitious project.


Factual is in the Gateway West building, next to the Westfield Century City mall on the east side. It's the only building with big red "Westfield" signs on top.

We recommend you park at the mall. You get 3 hours free and our building is a short easy walk: Exit from the mall parking garage up to ground level, head east, pass the Lens Crafters, and you'll be able to enter the west side of 1801. Then just hit the elevators to go up to floor 14, and Factual is in Suite 1450.

To hear about upcoming meetups, follow us on Twitter!

Join or login to comment.

  • Ron P.

    Very cool system. The title was a big deceiving. Michael Chen and his team certainly knows what he is talking about and there is a great deal to learn from their experience with MongoDB.

    June 21, 2012

  • Matt C.

    Great talk Michael, loved the simplicity & power of using Excel as the input design tool as well as the output format.

    June 20, 2012

  • A former member
    A former member

    It was great meeting everyone who attended last night. Looked like most people were just thinking about trying to get their organization on MongoDB and haven't quite launched it to production. We actually use MongoDB as our backend datastore on so if anybody needs pointers or advice email me terrence AT and I would be happy to answer.

    June 20, 2012

  • Mike J.

    Impressive work. Thanks for the food as well.

    June 20, 2012

  • Joe D.

    Loved this talk! Michael really had an original approach to things. From YeSQL to deciding to make Excel play nice w/ outside data sources, to saving data from Excel to Mongo, there was a lot to get out of this talk. We'll definitely invite him back to speak again.

    June 20, 2012

  • Michael J. C.

    Does anybody have problems getting started or reintegrating mongodb back into their org? What kind of problems do you potentially face?

    June 1, 2012

50 went

Our Sponsors

  • MongoDB

    Thanks to MongoDB for the refreshments and support!!

  • Factual

    Factual offers event space for MongoDB User Groups

  • Diamond

    From product concept to reality using MongoDB

  • LAX Coastal Chamber of Commerce

    This is an initiative by the Chamber to marry Local Business to Tech!

  • Television Four

    TV4 is filming all our talks & pre-talk interviews with the speaker.

  • LAX CoWorking

    A coworking space w/ modern biz owner in mind. As low as $20/day.

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy