Data Warehouse Concepts
This one-day course provides a clear conceptual overview of the data warehouse.
All the characteristics and possibilities of data warehousing are covered, including definitions, myth and reality, key concepts, implementation and exploitation strategies.
Additional topics include "What does datamining mean?" and "What are the possibilities now?" as well as explaining the different types of products that can be of use (for cleaning, loading, extraction, etc.).
This course is available for one-company, live presentations over the Internet, via the Virtual Classroom Environment service.
What you will learn
On successful completion of this course you will be able to:
- describe the principles and concepts behind the data warehouse
- understand and use data warehousing terminology
- explain the infrastructure
- list the steps to design and implement a data warehouse.
Who Should Attend
IT personnel, particularly those responsible for the set-up of a warehouse and managers.
Prerequisites
General IT awareness and an understanding of Relational Database Management systems (RDBMS).
Duration
1 day
Fee (per attendee)
P.O.A.
This includes free online 24/7 access to course notes.
Hard copy course notes are available on request from rsmshop@rsm.co.uk
at £50.00 plus carriage per set.
Course Code
DWCA
Contents
Historical Background
Definitions
An explanation of the key concepts: datamart, DSS, OLAP, MDBMS, etc.
Data Warehouse Infrastructure
Back end (ETT/ETL); Data Store; Front end Tools; Meta Data.
Logical Implementation
The complete strategy; source data; transformation; loading; extraction; cleaning; maintenance; metadata; datamining.
Designing a Data Warehouse
No data warehouse without a well-considered datamodel; ER; Multi Dimensional Modeling; Snowflakes; Stars.