Ready to Learn More

BI DATA WAREHOUSING: FUNDAMENTALS

COURSE DESCRIPTION
What you will learn:

This 18 hours instructor-led course is designed to walk-through into real-world examples in-class exercises the core technologies, concepts, architecture, and various features of data warehouses and models. You gain hands-on experience in building a Data Warehouse through a formal process from the conceptual, logical, and physical phases of data warehousing using leading market tools.

COURSE OBJECTIVES

    At the end of this course, you should be able to:
  • Describe methods and tools for accessing and analyzing warehouse data
  • Describe the benefits of data warehousing
  • Explain the implementation and organizational issues surrounding a data warehouse project
  • Describe the various technologies required to implement a data warehouse
    WHO SHOULD ATTEND?
  • Data Warehouse Administrators
  • DBAs
  • Business Analyst
  • Project Managers
    REQUIRED PREREQUISITES
  • Data Modeling
COURSE CONTENTS
    MODULE ONE
  • Data Warehouse properties and characteristics
  • Gathering business and user requirements
  • Data warehouse database design phases
  • Defining the business model
    MODULE TWO
  • Data Warehousing Architecture
  • Using time and summarize data in the data warehouse
  • Examining data sources
  • Extraction techniques review
    MODULE THREE
  • Transforming data: issues and action items
  • Resolving quality data issues
  • Transformation techniques
  • Building the loading process
  • Transforming XML Schemas
Note:

Enrollment is limited to 20 attendees.

The program course contents are delivered either only evening time or at the weekends or in combination of both.