Sumários
Week 11
7 Maio 2024, 15:00 • Márcia Cristina Afonso Barros
Data warehousing with Python: simple data inserts in a database, running OLAP queries, creating and populating dimension and fact tables, generating data for the Date dimension.
ETL system
7 Maio 2024, 13:00 • António Ferreira
ETL system: staging steps of a data warehouse; conceptual ETL plan; logical data map; ETL build sequence; metadata; flat files vs. databases; data quality screens; conforming data; loading data into dimensions; handling SCD type 2 changes; loading data into facts; loading snapshot fact tables; indexes during the ETL processing; outwitting the database log; increasing ETL throughput.