RKG Logo training-ITBiz
RKG Logo
Home Courses Fees Schedule REGISTER NOW Corporate Training Locations
Microsoft Office Tools
Adobe Acrobat Courses
SharePoint Training
Microsoft Dynamics
Social Media Courses
Project Management
Application Devp Tools
Oracle Developer Tools
Data Warehouse & BI
Data Base & System Admin
Programming Languages
Reporting Tools
Networking & Security
Web Technologies
Medical Records
Business Skills
ERP Training
Corporate Training On-Site
Data Warehousing
Data Warehousing Fundamentals
Data Warehousing & Data Modeling - Fundamentals
Software Version 10.0
Course Duration 2 Days
Course Type Class Room and Instructor-Led On-Line (E-Learning) Hands-On Training
Course Overview In this course, students study the issues involved in planning, designing, building, populating, and maintaining a successful data warehouse. Students learn the reasons why data warehousing is a compelling decision-support solution in today's business climate. This course also covers the Data Warehouse and Business Intelligence.
Intended Audience for this course This course is designed for those who have technical background, knowledge with any computer language, Java, XML, .NET Developers, ERP Developers, DBAs, Application Technical Consultants, Business Analysts, Project Managers and Students who want to become IT Professionals.
Course Topics
Business Intelligence and Data Warehousing
  • The road map to Business Intelligence (BI)
  • Data warehouses compared with Online Transaction Processing (OLTP)
  • Management information systems and decision support systems (DSS)
  • Business drivers for data warehouses
  • Typical uses of a data warehouse
Defining Data Warehouse Concepts and Terminology
  • Common data warehouse definitions
  • Data warehouse properties and characteristics
  • Warehouse development approaches
  • Components of data warehouse design and implementation
  • Components of a data warehouse
  • Data warehouse compared with data mart
  • Dependent and independent data marts
Planning and Managing the Data Warehouse Project
  • Managing financial issues
  • Obtaining business commitment
  • Gathering business and user requirements
  • Evaluating the warehouse project
  • Implementation processes and requirements
Modeling the Data Warehouse
  • Data warehouse database design phases
  • Defining the business model
  • Choosing the architecture
  • Creating the dimensional model
  • Using time in the data warehouse
  • Using summary data
  • Query rewrite
  • Creating the physical model
Building the Warehouse - Extracting Data
  • Extracting, transforming, and loading data
  • Examining data sources
  • Extracting data
  • Extraction techniques
Building the Data Warehouse - Transforming Data
  • Transformation
  • Transforming data: problems and solutions
  • Resolving quality data issues
  • Transformation techniques
  • Transformation tools
Building the Data Warehouse - Loading Warehouse Data
  • Loading data into the warehouse
  • Building the loading process
  • Loading the data
  • Post-processing of loaded data
  • Verifying data integrity
Refreshing Warehouse Data
  • Capturing and applying changed data
  • Batch load requirements
  • Limitations of methods in applying change
  • Purging and archiving data
Leaving a Metadata Trail
  • Defining warehouse metadata
  • Developing a metadata strategy
  • Examining types of metadata
  • Metadata management tools
  • Common warehouse metadata
Managing the Data Warehouse
  • Managing the transition to production
  • Managing growth
  • Managing backup and recovery
  • Identifying data warehouse performance issues

Enroll Online   

Live Chat
Enroll Online
Enroll By Fax
Fee & Schedule
Send Message
Follow us on .....
For further information call 949-387-3772 or FAX 949-681-8247 or email to info@SONUtraining.com
SONU Training is the training wing of RKG Technologies Inc
Disclaimer: RKG Technologies is not linked with Microsoft, Oracle, Adobe, IBM or any other software company we provide training
Copyright © 2004 RKG Technologies Inc. All rights reserved.