Sumários

Week 8: April 4th

4 Abril 2023, 16:30 • 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.

Week 8: April 4th

4 Abril 2023, 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.

Case studies in data warehousing

4 Abril 2023, 13:00 • António Ferreira

Case studies in data warehousing: order management, bus matrix, order requests, customers, prices in multiple currencies, profit and loss breakdown; customer relationship management, feed back to operational systems, outriggers, mini-dimensions, names and addresses, hierarchies; telecommunications, bus matrix, initial model, criticism, revised model; electronic commerce, clickstream, sessions and visits to individual pages, dimensions, fact tables with different grains.

Week 7: March 28th

28 Março 2023, 16:30 • Márcia Cristina Afonso Barros

Multidimensional analysis with SQL: creation of dimension and fact tables in a relational database; loading of data to a relational database; reports in SQL.

Week 7: March 28th

28 Março 2023, 15:00 • Márcia Cristina Afonso Barros

Multidimensional analysis with SQL: creation of dimension and fact tables in a relational database; loading of data to a relational database; reports in SQL.