Sumários
Lab 7
10 novembro 2020, 14:00 • Diogo Ribeiro Ferreira
Development of a complete ETL process for a simple data warehouse.
Data warehouse design
9 novembro 2020, 15:30 • Diogo Ribeiro Ferreira
Schemas: star, snowflake, starflake, constellation. Hierarchies: balanced, unbalanced, recursive, generalized, ragged, alternative, parallel, non-strict. Measures: additive, semi-additive, non-additive, derived. Time dimension.
Data warehouse design
9 novembro 2020, 15:30 • Diogo Ribeiro Ferreira
Schemas: star, snowflake, starflake, constellation. Hierarchies: balanced, unbalanced, recursive, generalized, ragged, alternative, parallel, non-strict. Measures: additive, semi-additive, non-additive, derived. Time dimension.
Lab 7
9 novembro 2020, 09:30 • Diogo Ribeiro Ferreira
Development of a complete ETL process for a simple data warehouse.
ETL process for a data warehouse
6 novembro 2020, 14:00 • Diogo Ribeiro Ferreira
Database schema vs. data warehouse schema. Populating dimension tables: simple dimension, slowly-changing dimension, and time dimension. Natural keys vs. surrogate keys. Populating a fact table. A complete ETL process.