Difference between revisions of "VentureXpert Data"

From edegan.com
Jump to navigation Jump to search
Line 9: Line 9:
  
 
===Relevant Former Projects===
 
===Relevant Former Projects===
[[Venture Capital (Data)]]
+
#[[Venture Capital (Data)]]
[[Retrieving US VC Data From SDC]]
+
#[[Retrieving US VC Data From SDC]]
[[VC Database Rebuild]]
+
#[[VC Database Rebuild]]
 +
#[[Retrieving US VC Data From SDC]]
  
  

Revision as of 15:56, 26 June 2018


McNair Project
VentureXpert Data
Project logo 02.png
Project Information
Project Title VentureXpert Data
Owner Augi Liebster
Start Date June 20, 2018
Deadline
Primary Billing
Notes
Has project status Active
Copyright © 2016 edegan.com. All Rights Reserved.


Augi Liebster (Work Log)

Relevant Former Projects

  1. Venture Capital (Data)
  2. Retrieving US VC Data From SDC
  3. VC Database Rebuild
  4. Retrieving US VC Data From SDC


Goal

I will be looking to redesign the VC Database in a way that is more intuitively built than the previous one. I will also update the database with current data.

Initial Stages

The first step of the project was to figure out what primary keys to use for each major table that I create. I looked at the primary keys used in the creation of the VC Database Rebuild and found primary keys that are decent. I have updated them and list them below:

  1. CompanyBaseCore- coname, statecode, datefirstinv
  2. IPOCore- issuer, issuedate, statecode
  3. MACore- target name, target state code, announceddate
  4. Geo - city, statecode, coname, datefirst, year
  5. DeadDate - conname, statecode, datefirst, rounddate (tentative could still change)
  6. RoundCore- conname, statecode, datefirst, rounddate
  7. FirmBaseCore - firmname
  8. FundBaseCore - fund name, firstinvdate

These are my initial listings and I will come back to update them if needed.

The second part of the initial stage has been to pull data from the SDC Platinum platform with updated dates to make the pull as recent as possible.

Pulling from SDC

Finding what to enter into the SDC in order to run the reports that were already created is not always intuitive. As such I have included the process for each table here.

  1. USVCPortCoPresent-1980: VentureXpert -> Portfolio Companies ->

When pulling the VCFirm1980-Present, I encountered two problems. One, is that SDC is not able to sort through the funds that are US only with the built in filters. Two, there are multiple rpt files that specify different variables for the fund pull. I pulled from both to be safe, but in the VC Database Rebuild page there is a section on the fund pull where Ed specifies which rpt file he used to pull data from SDC. Regardless I have both saved in the ExtractedData folder.