Generating period-over-period calculations using a cloud-based data warehouse

An apparatus for generating period-over-period calculations using a cloud-based 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 steps of:

• receiving, by a workbook manager from a client computing system via a graphical user interface, a selection of a date column and a prior period to create a comparison value column for a table in a cloud-based data warehouse, wherein the selection comprises an identifier of the date column and an identifier of the prior period;
• matching, by the workbook manager, a first set of dates in the date column to a second set of dates in the date column using the identifier of the date column and the identifier of the prior period, wherein each entry in the first set of dates is matched to a corresponding entry in the second set of dates;
• generating, based on the matching of the first set of dates to the second set of dates, a database statement to create, in the cloud-based data warehouse, the comparison value column as a separate column in the table, including organizing the comparison value column using values corresponding to the second set of dates in the date column;
• retrieving the comparison value column from the cloud-based data warehouse, wherein the comparison value column is created in the cloud-based data warehouse by execution of the database statement;
• and
• presenting, on the client computing system, the table comprising the comparison value column, wherein the table includes multiple entries for the prior period that correspond to a time unit smaller than the prior period.

A computer program product for generating period-over- period calculations using a cloud-based data warehouse, the computer program product disposed upon a non-transitory computer readable medium, the computer program product comprising computer program instructions that, when executed, cause a computer to carry out steps of:

• receiving, by a workbook manager from a client computing system via a graphical user interface, a selection of a date column and a prior period to create a comparison value column for a table in a cloud-based data warehouse, wherein the selection comprises an identifier of the date column and an identifier of the prior period;
• matching, by the workbook manager, a first set of dates in the date column to a second set of dates in the date column using the identifier of the date column and the identifier of the prior period, wherein each entry in the first set of dates is matched to a corresponding entry in the second set of dates;
• generating, based on the matching of the first set of dates to the second set of dates, a database statement to create, in the cloud-based data warehouse, the comparison value column as a separate column in the table, including organizing the comparison value column using values corresponding to the second set of dates in the date column;
• retrieving the comparison value column from the cloud-based data warehouse, wherein the comparison value column is created in the cloud-based data warehouse by execution of using the database statement;
• and
• presenting, on the client computing system, the table comprising the comparison value column, wherein the table includes multiple entries for the prior period that correspond to a time unit smaller than the prior period.