Analytical Functionality Selecting Relevant Market Research Data for Global Reporting

摘要

Embodiments provide methods and systems configured to consolidate market research data from a plurality of sources (e.g., regional providers) into a single data warehouse suited for global reporting purposes. Accordingly an engine is provided in communication with a plurality of underlying databases each comprising market research data. The databases comprises a time dimension, a market dimension, and a product dimension. The engine aggregates data of the individual market research databases into a consolidated database, by first identifying a pre-aggregated market total. Next, the engine selects and identifies single individual products relevant to the aggregated market research data. Finally, the engine checks that the sum of the selected products of the previous step is within a tolerance level of the pre-aggregated market total of the initial step. If the check fails, in an iterative manner the engine returns to alter the selected relevant products and performs the check step again.

主权项

1. A computer-implemented method comprising:
an engine receiving first market research data from a first source, and receiving second market research data from second source; the engine calculating a pre-aggregated market total from the first market research data and the second market research data; the engine generating from the first market data and the second market data, a first aggregated market total comprising a first selected product in the first market research data and the second market research data; the engine determining whether the first aggregated market total is within a tolerance of the pre-aggregated market total; the engine displaying to a user, a result of the determining; where the aggregated market total is within the tolerance, displaying a global report to the user; and where the aggregated market total is not within the tolerance, the engine,
generating from the first market data and the second market data, a second aggregated market total comprising a second selected product, and
the engine determining whether the second aggregated market total is within the tolerance.