1 / 5

OLAP Cube: Transforming Data into ESPON Cube - Methodology & Integration Overview

Explore the methodology of transforming and combining data into an ESPON Cube, using a "cocktail" of data measures and ingredients like Sugar, Lime, and Fruit. Learn how to weigh data by Population, integrate, and aggregate information for insightful analyses. Combine data from different times, geometries, and types to create complex combinations. Dive deep into OLAP Cube tasting to understand the process better. For more information, contact roger.milego@uab.cat and mariajose.ramos@uab.cat.

klaus
Download Presentation

OLAP Cube: Transforming Data into ESPON Cube - Methodology & Integration Overview

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. OLAP CUBE Transforming and combining data: Towards the ESPON Cube Maria José Ramos Roger Milego Agràs Alcalá de Henares, 9-10 June 2010

  2. Methodology overview A “cocktail” of data MEASURES MEASURES -grams -ml -Area -Population -GDP OLAP CUBE INGREDIENTS DIMENSIONS Sugar Lime Fruit Rhum Ecological Background Corine Land Cover Nuts Maps Daikiri Graphics & Statistics

  3. Methodology overview From ingredient to “cocktail” Weighted by Population Unemployment 2001 (Eurostat) Disaggregation Population Grid 2001 (JRC) Ref. Grid 1km Integration Aggregation CLC 2000 (EEA) Integration OLAP CUBE

  4. Tasting the “cocktail” • Combining data from different times • Combining data from different geometries (e.g. NUTS 2003, NUTS 2006) • Combining continuous data (e.g. CLC) with discrete data (e.g. NUTS3) • Complex combinations (…)

  5. Thank you very much for your attention! For further info: roger.milego@uab.cat mariajose.ramos@uab.cat

More Related