DWH Site map July 10, 2009 by Deepanshu Mehta Home Tools • • • • • • • •
General Considerations Database/Hardware Selection ETL Tool Selection OLAP Tool Selection OLAP Tool Market Share Reporting Tool Selection Metadata Tool Selection Data Warehouse Team Personnel Selection
Data Warehousing Steps • • • • • • • • • • • • •
Requirement Gathering Physical Environment Setup Data Modeling ETL OLAP Cube Design Front End Development Report Development Performance Tuning Query Optimization Quality Assurance Rollout To Production Production Maintenance Incremental Enhancements