Sumários
Lab Guide 6 - Data Profiling
29 outubro 2019, 14:00 • Anna Couto
- Introduction to Data Profiling with DataCleaner.
- Resolution of the exercises of Lab Guide 6.
Introduction to Data Warehousing (cont.) and Online Analytical Processing (OLAP)
28 outubro 2019, 15:30 • Helena Galhardas
Introduction to Data Warehousing (cont.):
- Multidimensional model
- Typical Data Warehouse Architecture
- OLAP vs OLTP (Online Transaction Processing)
- OLAP: Data Grouping and Aggregation
- SQL/OLAP: GROUPING SETS; ROLLUP, CUBE, Window Partitioning, Window Ordering, Window Framing.
Introduction to Data Warehousing (cont.) and Online Analytical Processing (OLAP)
28 outubro 2019, 15:30 • Helena Galhardas
Introduction to Data Warehousing (cont.):
- Multidimensional model
- Typical Data Warehouse Architecture
- OLAP vs OLTP (Online Transaction Processing)
- OLAP: Data Grouping and Aggregation
- SQL/OLAP: GROUPING SETS; ROLLUP, CUBE, Window Partitioning, Window Ordering, Window Framing.
Lab Guide 6: Data Profiling
28 outubro 2019, 09:30 • João Pedro Lebre Magalhães Pereira
- Introduction to Data Profiling with DataCleaner.
- Resolution of the exercises of Lab Guide 6.
Data profiling and Introduction to Data Warehousing
24 outubro 2019, 14:00 • Helena Galhardas
Data Profiling:
- Motivation and Definition
- Typical data profiling procedure
- Data profiling tasks
- Data profiling tools
- Visualization
Introduction to Data Warehousing:
- Motivation for data warehousing
- Definition of data warehouse
- Normalized versus non-normalized schema