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/

The Data Warehousing Institute
The Data Warehousing InstituteTDWI (The Data Warehousing Institute) provides education, training, certification, news, and research for executives and information technology (IT) professionals worldwide and it is a premier educational institute for business intelligence and data...
http://www.tdwi.org/index.aspx
Developing a Data Warehouse architecture
Developing a Data Warehouse architectureConsiderations about the development of a data warehouse and data warehouse architecture requirements by Warren Thornthwaite. The tutorial contains real-life examples and takes into consideration technical requirements like update of a data warehouse, global...
http://www.users.qwest.net/~lauramh/resume/thorn.htm
How to avoid database explosion
How to avoid database explosionThe author of that article points to a potential problem of Exploding multidimensional databases in the OLAP architectures. The article helps understand the problem of a database explosion and outlines the consequences of sparse data and shows a way to...
http://barc-research.com/research/business-intelligence/
Data warehouse real-world examples
Data warehouse real-world examplesThe data warehousing tutorial illustrates two real Data Warehousing scenarios. The first business case is a design of a real world data warehouse for Levis Strauss. Another is a hypothetical classic retail example which is represented as a series of scenes...
http://philip.greenspun.com/sql/data-warehousing.html
Data warehouse architecture training articles
Data warehouse architecture training articlesData warehousing training and tutorial articles on the pages of Kimball Group. The data warehouse architecture articles cover all the relevant areas a data warehouse architect need to have in mind when building a data warehouse. The tutorials take into...
http://www.kimballgroup.com/category/data-architecture/

Tag and category drill-down