System and method for improvements to pre-processing of data for forecasting

A system for pre-processing data for forecasting, the system comprising:

• a cloud-based computing system comprising a cloud-based data storage configured to store an output data structure;
• and
• an on-premises contact center system comprising an on-premises data storage having stored thereon contact center interaction data in a source data structure, the on-premises contact center system configured to (i) determine a corresponding first number of interactions per unit of time for a corresponding source interval of the contact center interaction data for each source interval represented in at least a portion of the source data structure, (ii) determine a corresponding second number of units of time in a corresponding output interval represented in the output data structure of the cloud-based computing system, (iii) determine a corresponding third number of interactions in the corresponding output interval based on the corresponding first number of interactions per unit of time for the corresponding source interval and the corresponding second number of units of time in the corresponding output interval for each source interval represented in the at least the portion of the source data structure, and (iv) store to the output data structure of the cloud-based computing system, for each corresponding destination interval and without use of a third data structure intermediate to the source data structure and the output data structure, data representative of the corresponding third number of interactions determined for the corresponding destination interval.

A method of pre-processing data for forecasting, the method comprising:

• determining, by an on-premises contact center system, a corresponding first number of interactions per unit of time for a corresponding source interval of the contact center interaction data for each source interval represented in at least a portion of the source data structure;
• determining, by the on-premises contact center system, a corresponding second number of units of time in a corresponding destination interval represented in an output data structure of a computing system;
• determining, by the on-premises contact center system, a corresponding third number of interactions in the corresponding destination interval based on the corresponding first number of interactions per unit of time for the corresponding source interval and the corresponding second number of units of time in the corresponding destination interval for each source interval represented in the at least the portion of the source data structure;
• and
• storing to the output data structure of the computing system, for each corresponding destination interval and without use of a third data structure intermediate to the source data structure and the output data structure, data representative of the corresponding third number of interactions determined for the corresponding destination interval.