Data Warehousing Tutorials And Trainings

Data warehousing articles
Data warehousing articlesThis knowledge base provides an overview of Data Warehousing and Business Intelligence topics with articles covering Data Integration, data migration and quality management, Enterprise Information Management with examples and various ETL tools overiew....
http://www.etltools.org/data-warehousing.html
ETL Data warehousing tutorial
ETL Data warehousing tutorialThe ETL tutorial demonstrates the real-life data warehousing scenarios with sample solutions. The course depicts typical datawarehousing problems and shows many ways to handle and solve them using various ETL tools, such as Datastage, Pentaho Data Integration...
http://etl-tools.info/data-warehousing_tutorial.htm
Database and Data Warehouse Tuning Principles
Database and Data Warehouse Tuning PrinciplesDatabase and Data Warehouse Tuning principles, experiments and troubleshooting techniques is an over 200 slides presentation in the form of tutorial on how to tune the DWH system. The tutorial is organized into the following chapters: Basic Principles -...
http://cs.nyu.edu/courses/fall10/G22.2434-001/dbtune.ppt

Implementing Slowly Changing Dimensions
Implementing Slowly Changing DimensionsThe tutorial shows how to implement Slowly Changing Dimensions in a data warehouse. It lists all the major differences between different types of SCD (SCD Type 0 through to Type 4) and shows how to implement it in a real life data warehouse. The portal also...
http://etl-tools.info/en/scd.html
LearnDataModeling
LearnDataModelingThe LearnDataModeling site is aimed to help learning data warehousing. It contains information and learning materials about business intelligence, data modelling, database design for a data warehouse, ETL and metadata management. The examples are clear and...
http://www.learndatamodeling.com/
DW Architecture
DW ArchitectureData Warehouse architecture and concepts explained with examples. The site contains comparisons between different DW designs (Star, Snowflake and Fact Constellation schema) and overview of the multidimensional data modelling and managing slowly changing...
http://etl-tools.info/en/bi/datawarehouse_architecture.htm


Tag and category drill-down