VentureXpert Data - Revision history

Ed at 16:13, 16 January 2025

2025-01-16T16:13:46Z

2025-01-16T16:13:18Z

2024-03-24T16:36:41Z

2020-09-21T17:43:36Z

2020-09-21T17:34:23Z

2020-09-21T16:54:33Z

2020-09-20T17:20:19Z

2020-09-20T17:12:32Z

2019-04-02T00:34:39Z

Location

2018-08-17T22:27:43Z

Ranking Tables and Graphs

@@ Line 1: / Line 1: @@
 {{Project
 |Has title=VentureXpert Data
-|Has owner=Augi Liebster,
+|Has owner=Ed Egan
-|Has start date=June 20, 2018
+|Has start date=2018/06/20
 |Has project status=Active
 }}
 The successors to this project include:
 *[[VCDB24]], which is the most recent iteration.

@@ Line 13: / Line 13: @@
 *[[VCDB20Q3]]
 *[[VCDB20H1]]
-*[[VCDB4]]
+*[[Vcdb4]]
 ==Relevant Former Projects==

@@ Line 9: / Line 9: @@
 The successors to this project include:
-*[[Vcbd4]]
+*[[VCDB24]], which is the most recent iteration.
 *[[VCDB20H1]]
 ==Relevant Former Projects==

@@ Line 1: / Line 1: @@
 {{Project
-|Has project output=
+|Has project output=Data,How-to
 |Has sponsor=McNair Center
 |Has title=VentureXpert Data

@@ Line 1: / Line 1: @@
 {{Project
 |Has sponsor=McNair Center
 |Has title=VentureXpert Data

@@ Line 13: / Line 13: @@
 ==Location==
 My scripts for SDC pulls are located in the E drive in the location:
-  E:\VentureXpertDatabase\ScriptsForSDCExtract
+  E:\McNair\Projects\VentureXpertDatabase\ScriptsForSDCExtract
 My successfully pulled and normalized files are stored in the location:
-  E:\VentureXpertDatabase\ExtractedDataQ2
+  E:\McNair\Projects\VentureXpertDatabase\ExtractedDataQ2
 My scripts for loading tables and data are in:
-  E:\VentureXpertDatabase\vcdb3\LoadingScripts
+  E:\McNair\Projects\VentureXpertDatabase\vcdb3\LoadingScripts
 There are a variety of SQL files in there with self explanatory names. The file that has all of the loading scripts is called LoadingScriptsV1. The folder vcdb2 is there for reference to see what people before had done. ExtractedData is there because I pulled data before July 1st, and Ed asked me to repull the data.

@@ Line 1,445: / Line 1,445: @@
 This is a slight detour from the creation of VCDB3. However, this is a cool process because you actually get to use the data you've been working with. This process is extensive, but the queries are easy to understand. If you wish to have deeper understanding of the process, read the code. It is located in:
-  E:McNair\Projects\VentureXpert Database\vcdb3\LoadingScripts\RoundRanking
+  E:McNair\Projects\VentureXpert Database\vcdb3\LoadingScripts\RoundRanking.SQL
 First you must create a table that has aggregate round information grouped by cities and round year. Since this is a little difficult to picture, I will attach the code.
@@ Line 1,463: / Line 1,463: @@
 For states follow the same general process but group by states not cities and states.
 If this explanation was not enough for you (it was not meant to be in depth) go to the location defined above and read the actual code. With the description I have given, you should be able to piece together what each query does.
 ==Master Tables==