JMP Data DepotDescription:
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
- Magento E-Commerce Data
- SAS Education Data
- SAS Finance Currency Exchange Rates
- Google BigQuery
- Earned Sales Credit
- Community Data
- Sales Organization Data
Documentation and data column definitions for all of the data tables contained in the Data Depot can be found on this Confluence page: https://jmpdiscovery.atlassian.net/wiki/spaces/~633c28c107a27ebeff181ee4/pages/16351573/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!
Now available for access, the Data Depot facilitates access to helpful data sources.
Inside Sales NewsRE: JMP Data Depot@andyzhou This is what you said earlier to me. Thanks for your support! This is really great and helpful!
Re: JMP Data DepotThis is wonderful -- thanks, @andyzhou !
Re: JMP Data DepotThank you Andy 
This is very useful!
Re: JMP Data Depot@AtsukoI_Japan No problem at all, glad you are finding it useful! And yes, I just included the Member_Territory__c field in the Trial Download data table. Thank you for bringing that to my attention!
Re: JMP Data Depot@andyzhou Hi Andy, This is very helpful information for us. Thank you for preparing and sharing the data. Is it possible to include territory into Trial download data? Thank you in advance. -Atsuko
Re: JMP Data Depot@Tracey_Bailey Unfortunately it looks like SAS removed that column from the tables we can access, so that information is no longer something I can get and put in the GIDB Data tables.
Re: JMP Data Depot@andyzhou Andy, Is it now possible to include the SAS Rep in the GIDB Data reports that are in the Data Depot?
