Home Company Information Consulting Course Catalog Contact Us Request a Quote Government Corporate
 


Profile


e-Catalog


Contact

Search

Cart
Database Technologies - Data Warehousing: Building, Using, and Managing

Course Status: Released
Course Language: English
Course Duration: 4 Hours
Deployment Options: Online, Interactive CDs, Network, Downloads, Intranet

Audience
IT managers, decision support staff, higher management, and strategic developers
Prerequisites
A general knowledge of IT and databases
Course Aim
To discuss how a data warehouse is built, used, and managed
Learning Objectives
Describe how to plan the structure and content of a data warehouse.
Explain how to populate the warehouse with data.
Describe how to allocate user access, update the warehouse, and mine data.
Discuss activity monitoring, staff management, security, and the responsibilities of end-users.
Topics Covered
Planning
-
Defining objectives
- Gathering user perspectives
- Datamarts and enterprise models
- Choosing a platform

Populating
-
Migration from legacy databases
- Selecting data to capture
- Metadata
- Ensuring quality of data

Using
-
User access
- Updating the data warehouse
- Data mining
- Verification v. discovery tools

Managing
-
Monitoring activity and data
- Security
- Team and staff management
- End-user roles