Enterprise Data Warehouse and Business Intelligence

Victoria International College of Business and Technology
Toronto, Ontario, Canada

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

''

Instructors:



Stephen, Senior BI Consultant from government, over 11 years experience in Data Warehouse and Data Mart Projects, 13 years in IT industry.

(Who Teaches: Performance Management and Business Intelligence, Cognos)



Mahamadu, CBIP, CDMP, Senior Data Architect from government, over 10 years experience in Data Warehouse. He was a Sr. Consultant in Financial Services practice of BearingPoint before joining the government. The job involved in a wide range of consulting assignments covering designing, prototyping, developing and troubleshooting OLTP databases and Decision Support Systems (i.e. Data marts and Data warehouses).

(Who Teaches: Data Warehouse Theory)



Taiwo, Enterprise Data Warehouse Analysis and ETL Developer from government, over 15 years experience in most aspects of Information Technology such Software Development, Database Administration, Systems and Business Analysis, Data Modeling, Data Warehousing, INFORMATICA and DATASTAGE/COGNOS BI and Project Management from Consulting, Manufacturing and Public.

(Who Teaches: Data Warehouse and ETL, Informatica )

Enterprise Data Warehouse and Business Intelligence

Duration

60 Hours

Overview

As human race stepped into the information age, information is power. Business today moves at the speed of information. Getting the right information into the right hands at the right time is essential. Companies leverage, exploit and maximize their information assets have a strategic advantage over their competitors.

As management of information becomes more crucial to business, information capture is not enough for business today, data quality and data analysis plays a critical role in ROI for business.

That is also why data warehouse plays an important role in IT industry. Business can halt the business development due to the impact of low economy, but they cannot stop the data collection and management at any time. In order to increase the competitive power, data analysis and prediction become the key factor to be the winner in competition. That is also why ETL and business intelligence are getting an undeniable position today.

Objectives

This course will provide the students the full picture of data warehouse life cycle with practical examples and in depth knowledge. In addition, it covers the critical phases in building/developing Enterprise Data Warehouse such as Data Modeling using ERWIN, ETL design and development using INFORMATICA and Business Intelligence using COGNOS.

Topics

· Overview of Data Warehousing

· Data Warehouse Architectures

· Dimensional Modeling

· Data Warehouse System development Life Cycle

· SOA Data Integration

· ETL Design and Development

· Performance Management and Business Intelligence

· Data Mart Design and Development

Audience

Discerning candidates who wish to specialize in one ore more of the following areas:

· Data Warehouse Architecture

· Data Architecture

· Data Modeling

· ETL Design and Development

· BI Design and Development

· Enterprise Data Warehouse Systems Analysis

Prerequisites

Candidates for this class must have:

· IT background Knowledge

· Knowledge of at least one of the following RDBMS Oracle, MS-SQL, DB2 and Sybase

Victoria International College of Business and Technology
200 Consumers Road, Suite 118, M2J 4R4 Toronto (Victoria Park/Sheppard)
Phone: 647-290-5809, email: davidli@viccollege.com
Website: http://www.viccollege.com ...''

Phone:6472905809

School Address:

200 Consumer Road, Unit 118
Toronto, ON M2J 4R4

Jobs & Resumes: Toronto
Houses & Roommates: Toronto
Travel Agencies: Toronto

Search other schools for Enterprise Data Warehouse and Business Intelligence training resources.

Busines Analysis (BA)
Accpac and Excel
ORACLE/SAS/DATA WAREHOUSE
.NET
SAP
CSTE/CSQA
CCNA/CCNP/Unix

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: If you can not find a training course suitable for you instantly, you can leave your training request here and let trainers contact you later.