Sumários
OLAP operations
2 novembro 2020, 15:30 • Diogo Ribeiro Ferreira
Dimensions, hierarchies and levels. Examples of OLAP queries with SQL. Conceptual view of OLAP operations on data cubes. Facts, measures and aggregation. Fact dimensionality and design of star schemas.
Lab 6
2 novembro 2020, 09:30 • Diogo Ribeiro Ferreira
Use of a data profiling tool to analyze a sample dataset and the results of a data transformation.
Introduction to data warehousing
30 outubro 2020, 14:00 • Diogo Ribeiro Ferreira
Transactional processing vs. analytical processing on sample database. Analytical queries with a single dimension and with multiple dimensions. Data warehousing and star schemas. Analytical queries over a star schema.
Introduction to data warehousing
30 outubro 2020, 14:00 • Diogo Ribeiro Ferreira
Transactional processing vs. analytical processing on sample database. Analytical queries with a single dimension and with multiple dimensions. Data warehousing and star schemas. Analytical queries over a star schema.
Lab 5
29 outubro 2020, 11:00 • Diogo Ribeiro Ferreira
Lab guide and exercises about approximate duplicate detection and elimination using a sample dataset.