Substantial Case Studies

These case studies represent a cross section of Substantial's experience in design and development. This not an exhaustive list of client projects. All projects are active and in development as of 2008.
BigChampagne tracks and reports online music activity to its music industry customers. They catalog everything from social network page views to track sales to radio plays. An aggressive partnership program found Big Champagne with abundance of data sources previously unavailable to their customers. The company decided to do an overhaul and modernize their site to present this new data.

The new application, BCDash, is a highly interactive module-based dashboard in the vein of Netvibes or iGoogle. Powering the BCDash user experience is a sophisticated Javascript/Flex client for accessing and visualizing data, testing the limits of what can be done in the web browser. The web client is backed by a web service layer tailored to accessing BigChampagne's data. The web service is currently providing data from a database of over 100 million records in real time.
Born in late 2006, YourStreet started as a real estate community site, allowing users to share news and opinions regarding the state of the housing market in the site's five target cities. After launching, development began on the second version of the site, shifting that local focus to news aggregation, with a webcrawler that analyzes thousands of news sources, intelligently placing and dynamically updating articles on a scrollable map.

That shift in focus required a massive shift in the site architecture to ensure an elegant user-experience. While the first version of the site was a relatively simple database front-end, the second version required more sophisticated client-side data management (via javascript) for not only the pins that would appear on the map, but for updating the page contents based on the current map state. That necessitated cataloguing and querying a constantly growing stream of geospatial (map)/article associations.
First on Mars is an online television video aggregator. With most video being presented through networks or studios, users can quickly become overwhelmed by the volume of sites they can potentially be forced to visit to consume their favorite television shows. First on Mars removes that barrier by collecting those sources and presenting them to its users in a user-friendly interface.

First on Mars combines a Flex client with a Ruby on Rails backend. The Flex client includes both integration with Google Analytics for traffic analysis and animations to bring the design to life. The backend ties everything together with a recommendation engine and further user tracking.