Certified Data Mining and Warehousing Professional

TABLE OF CONTENT

​

DATA WAREHOUSING INTRODUCTION

• Introduction
• Meaning of Data Warehousing
• History of Data Warehousing

DATA WAREHOUSING CHARACTERISTICS

• Introduction
• Data Warehousing
• Operational vs. Informational Systems
• Characteristics of Data Warehousing

ONLINE TRANSACTION PROCESSING

• Introduction
• Data Warehousing and OLTP Systems
• Processes in Data Warehousing OLTP
• What is OLAP?
• Who uses OLAP and WHY?
• Multi-Dimensional View s
• Benefits of OLAP

DATA WAREHOUSING MODELS

• Introduction
• The Data Warehouse Model
• Data Modeling for Data Warehouses

DATA WAREHOUSING ARCHITECTURE

• Introduction
• Structure of a Data Warehouse
• Data Warehouse Physical Architectures
• Principles of a Data Warehousing

DATA WAREHOUSING AND OPERATIONAL SYSTEMS

• 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

• Introduction
• Building a Data Warehouse
• Nine Decisions in the design of a Data Warehouse

DATA WAREHOUSING - APPLICATIONS

• Introduction
• Data Warehouse Application

ROI AND DESIGN CONSIDERATIONS

• Introduction
• Need of a Data Warehouse
• Business Considerations: Return on Investment
• Organizational Issues
• Design Considerations
• Data content
• Metadata
• Data Distribution
• Tools
• Performance Considerations

TECHNICAL AND IMPLEMENTATION CONSIDERATIONS

• 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

• Introduction
• Benefits of Data Warehousing
• Problems with Data Warehousing
• Criteria for a Data Warehouse

PROJECT MANAGEMENT PROCESS

• Introduction
• Project Management Process
• The Scope Statement
• Project Planning
• Project Scheduling
• Software Project Planning
• Critical Path Method
• Decision Making

WORK BREAKDOWN STRUCTURE

• 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

• Introduction
• Project Estimation
• Analyzing Probability & Risk

MANAGING RISK

• Introduction
• Risk Analysis
• Risk Management
• Risk Analysis
• Managing Risks: Internal & External
• Internal and External Risks
• Critical Path Analysis

DATA MINING CONCEPTS

• Introduction
• Data Mining
• Data Mining Background
• Inductive Learning
• Statistics
• Machine Learning

DATA MINING AND KDD

• 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

• 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

• Data, Information and Knowledge
• What can Data Mining do?
• How does Data Mining Work?
• Data Mining in a Nutshell

DATA MINING MODELS

• Data Mining
• Data Mining Models
• Discovery of Association Rules
• Discovery of Classification Rules

DATA MINING ISSUES AND CHALLENGES

• Data Mining Problems/Issues
• Other Mining Problems
• Data mining Application Areas
• Data Mining Applications-Case Studies
• Housing Loan Prepayment Prediction
• Mortgage Loan Delinquency Prediction
• Crime Detection
• Store-Level Fruits Purchasing Prediction
• Other Application Area

DM NEAREST NEIGHBOR AND CLUSTERING TECHNIQUES

• Types of Knowledge Discovered during Data Mining
• Comparing the Technologies
• Clustering And Nearest-Neighbor Prediction Technique

DECISION TREES

• What is a Decision Tree?
• Decision Trees
• Where to use Decision Trees?
• Tree Construction Principle
• The Generic Algorithm
• Guillotine Cut
• Over Fit

DECISION TREES - ADVANCED

• Best Split
• Decision Tree Construction Algorithms
• Cart
• ID3
• C4.5
• Chaid
• How the Decision Tree Works
• State of the Industry

NEURAL NETWORKS

• Basics of Neural Networks
• Are neural networks easy to use?
• Business Scorecard
• Where to use Neural Networks
• Neural Networks for Clustering
• Neural Networks for Feature Extraction
• Applications Score Card
• The General Idea

NEURAL NETWORKS - ADVANCED

• What is a Neural Network Pparadigm?
• Design decisions in architecting a neural network
• Different types of Neural Networks
• Kohonen feature Maps
• Applications of Neural Networks
• Knowledge Extraction Through Data Mining

ASSOCIATION RULES AND GENETIC ALGORITHM

• Association Rules
• Basic Algorithms for Finding Association Rules
• Association Rules among Hierarchies
• Negative Associations
• Additional Considerations for Association Rules
• Genetic Algorithm
• Crossover
• Genetic Algorithms In detail
• Mutation
• Problem-Dependent Parameters
• Encoding
• The Evaluation Step
• Data Mining using GA

OLAP MULTIDIMENSIONAL DATA MODEL

• On Line Analytical Processing
• OLAP Example
• What is OLAP?
• Who uses OLAP and WHY?
• Multi-Dimensional Views
• Complex Calculations
• Time Intelligence

OLAP CHARACTERISTICS

• Definitions of OLAP
• Comparison of OLAP and OLTP
• Characteristics of OLAP: FASMI
• Basic Features of OLAP
• Special features

MULTIDIMENSIONAL AND MULTIRELATIONAL OLAP

• Introduction
• Multidimensional Data Model
• Multidimensional versus Multi-relational OLAP
• OLAP Guidelines

OLAP OPERATIONS

• Introduction
• OLAP Operations
• Lattice of Cubes, Slice and Dice Operations
• Relational Representation of the Data Cube
• DBMS
• Data Mining
• Mining Association Rules
• Classification by Decision Trees and Rules
• Prediction Methods

MOLAP/ ROLAP TOOLS

• Categorization of OLAP Tools
• MOLAP
• ROLAP
• Managed Query Environment (MQE)
• Cognos PowerPlay