Accessing and organizing data sets directly from a data warehouse
Accessing and organizing data sets directly from a data warehouse including receiving, by a data analyzer, a request from a service provider client instructing the data analyzer to retrieve a data set from a service provider data warehouse, wherein the service provider client is a client of a service provider, and wherein the service provider data warehouse stores data sets for the service provider; retrieving, by the data analyzer, the data set directly from the service provider data warehouse using credentials provided by the service provider; selecting, by the data analyzer, a worksheet template based on the service provider; organizing, by the data analyzer, the data set into a worksheet based on the worksheet template; and presenting, by the data analyzer to the service provider client, the worksheet comprising the data set.
1. A method of accessing and organizing data sets directly from a data warehouse, the method comprising:
receiving, by a data analyzer, a request from a service provider client instructing the data analyzer to retrieve a data set from a service provider data warehouse, wherein the service provider client is a client of a service provider, and wherein the service provider data warehouse stores data sets for the service provider, wherein the service provider client accesses the data analyzer and the service provider data warehouse without providing credentials;
retrieving, by the data analyzer, the data set directly from the service provider data warehouse using credentials provided by the service provider;
selecting, by the data analyzer, a worksheet template based on the service provider;
organizing, by the data analyzer, the data set into a worksheet based on the worksheet template; and
presenting, by the data analyzer to the service provider client, the worksheet comprising the data set.
2. The method of claim 1 , wherein retrieving, by the data analyzer, the data set directly from the service provider data warehouse using credentials provided by the service provider comprises accessing, by the data analyzer, the service provider data warehouse via a secure data sharing interface.
3. The method of claim 1 , wherein retrieving, by the data analyzer, the data set directly from the service provider data warehouse bypasses the service provider.
4. The method of claim 1 , wherein selecting, by the data analyzer, the worksheet template based on the service provider comprises selecting, by the data analyzer, the worksheet template based on a type of data set from the service provider.
5. The method of claim 1 , wherein retrieving, by the data analyzer, the data set directly from the service provider data warehouse using credentials provided by the service provider comprises requesting the credentials from the service provider.
6. The method of claim 1 , wherein the worksheet template is provided by the service provider.
7. An apparatus for accessing and organizing data sets directly from a data warehouse, the apparatus comprising a computer processor, a computer memory operatively coupled to the computer processor, the computer memory having disposed within it computer program instructions that, when executed by the computer processor, cause the apparatus to carry out the steps of:
receiving, by a data analyzer, a request from a service provider client instructing the data analyzer to retrieve a data set from a service provider data warehouse, wherein the service provider client is a client of a service provider, and wherein the service provider data warehouse stores data sets for the service provider, wherein the service provider client accesses the data analyzer and the service provider data warehouse without providing credentials;
retrieving, by the data analyzer, the data set directly from the service provider data warehouse using credentials provided by the service provider;
selecting, by the data analyzer, a worksheet template based on the service provider;
organizing, by the data analyzer, the data set into a worksheet based on the worksheet template; and
presenting, by the data analyzer to the service provider client, the worksheet comprising the data set.
8. The apparatus of claim 7 , wherein retrieving, by the data analyzer, the data set directly from the service provider data warehouse using credentials provided by the service provider comprises accessing, by the data analyzer, the service provider data warehouse via a secure data sharing interface.
9. The apparatus of claim 7 , wherein retrieving, by the data analyzer, the data set directly from the service provider data warehouse bypasses the service provider.
10. The apparatus of claim 7 , wherein selecting, by the data analyzer, the worksheet template based on the service provider comprises selecting, by the data analyzer, the worksheet template based on a type of data set from the service provider.
11. The apparatus of claim 7 , wherein retrieving, by the data analyzer, the data set directly from the service provider data warehouse using credentials provided by the service provider comprises requesting the credentials from the service provider.
12. The apparatus of claim 7 , wherein the worksheet template is provided by the service provider.
13. A computer program product for accessing and organizing data sets directly from a data warehouse, the computer program product disposed upon a computer readable medium, the computer program product comprising computer program instructions that, when executed, cause a computer to carry out the steps of:
receiving, by a data analyzer, a request from a service provider client instructing the data analyzer to retrieve a data set from a service provider data warehouse, wherein the service provider client is a client of a service provider, and wherein the service provider data warehouse stores data sets for the service provider, wherein the service provider client accesses the data analyzer and the service provider data warehouse without providing credentials;
retrieving, by the data analyzer, the data set directly from the service provider data warehouse using credentials provided by the service provider;
selecting, by the data analyzer, a worksheet template based on the service provider;
organizing, by the data analyzer, the data set into a worksheet based on the worksheet template; and
presenting, by the data analyzer to the service provider client, the worksheet comprising the data set.
14. The computer program product of claim 13 , wherein retrieving, by the data analyzer, the data set directly from the service provider data warehouse using credentials provided by the service provider comprises accessing, by the data analyzer, the service provider data warehouse via a secure data sharing interface.
15. The computer program product of claim 13 , wherein retrieving, by the data analyzer, the data set directly from the service provider data warehouse bypasses the service provider.
16. The computer program product of claim 13 , wherein selecting, by the data analyzer, the worksheet template based on the service provider comprises selecting, by the data analyzer, the worksheet template based on a type of data set from the service provider.
17. The computer program product of claim 13 , wherein retrieving, by the data analyzer, the data set directly from the service provider data warehouse using credentials provided by the service provider comprises requesting the credentials from the service provider.