Online Data Warehouse eLearning Training
From Prediction Impact
Predictive Analytics Applied - Online Course
94% of in-person attendees rated the class Excellent or Very Good.
Predictive analytics is business intelligence technology that produces a predictive score for each customer or prospect. Each customer's predictive score informs actions to be taken with that customer - business intelligence just doesn't get more actionable than that.
Predictive Analytics Applied is a self-paced online course
more...
From Serebra Learning Corporation
Microsoft SQL Server 7.0: Designing and Implementing Data Warehouses - Part 1
...fied Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the characteristics of different decision support systems and components and tools used in data warehousing; identify the different techniques for gathering data; identify the basic requirements of the data warehouse; and
more...
Microsoft SQL Server 7.0: Designing and Implementing Data Warehouses - Part 2
...fied Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the design characteristics of OLAP systems and Aggregate schemas; identify the data warehouse models; identify the Data Transformation Services (DTS) components and the components of the DTS object model; identify the methods
more...
Microsoft SQL Server 7.0: Designing and Implementing Data Warehouses - Part 3
...fied Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to create a data warehouse database; perform the steps necessary to build and manage replication by using the Enterprise Manager; build a dimension and assign its member properties; build an aggregation and identify the guidelines for
more...
Microsoft SQL Server 7.0: Designing and Implementing Data Warehouses - Part 5
This is the final course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the features of the components of Microsoft Repository; perform the tasks related to managing a Microsoft SQL Server 7.0 data
more...
Data Management in Commerce Server 2000
To discuss data management in Commerce Server 2000 IT professionals who wish to use Commerce Server 2000 to implement and design e-commerce solutions; students preparing for Microsoft certification in the Designing and Implementing Solutions with Microsoft Commerce Server 2000 exam
more...
OS 390 Designing DB2 Data Warehouse
This course is an overview of IBM's DB2 mainframe relational database management system. It explains basic functions, features and elements of DB2 for OS/390 (known simply as DB2) and its interactions with the MVS environment. The course briefly reviews the development of DB2, including enhancements to Version 6, DB2 Universal Database for OS/390. It then familiarizes the student with the basic
more...
OS 390 Managing DB2 Data Warehouse
...rse presents an overview of issues involved in managing a data warehouse. Included are discussions of inflowing data from a variety of sources, converting and storing data, synchronizing data in a distributed environment, and accessing data for decision-support. The course is designed for managers and technical professionals who are considering implementing a data warehouse using DB2. Technical
more...
Fundamentals of Data Warehousing
The Fundamentals of Data Warehousing WBT is the first course in the Data Warehousing curriculum. It provides students with an introduction to the core technologies, concepts, architecture, and various features of data warehouses and models. It also provides students with the preliminary knowledge for planning and implementing data warehouses. People who have a fairly good knowledge of the concepts
more...
Building a Data Warehouse
The Building a Data Warehousing WBT is the second course in the Data Warehousing curriculum. It provides students with an overview of the core technologies, concepts, architecture, and various features of data warehouses, models, and data extraction tools. People who have a fairly good knowledge of the concepts of database systems, relational database management systems, and their architecture.
more...
SAP Business Information Warehouse BW - Configuration Overview
SAP Strategic Enterprise Management - Overview shows how companies can benefit from using a business information warehouse. The SAP BW component, and its underlying data model, will also be presented. Furthermore, the trainee will be introduced to two key tools for configuring the BW system. The audience for this course would include students who need to learn how to use SAP Business Information
more...
SQL Server 7.0 Data Warehousing SQL Part I
... information available to a wide audience of end users. A Data Warehouse refers to an enterprise-level store of standardized and summarized information. A Data Mart refers to a targeted subset of that information. Online Analytical Processing (OLAP) is then used to process the data. Microsoft SQL Server 7.0 provides several powerful tools for building data warehouses and data marts and OLAP
more...
SQL Server 7.0 Data Warehousing Part II
This course is a multi-step process of collecting cleansing and storing data for use in analyses and reporting applicaitions and making information available to a wide audience of end-users. Using the Data Transformation Services Package Designer the student will be able to define steps workflow and transformations necessary to build a data warehouse.
more...
Introduction to Data Warehousing
This course presents an introduction to Data Warehousing. Beginning with the basic concepts of data warehousing this course helps you understand the processes involved in and the architecture of data warehousing. The tools involved in analyzing the warehouse data will also be covered. Finally you'll learn about the Oracle data warehouse.
more...
Data Warehousing Fundamentals Part 1: Designing and Planning
...planning designing implementing and managing a successful data warehouse. Students learn the reasons for data warehousing as a popular solution the business imperatives driving data warehousing common data warehousing terminology the components of a data warehouse implementation and data warehouse modeling concepts. Students also explore the computer architectures commonly used to support data
more...
Data Warehousing Fundamentals Part 2: Building and Deploying
Oracle Data Warehousing Fundamentals: Building and Deploying introduces the concepts and strategies necessary to build and deploy a data warehouse successfully across the enterprise. This CBT course provides students with an overview of fundamental data warehousing concepts in both business and technical terms. In addition this course examines a variety of data warehouse architectures building
more...
Business Intelligence
This course builds on a series of closely related concepts. It provides you with an introduction to the basic and more advanced concepts of business intelligence and discusses the architectures of possible solutions. The content of the course is divided into two main sections. The first section takes a closer look at general principles and explains why business intelligence is necessary from the
more...
Planning an SQL 7.0 Data Warehouse
...Data Warehouse course is the first course in the SQL Server 7.0 - Data Warehousing curriculum consisting of four courses. It provides students with an introduction to the core technologies, concepts, architecture, and various features of data warehouses. It also provides students with the preliminary knowledge for planning and implementing data warehouses using SQL Server 7.0. In addition, the
more...
Implementing an SQL 7.0 Data Warehouse
...Data Warehouse course is the second course in the SQL Server 7.0 - Data Warehousing curriculum consisting of four courses. It helps students to design a database and enhance the efficiency of queries by using different types of indexes. It also describes the process of creating files and filegroups and helps students to select an application programming interface for accessing a data source. In
more...
Using SQL 7.0 OLAP Services
The Using SQL 7.0 OLAP Services course is the third course in the SQL Server 7.0 - Data Warehousing curriculum consisting of four courses. It provides students with an introduction to the concepts, architecture, and various features of the Online Analytical Processing (OLAP) Services . It also provides students with the preliminary knowledge for creating a data warehouse for use with OLAP
more...
Optimizing a SQL 7.0 Data Warehouse
...Data Warehouse is the fourth course in the SQL Server 7.0 - Data Warehousing curriculum consisting of four courses. It helps students to identify tasks for data warehouse maintenance and optimization. The students will be able to optimize query performance, optimize backup and restore operations, and perform automated administration of a data warehouse. In addition, the course prepares students
more...
Planning an MS SQL Server 7.0 Data Warehouse
This course provides the student with an introduction to the core technologies, concepts, architecture, and various features of data warehouses. It also provides the student with the preliminary knowledge for planning and implementing data warehouses using SQL Server 7.0 In addition, the course prepares students to take the Microsoft Certification Administering Microsoft SQL Server 7.0 (70-019).
more...
Implementing an MS SQL Server 7.0 Data Warehouse
This course teaches the student how to design a database and enhance the efficiency of queries by using different types of indexes. It also describes the process of crating files and filegroups and helps students to select an application programming interface for accessing a data source. In addition, the course prepares students to take the Microsoft Certification Administering Microsoft SQL
more...
Using MS SQL Server 7.0 OLAP Services
This course provides the student with an introduction to the concepts, architecture, and various features of the Online Analytical Processing (OLAP) services. It also provides students with the preliminary knowledge for creating a data warehouse for use with OLAP services. The students will be able to design and optimize an OLAP database. In addition, the course prepares students to take the
more...
Optimizing a MS SQL Server 7.0 Data Warehouse
This course helps the student to identify tasks for data warehouse maintenance and optimization. The students will be able to optimize query performance, optimize backup and restore operations, and perform automated administration of a data warehouse. In addition, the course prepares students to take the Microsoft Certification Administering Microsoft SQL Server 7.0 (70-019).
more...
From 123-CBT Computer Based Training
SQL Server 7 0 Designing and Implementing Data Warehouses - Part 5

...fied Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the features of the components of Microsoft Repository; perform the tasks related to managing a Microsoft SQL Server 7.0 data warehouse; and perform the tasks related to database maintenance in Microsoft SQL Server 7.0. L
more...
SQL Server 7 0 Designing and Implementing Data Warehouses - Part 4

...fied Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the methods of aggregating and accessing data from relational data structures; identify the methods of data access from multidimensional data structures; identify the features and functionality of Pivot Table Service, Local
more...
SQL Server 7 0 Designing and Implementing Data Warehouses - Part 3

...fied Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to create a data warehouse database; perform the steps necessary to build and manage replication by using the Enterprise Manager; build a dimension and assign its member properties; build an aggregation and identify the guidelines for
more...
SQL Server 7 0 Designing and Implementing Data Warehouses - Part 2

...fied Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the design characteristics of OLAP systems and Aggregate schemas; identify the data warehouse models; identify the Data Transformation Services (DTS) components and the components of the DTS object model; identify the methods
more...
SQL Server 7 0 Designing Implementing Data Warehouses - Part 1

...fied Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the characteristics of different decision support systems and components and tools used in data warehousing; identify the different techniques for gathering data; identify the basic requirements of the data warehouse; and
more...
Business Intelligence

...f possible first practical experiences within sections of Data Warehouse.
T otal Learning Time
4 - 6 Hour(s)
Course Contents
Unit 1: Strategic Enterprise Management
Duration: 2 - 3 Hour(s)
Overview.
Case for Action.
Mission of Business Intelligence.
Business Intelligence tasks.
Development of a BI Solution.
Categorization/Keywords.
History from ERP to SEM.
Scope of
more...
Data Modeling - Develop Depth to Your Models

...g a business scenario.
Identify the characteristics of a Data Warehouse.
Identify a Fan trap within an ER Model.
Identify a resolution for a Fan trap.
Identify a chasm trap within an ER model.
Identify a resolution for a chasm trap.
Identify the problems caused by too much convergence in an ER model.
Identify the problems caused by too much divergence in an ER model.
Identify why
more...
Introduction to Data Warehousing

...l also be covered. Finally, you'll learn about the Oracle data warehouse.
L earn To:
Identify the basic concepts and terminology of data warehousing.
Identify the different processes and tasks involved in an integrated warehouse environment.
Identify the different data warehouse architectures.
Identify the different data warehouse models.
Identify the range of Oracle
more...
SAP R 3 Business Info Warehouse BW - Config Overview

...he BW system. Learn To: o Basics. o Objectives of a Data Warehouse. o SAP Business Information Warehouse. o Data Model. o Implementation Tools. o Administrator Workbench. o Simple Upload Scenario. o Business Content. Audience The audience for this course would include students who need to learn how to use SAP Business Information Warehouse, members of project teams
more...
From BIS
Datawarehouse Online classes by RAM
We are conduction online classes for the following subjects
1. Informatica
2. Business Objects
3. Teradata (certification also)
4. Datastage
7 years of Datawarehouse experience in singapore
contact: ramswins@gmail. com
+91 9940409993 India
more...
From The Virtual Training Company
Data Modeling
Data modeling is the act of exploring data-oriented structures. When building a database, data modeling implies the creation of a model for data within that database. Data models can be used for a variety of purposes, from high-level conceptual models to physical data models. VTC author, Gavin Powell, covers topics such as normalization and denormalization for relational data modeling, fact
more...
From Teach Me IT
Planning an Oracle8 Data Warehouse

...Data Warehouse is the first course in the Oracle8 DataWarehousing curriculum. The course enables a user to understand the concepts of data warehousing and learn how to plan a data warehouse design. The course familiarizes the users with the data warehouse architecture and process flow, as well as various Oracle features that support data warehousing. Additionally, the course explains in length
more...
Implementing an Oracle8 Data Warehouse

...data warehouse is the second course in the Oracle8 Data Warehousing curriculum. The course provides the users an insight into the functionalities of an Oracle data warehouse and enables them to organize for building a data warehouse. Apart from getting familiar with the concepts of moving and managing data, the users also receive a sound understanding of SQL*Loader, a common tool for populating
more...
Optimizing and Securing an Oracle8 Data Warehouse

...Data Warehouse is the third course of the Oracle8 Data Warehousing curriculum. This course acquaints users to the various methods that can be employed to secure and optimize an Oracle8 data warehouse. The course explains the concepts of tuning the data warehouse, creating backups, recovering and archiving data. The course extensively covers aspects related to securing the data warehouse and
more...
Planning an SQL 7.0 Data Warehouse

...Data Warehouse course is the first course in the SQL Server 7.0 - Data Warehousing curriculum consisting of four courses. This curriculum prepares students to take the Microsoft Certification Administering Microsoft SQL Server 7.0 (70-019) exam. It provides students with an introduction to the core technologies, concepts, architecture, and various features of data warehouses. It also provides
more...
Implementing an SQL 7.0 Data Warehouse

...Data Warehouse course is the second course in the SQL Server 7.0 - Data Warehousing curriculum consisting of four courses. This curriculum prepares students to take the Microsoft Certification Administering Microsoft SQL Server 7.0 (70-019) exam. It helps students to design a database and enhance the efficiency of queries by using different types of indexes. It also describes the process of
more...
Using SQL 7.0 OLAP Services

...es students with the preliminary knowledge for creating a data warehouse for use with OLAP Services. The students will be able to design and optimize an OLAP database. After completing this course, the student will be able to:
Describe the components, architecture, and features of OLAP Services
Install OLAP Services
Build an OLAP database for use with a data warehouse
Build an OLAP cube
more...
Optimizing an SQL 7.0 Data Warehouse

...Data Warehouse is the fourth course in the SQL Server 7.0 - Data Warehousing curriculum consisting of four courses. This curriculum prepares students to take the Microsoft Certification Administering Microsoft SQL Server 7.0 (70-019) exam. It helps students to identify tasks for data warehouse maintenance and optimization. The students will be able to optimize query performance, optimize backup
more...
Fundamentals of Data Warehousing

...nologies, concepts, architecture, and various features of data warehouses and models. It also provides the preliminary knowledge for planning and implementing data warehouses. After completing this course, the student will be able to:
Describe the existing information systems and the need for new information systems
Define a data warehouse in terms of the characteristics that differentiate
more...
Building a Data Warehouse

...nologies, concepts, architecture, and various features of data warehouses, models, and data extraction tools. After completing this course, the student will be able to:
List the steps for scrubbing data
Map source data to subject area
Verify data integrity
Map subject areas to the warehouse model
Understand how to model the operational data store
Identify different kinds of temporal data
more...
