Sumários

Lab Guide 8: Data Warehouse and ETL process

10 novembro 2016, 16:00 • Diogo Ribeiro Ferreira

Using MySQL to create the relational schema of a data warehouse and using PDI to populate it with data.
Pencil & Paper Exercise: relational model of a data warehouse, star schema versus snowflake schema.

OLAP Operations and Conceptual Data Warehouse Design

10 novembro 2016, 14:30 • Helena Galhardas

OLAP operations:

  • roll-up
  • drill-down
  • sort
  • pivot
  • slice
  • dice
  • drill-across
  • aggregation
  • add-mesure
  • union, difference
  • drill-through.
Conceptual Data Warehouse Design:

  • Conceptual modeling of data warehouse: MultiDim
  • Dimension hierarchies: balanced, unbalanced

OLAP Operations and Conceptual Data Warehouse Design

10 novembro 2016, 14:30 • Helena Galhardas

OLAP operations:

  • roll-up
  • drill-down
  • sort
  • pivot
  • slice
  • dice
  • drill-across
  • aggregation
  • add-mesure
  • union, difference
  • drill-through.
Conceptual Data Warehouse Design:

  • Conceptual modeling of data warehouse: MultiDim
  • Dimension hierarchies: balanced, unbalanced

Lab Guide 8: Data Warehouse and ETL process

10 novembro 2016, 13:00 • Diogo Ribeiro Ferreira

Using MySQL to create the relational schema of a data warehouse and using PDI to populate it with data.
Pencil & Paper Exercise: relational model of a data warehouse, star schema versus snowflake schema.

Lab Guide 8: Data Warehouse and ETL process

8 novembro 2016, 15:30 • Diogo Ribeiro Ferreira

Using MySQL to create the relational schema of a data warehouse and using PDI to populate it with data.
Pencil & Paper Exercise: relational model of a data warehouse, star schema versus snowflake schema.