Data Warehousing, IT-D 526
About this Course:
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.
Prerequisites:
IT-D 421 Database Concepts with Oracle or experience with relational databases and familiarity with basic programming concepts and SQL are required for enrollment.
Who Should Attend:
Professionals interested in learning data warehouse concepts and implementation.
Expected Outcomes:
After the successful completion of this course, participants will be able to,
- Explain top down and bottom up approaches for building data warehouses
- Correctly use data warehouse and business intelligence terminologies
- Explain and apply business dimensional lifecycle
- Perform multidimensional analysis
- Describe data warehouse infrastructure issues
- Determine the need for and management of meta data
- Explain the components of a data warehouse technical architecture
- Describe techniques for data extraction transformation and loading into a data warehouse
- Explain the techniques used for data presentation by analytical applications
- Demonstrate the techniques for building a dimensional data mart/warehouse
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
CEU:
4.5
Instructor:
Robert Hendry (Bob)
As an International Association for Continuing Education and Training (IACET) Authorized Provider, the Professional Learning Programs department of the IIT School of Applied Technology (SAT) offers CEUs for its programs that qualify under the ANSI/IACET Standard.