Certified Data Mining and Warehousing Professional

Current Status

Not Enrolled

Price

Get Started

This course is currently closed

You must login before you access the courses page.

Course Content

Expand All

DATA WAREHOUSING INTRODUCTION 3 Topics

Expand

Lesson Content

0% Complete 0/3 Steps

Introduction

Meaning of Data Warehousing

History of Data Warehousing

DATA WAREHOUSING CHARACTERISTICS 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

Introduction

Data Warehousing

Operational vs. Informational Systems

Characteristics of Data Warehousing

ONLINE TRANSACTION PROCESSING 7 Topics

Expand

Lesson Content

0% Complete 0/7 Steps

Introduction

Data Warehousing and OLTP Systems

Processes in Data Warehousing OLTP

What is OLAP?

Who uses OLAP and WHY?

Multi-Dimensional Views

Benefits of OLAP

DATA WAREHOUSING MODELS 3 Topics

Expand

Lesson Content

0% Complete 0/3 Steps

Introduction

The Data Warehouse Model

Data Modeling for Data Warehouses

DATA WAREHOUSING ARCHITECTURE 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

Introduction

Structure of a Data Warehouse

Data Warehouse Physical Architectures

Principles of a Data Warehousing

DATA WAREHOUSING AND OPERATIONAL SYSTEMS 15 Topics

Expand

Lesson Content

0% Complete 0/15 Steps

Introduction

Operational Systems

“ Warehousing” Data outside the Operational Systems

Integrating Data from more than one Operational System

Differences between Transaction and Analysis Processes

Data is mostly Non-volatile

Data saved for longer periods than in transaction systems

Logical Transformation of Operational Data

Structured Extensible Data Model

Data Warehouse model aligns with the business structure

Transformation of the Operational State Information

De-normalization of Data

Static Relationships in Historical Data

Physical Transformation of Operational Data

Operational terms transformed into uniform business terms

DATA WAREHOUSING CONSIDERATIONS 3 Topics

Expand

Lesson Content

0% Complete 0/3 Steps

Introduction

Building a Data Warehouse

Nine Decisions in the design of a Data Warehouse

DATA WAREHOUSING – APPLICATIONS 2 Topics

Expand

Lesson Content

0% Complete 0/2 Steps

Introduction

Data Warehouse Application

ROI AND DESIGN CONSIDERATIONS 10 Topics

Expand

Lesson Content

0% Complete 0/10 Steps

Introduction

Need of a Data Warehouse

Business Considerations: Return on Investment

Organizational Issues

Design Considerations

Performance Considerations

TECHNICAL AND IMPLEMENTATION CONSIDERATIONS 9 Topics

Expand

Lesson Content

0% Complete 0/9 Steps

Introduction

Technical Considerations

Hardware Platforms

Balanced Approach

Optimal hardware architecture for parallel queryscalability

Data warehouse and DBMS Specialization

Communications Infrastructure

Implementation Considerations

Access Tools

DATA WAREHOUSING BENEFITS 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

Introduction

Benefits of Data Warehousing

Problems with Data Warehousing

Criteria for a Data Warehouse

PROJECT MANAGEMENT PROCESS 8 Topics

Expand

Lesson Content

0% Complete 0/8 Steps

Introduction

Project Management Process

The Scope Statement

Project Planning

Project Scheduling

Software Project Planning

Critical Path Method

Decision Making

WORK BREAKDOWN STRUCTURE 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

Introduction

Work Breakdow n Structure (WBS)

How to build a WBS (a serving suggestion)

To Create Work Breakdown Structure

From WBS to Activity Plan

Estimating Time

PROJECT ESTIMATION AND RISK 3 Topics

Expand

Lesson Content

0% Complete 0/3 Steps

Introduction

Project Estimation

Analyzing Probability & Risk

MANAGING RISK 7 Topics

Expand

Lesson Content

0% Complete 0/7 Steps

Managing Risks: Internal & External

Internal and External Risks

Critical Path Analysis

DATA MINING CONCEPTS 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

Introduction

Data Mining

Data Mining Background

Inductive Learning

Statistics

Machine Learning

DATA MINING AND KDD 9 Topics

Expand

Lesson Content

0% Complete 0/9 Steps

Introduction

What is Data Mining?

Data Mining: Definitions

KDD vs. Data Mining

Stages OF KDD

Machine Learning vs. Data Mining

Data Mining vs. DBMS

Data Warehouse

Statistical Analysis

ELEMENTS OF DATA MINING 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

Introduction

Elements and uses of Data Mining

Relationships & Patterns

Data Mining Problems/Issues

Goals of Data Mining and Know ledge Discovery

DATA INFORMATION AND KNOWLEDGE 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

Data, Information and Knowledge

What can Data Mining do?

How does Data Mining Work?

Data Mining in a Nutshell

DATA MINING MODELS 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

Data Mining

Data Mining Models

Discovery of Association Rules

Discovery of Classification Rules

DATA MINING ISSUES AND CHALLENGES 9 Topics

Expand

Lesson Content

0% Complete 0/9 Steps

Data Mining Problems/Issues