Description:
The first iteration of the JMP Data Depot (bit.ly/JMP_SIA_Data_Depot) is now available for access! The goal of the Data Depot is facilitate access to all of the various data sources available to the division. The data sources included in the Data Depot include:
- Salesforce
- GIDB
- SAS Education Data
- SAS Finance Currency Exchange Rates
- Google BigQuery
- Earned Sales Credit
Documentation and data column definitions for all of the data tables contained in the Data Depot can be found on this Confluence page: https://rndconfluence.sas.com/confluence/display/JSIA/Data+Depot+-+Definitions
The Data Depot is, and will probably always be, continuing to evolve and improve. Your suggestions are a critical part of that process of improvement. If you have an idea, please email me or put it in the comments below and I will get to it as soon as I can.
OneDrive Sync:
The Data Depot is available for access through OneDrive. The following SharePoint link (bit.ly/JMP_SIA_Data_Depot) allows the possibility of syncing this folder to your hard drive, so the most up-to-date versions of the data are automatically uploaded to your computer.
- Click the link. This should open up a Sharepoint link for a folder called Data Depot.
- Select the "Sync" button on the toolbar. This will bring up a prompt titled "Open Microsoft OneDrive?".
- Select the "Open Microsoft OneDrive" button.
- OneDrive will do the rest, and the folder should show up in your file explorer!
