Accessing and organizing data sets directly from a data warehouse

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.

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.