Sumários

OLAP Operations

12 novembro 2015, 14:30 • Helena Galhardas

Recapitulation of the definition of OLAP.

Data aggregation and grouping.
OLAP operations:
  • roll-up
  • drill-down
  • sort
  • pivot
  • slice
  • dice
  • drill-across
  • aggregation
  • add-mesure
  • union, difference
  • drill-through.

OLAP Operations

12 novembro 2015, 14:30 • Helena Galhardas

Recapitulation of the definition of OLAP.

Data aggregation and grouping.
OLAP operations:
  • roll-up
  • drill-down
  • sort
  • pivot
  • slice
  • dice
  • drill-across
  • aggregation
  • add-mesure
  • union, difference
  • drill-through.

Lab 7

12 novembro 2015, 13:00 • Diogo Ribeiro Ferreira

Data profiling with DataCleaner. Analyzing the customers table and the orderdetails table. Integration of DataCleaner with Pentaho. Data profiling in a PDI transformation.

Lab 7

10 novembro 2015, 15:30 • Diogo Ribeiro Ferreira

Data profiling with DataCleaner. Analyzing the customers table and the orderdetails table. Integration of DataCleaner with Pentaho. Data profiling in a PDI transformation.

Introduction to Data Warehouse

9 novembro 2015, 15:30 • Helena Galhardas

  • Motivation
  • Definition of data warehouse
  • New domains and challenges
  • The multidimensional model: facts, dimensions, hierarchies, aggregation functions, data cube, SQL extensions ROLLUP and CUBE
  • Typical data warehouse architecture.