Abstract: 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.