|
|
Course Description and Prerequisites:
This class will introduce the student to concepts needed for successfully designing, building and implementing a data warehouse. The class will provide the technological and managerial knowledge base for data modeling approaches such as the star schema and database de-normalization issues. Topics such as loading the warehouse, performance considerations, and other concepts unique to the data warehouse environment will be discussed and demonstrated in detail. This course will include a laboratory component.
Experience with relational databases and familiarity with basic programming concepts and SQL are required
Course Outline:
- Introduction to Business Intelligence and Corporate Information
- Introduction to Dimensional Modeling
- Advanced Dimensional Modeling
- Building Dimensional Models
- Implementation of the data warehouse component
- Physical design, Indexing, Physical storage
- Data extraction, transformation and loading(ETL)
- End User applications and Online analytical processing
- Data warehouse lifecycle and project management
- Data warehouse architectures and back room functions
- Infrastructure and Metadata
Information to the Corporate Information Factory, The Data wareouse component, The external world component
Multidimensional Model, Data wareouse requirements, Basic dimensional modeling techniques
Star and snowflake schemas, Extended dimension table designs, Extended fact table designs
Data warehouse management, Data warehouse bus architecture matrix, Managing the dimensional project
Aggregation goals and risks, Aggregation developement, Aggregation navigation
Standards, Indexing and Physical storage structure
Operational Data Store, Data Staging and ETL Strategies
The application component, Decision support
Developement and maintanence process, The business dimensional lifecycle, Data warehouse project management and data warehouse processes
Back room Functions and Architecture, Data storage, Managing the corporate information factory, Enterprise framework
Metadata repositories, security, Data warehouse infrastructure and environment security, Data warehouse metadata
| Instructor | Bob Hendry |
| Credit | 4.5 CEU |
Data Warehousing
Information & Registration:
To register or for additional information contact us by phone or email
Chicago or Wheaton 630-682-6035
reif@iit.edu