Key Steps in DW/BI Implementation in Data Warehousing and Business Intelligence
Data Warehousing and Business Intelligence Requirements:
- Requirements’ Understanding
- Define and Maintain the DW/BI Architecture
- Define DW/BI Technical Architecture
- Define DW/BI Management Processes
Development of Data Warehouse and Data Marts
- Develop the Data Warehouse and Data Marts
- Map Sources to Targets
- Remediate and Transform Data
- Populate the Data Warehouse
Business Intelligence Implementation and User Management
- Implement the Business Intelligence Portfolio
- Group Users According to Needs
- Match Tools to User Requirements
Data Product Management and Performance Tuning
- Maintain Data Products
- Release Management
- Manage Data Product Development Lifecycle
- Monitor and Tune Load Processes
- Monitor and Tune BI Activity and Performance
Essential Tools for DW/BI Success
- Metadata Repository
- Data Dictionary / Glossary
- Data and Data Model Lineage
- Data Integration Tools
- Business Intelligence Tools
Advanced BI Applications in Data Warehousing and BI
- Operational Reporting
- Business Performance Management
- Operational Analytic Applications
- Multidimensional Analysis – OLAP
