Changes
Jump to navigation
Jump to search
Silicon Valley Bank Data Project (view source)
Revision as of 21:56, 28 February 2011
, 21:56, 28 February 2011→The Benchmarking Data
The data exists in two databases: an operational database, and a development database which is populated by quarterly draws from the the operational database. Both databases run on an Oracle platform. The development data is validated and cleaned manually by SVB staff, and we could expect draws from this source. The data lives in a series of (flat) tables, with the main table containing the financials keyed as CompanyName-DateOfFinancials, and other tables, such as for the year of founding, keyed by CompanyName.
SVB takes data from the validated and cleaned development database and uploads this onto their online [http://www.birst.com/ Birst] based web-platform, to provide their benchmarking service. Companies accessing this data through the Birst interface are restricted the selecting aggregate benchmarking portfolios to compare their firm against. The interface allows them to construct portfolios on the basis of geography, industry, comparability in terms of financial ratios, and so forth, and reports the size of the comparing portfolio as either 5-30 firms, 31-100 firms, and so forth. Firms are restricted to seeing comparison portfolios composed of at least 5 firms. SVB is trying to advance this service into a CEO desktop tool, which will report things like [http://willprice.blogspot.com/2008/03/magic-number-for-saas-companies.html Josh James' Magic Number] - this requires fine grained data as well as uninterupted sequential financial statements, which is surely good news for researchers going forward.
The process of uploading the data to Birst is as follows:
