Want to boost enrolments? Login and promote your courses
Searching for courses? Login or register
Go to homepage The smart course guide
Courses    
Most popular search | Share this page  
open My list: 0 courses
Courses related: data management courses data protection courses data mining course data warehousing courses data protection course in london data warehouse courses metadata management data warehouse life cycle services data warehouse course data warehousing course nvq 2 distribution warehouse and storage
Homepage > IT, Computing, Telecommunications > Analysis and Programming > Management and Information Systems

The Data Warehouse Lifecycle

in FAL TECHNOLOGIES (England)

Classes Training

Place:

London, London,...

Price:

£975 + VAT Special offers 

Duration:

3 Days

Start:

17/03/2008 other dates
See course programme

Requirements:

Information Technology background and good understanding of english..

Request free information

Course objectives:

This course is designed to equip delegates with the fundamentals and techniques required to build a comprehensive data warehouse. We believe that in today's market, professionals need to be multi talented and strategically positioned for the growth in Data Warehousing and Dimensional Modelling and this course will help prepare you for the implementation of a successful data warehouse.

FAL TECHNOLOGIES

F.A.L Technologies are experts in implementing datawarehousing and business intelligence solutions with over 20 years of consulting and implementation experience across the group. Our consultants have...

see more

Contact course provider

 

Request information

Contact directly and with no obligation with
FAL TECHNOLOGIES
You must complete all fields on this form in order for us to send it to the course provider.
We have highlighted incomplete/ incorrect details in red.
* Compulsory fields
By clicking "Email request / Telephone" you registering and accepting the Terms of Use and privacy policy of Emagister.
I wish to receive the personalised newsletter (during a maximum period of 15 days)

Availability?
How do I enrol?
Where can I get more information?

The person in charge of this course will receive your information request instantly.

Response time:
:| :) ;)
Average Fast Very fast
 

Course details

Type Training Duration 3 Days
Method / place Contact course provider Inhouse / Classes in London, London,... where
Students per class 20
Suitability This course is valuable for all those involved in major roles on a data warehouse project, from project managers to DBAs to data modellers and application developers. It is also ideal for IT professionals from various backgrounds including Information technology, who plan to cross train into Data warehousing and Dimensional modelling to enhance their careers.
Course objectives This course is designed to equip delegates with the fundamentals and techniques required to build a comprehensive data warehouse. We believe that in today's market, professionals need to be multi talented and strategically positioned for the growth in Data Warehousing and Dimensional Modelling and this course will help prepare you for the implementation of a successful data warehouse.
Requirements
Information Technology background and good understanding of english..
Price £975 + VAT
Special offer + Support
Request this special offer here
Get direct information on how to enrol, venues and availability...

Management and Information Systems courses (from other course providers)

 
MSP Advanced Practitioner
Maven Training Ltd
London - £925 + VAT
 
Sageline 50 for Non-Accountants
Pass training
London - £420 + VAT
 
Data Warehousing
We Teach You
Distance - £50 VAT inc.
 
SAGE Line 50
Reed Learning
London - £495 VAT inc.
 
Sunsystems 5 - Account Payable
SunSystems Training by Vantis
London - £450 + VAT
Compare the selected courses
+ management and information systems Courses + Management and Information Systems Courses in London + Courses in London + FAL TECHNOLOGIES Courses

Course programme

The Data Warehouse Lifecycle
The Data Warehouse Lifecycle

Course Outline

Data Warehousing framework

  • Concepts and definitions

    Project Planning


  • Scoping and risk assessment


  • Data warehouse project team roles and responsibilities


  • Project plan development and maintenance

    Dimensional Modelling


  • Definition of dimensional modelling


  • Definition of Fact and dimension tables


  • 4-step process for designing dimensional models


  • Denormalizing dimension hierarchies


  • Surrogate keys


  • Factless fact tables


  • Degenerate dimensions


  • Conforming dimensions


  • Slowing changing dimension techniques


  • Types of Fact tables


  • Large dimension design considerations


  • Multi-valued dimension attributes

    Product Selection


  • Techniques

    Deployment


  • speeding up the load cycle


  • Integrating data from multiple sources


  • Data Quality and Data Cleansing


  • User Education

    Technical Architecture


  • Overview of technical architecture


  • Architecture and Infrastructure


  • Planning and Growth


  • Common components and services


  • Staging area considerations


  • Data warehouse user types

    Metadata Management


  • Sources and management of metadata

    Design and Development


  • Operational Data Store (ODS)


  • Data management


  • Basic extract, transformation and load techniques


  • Surrogate key creation and maintenance


  • Fact table extract issues


  • Building aggregates

    On-going Maintenance


  • Training and support approaches


  • User support


  • Documentation and the web


  • On-going system maintenance

    • see the full course programme

    on request

    get more information on the programme directly from FAL TECHNOLOGIES.

    Request information for free
    Get direct information on how to enrol, venues and availability...
     

    Venues and dates



    Where London, 2nd Floor, 145-157 St John Street see map
    When Start: 17/03/2008 Finish: 19/03/2008 See calendar
     
    Where London, 2nd Floor, 145-157 St John Street see map
    When Start: 21/04/2008 Finish: 23/04/2008 See calendar
     
    Where London, 2nd Floor, 145-157 St John Street see map
    When Start: 19/05/2008 Finish: 21/05/2008 See calendar
     
    Where London, 2nd Floor, 145-157 St John Street see map
    When Start: 16/06/2008 Finish: 18/06/2008 See calendar
     
    Where London, 2nd Floor, 145-157 St John Street see map
    When Start: 21/07/2008 Finish: 23/07/2008 See calendar
     
    Get direct information on how to enrol, venues and availability...
     

    Course provider details

    Provider description
    F.A.L Technologies are experts in implementing datawarehousing and business intelligence solutions with over 20 years of consulting and implementation experience across the group. Our consultants have extensive experience of various ETL tools, design methodologies, advance dimension modelling and project management techniques. We have implemented datawarehousing and business intelligence solutions and provided consultancy and project management expertise to numerous organisations across multiple industry sectors.

    We offer data warehousing courses designed to equip delegates with the fundamentals and techniques required to build a comprehensive data warehouse.
    Get direct information on how to enrol, venues and availability...

    Information related to Management and Information Systems

    More related courses
    Prince2 Combined Foundation & Practitioners £1,899 + VAT London
    Sage Line 50 Computerised Book-Keeping £510 VAT inc. Distance
    + management and information systems Courses + Management and Information Systems Courses in London + FAL TECHNOLOGIES Courses
    emagister.com complies with the 15/1999 Organic Law dated 13th December (Spain), the Data Protection Law and holds the inscription code 2002010053 on the General Register of the Data Protection Agency. Copyright 1999/2000 - Grupo Intercom - All rights