Online Data Warehousing & Business Intelligence Training
Course Overview:
IT and Business requirements influenced and shaped all dimensions of DWBI (Data Warehousing/Business Intelligence). This fully interactive course is designed to address these aspects. Commencing from DWBI's evolution the course travels towards current trends by covering technological and managerial contents all the way.
Eligibility & Prerequisites:
- Basic knowledge on Database concepts.
- Awareness about IT projects.
- Awareness about any management reporting Structure
Course Content:
Concepts
- Introduction to Data Warehousing
- Needs for Warehouse
- Difference between OLAP and OLTPs
- Data Mining and Knowledge discovery in Databases
- Business Intelligence
- Data Warehouse Architecture & Components
- Data Marts
- ODS
- Sources
- Staging Area
- Reporting
- Technical infrastructure
- Source Layer
- ETL Layer
- Presentation Layer
- Data Models and Structures for Data Warehouse
- Dimensional Modeling
- Conceptual Schema
- Logical Schema
- Physical Schema
- Facts
- Dimensions
Warehouse Construction Process (Data Development Life Cycle)
- Data Modeling
- Data Trafficking
- Data Profiling
- Data Presentation
- Meta Data Management
- Data Migration
Managing Warehouse Projects
- Different Roles in Warehouse projects
- Choosing Tools and Techniques
- Process model
- Validation & Balancing Act