|
DWX311: Introduction to DataWarehouses |
|
|
Tuition: $1595 per student |
Length: 5 days |
|
Synopsis:
This is a one week class for IT Management, Technical members of a
new data warehouse or data mart initiative or power users. It will
address the technical design considerations, the architecture, the
tools and their selection criteria as well as the reviewing in detail
of all key aspects of the project plan. |
Format:
Customized, instructor led. On-site at your facility. 4 to 20
students. There will be homework assignments each night and one work
group project. If applicable some vendor presentations will be made
during lunch breaks. Much of
this material is also available via online assistance. Call or inquire
for details. |
Scheduling:
All modules for this course should be scheduled consecutively. Lead
time is three weeks from date of order. |
Group
Discounts: 3
to 4 15%, 5 to 8 20% |
Group
Registration:
$200 |
|
|
Module I:
Data Warehouse Introduction.
Business Needs Review
OLTP
vs. OLAP
Data Warehouse
& Data Marts
Dimensional
View Introduction
Architecture
Top Level
Project Plan
Review of
roles during project.
End-user Responsibility
Key success factors
Examples of
End-User interface
Planning Phase
Document review
|
7 hours |
Module
II: Analysis, Star Schema Design
Analysis
Phase objectives
Analysis
Workshop
Star
Schema presentation
Shared
Dimensions
Star
Schema Development workshop.
|
7 hours |
Module
III: ETL, Architecture, Meta Data
ETL
Tools and selection criteria
ETL
Processes
Data
Sources.
Meta
Data
Data
Cleansing
ETL
Workshop
Performance
Issues
Testing
|
7 hours |
Module IV:
Business Intelligence, OLAP, Data Mining, Decision Support systems
Architecture review
Ad Hoc Query
Reporting
Push Pull technologies
OLAP concepts
and products
Data Mining
Decision
Support Systems
Business
Intelligence Workshop
Selection criteria
|
7 hours |
Module V:
Testing, Training, Rollout Maintenance
Module Testing
Subsystem
Testing ETL, BI, DSS
Star Schema Testing
Report Validation
End User training
Rollout Strategies
Maintenance
Help Desk
How to tell
when you have success
Iterations
Costing Exercise
|
7 hours |
Prerequisites:
Some knowledge of an enterprise database such as Oracle, DB2, SQL
Server, etc. Familiarity with Business Intelligence tools.
|
|
Materials:
Students will be provided a standard manual. They will also receive
a printout of the slides customized to their environment.
|
|
Location:
Classes are normally taught on-site at your facilities here in
Southern California. However, we can arrange for training rooms in
various locations when desired. We can also travel beyond Southern
California if appropriate. |
|
Related Services |
Need help with
a new DataWarehouse? We can also provide consulting services covering
the above material. Contact programming
for more information. |
|
|
|