Overview:
This 2-day short course provides a framework for understanding data warehousing and focuses particularly on the process of development.
Learning Method:
Using a combination of instructor presentation, facilitated group discussion, practical exercises and group case study exercises.
Who will benefit from this course?
The course is suitable for
- data administrators
- systems analysts
- business analysts
- project managers
- DSS and EIS developers
- analyst programmers
Pre-requisites
Before attending this course, you must have a basic understanding of database design, administration, and implementation concepts, and a satisfactory level of comfort within the Microsoft Windows 2000 environment.
What can you expect to gain from this course?
After completing this course, you will be able to:
- develop a data warehouse
- design a data warehouse
- plan a data warehouse project
- explain data warehouse concepts
- identify and address data quality problems
Course Content:
Module 1:Introduction to Data Warehousing
- What is a data warehouse?
- Data warehouse architecture
- Motivations for data warehousing
- Data warehousing - decision support systems and business intelligence
Module 2:The Data Warehousing Process
- a data warehousing process model
- data warehouse strategy and resourcing
- data warehousing design and development
- data warehousing operation
- data warehousing delivery system development and use
Module 3:Designing a Data Warehouse
- entity relationship modelling
- dimensional modelling
- an evolutionary approach to data warehouse design
- implementing and using a dimensional model and physical design of a data warehouse
Module 4: Data Quality and Meta-Data Management
- what is data quality?
- data sourcing and cleansing
- data quality dimensions and measurement
- data quality management
- meta-data management
Module 5:Delivery System Development
- business Intelligence systems
- OLAP tools
- data mining
- enterprise reporting