Step-by-step introduction to the traditional data warehousing with examples.
Set of modules with overview, example data, Python and SQL code.
Topics covered:
- multidimensional modelling
- slowly changing dimensions
- star and snowflake schema
- ETL basics: ocnforming dimension labels, transformations, mappings
- metadata based mappings
- master data management
- data quality and data quality indicators
- ETL job management
- Cubes server
- traditional data warehouse data maturity areas