Implementing Slowly Changing Dimensions
The 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
The 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
The 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 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
TDWI (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
TDWI (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
Considerations 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
Considerations 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
Data warehouse architecture training articles
Data 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/
Data 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/
How to avoid database explosion
The 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/
The 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
The 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
The 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 warehousing articles
This 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
This 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
Database and Data Warehouse Tuning Principles
Database 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
Database 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
ETL Data warehousing tutorial
The 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
The 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
| BI DW related | |