Site Map

Home

Data Warehouse Definition

• Data Warehouse Architecture

Data Warehousing Design

• 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
• Observations
  • Quick Implementation Time
  • Lack Of Collaboration with Data Mining Efforts
  • Industry Consolidation
  • How To Measure Success

Business Intelligence

• Business Intelligence Tools
• Business Intelligence Uses
• Business Intelligence News

Business Intelligence Software

• 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

Concepts

• Dimensional Data Model
• Star Schema
• Snowflake Schema
• Fact Table Granularity
• Fact And Fact Table Types
• Slowly Changing Dimension
• Type 1 Slowly Changing Dimension
• Type 2 Slowly Changing Dimension
• Type 3 Slowly Changing Dimension
• Conceptual Data Model
• Logical Data Model
• Physical Data Model
• Conceptual, Logical, and Physical Data Model
• Data Integrity
• What Is OLAP
• MOLAP, ROLAP, and HOLAP
• Bill Inmon vs. Ralph Kimball

Business Intelligence Jobs

Data Warehousing Books

• ETL Books
• OLAP Books
• General Books
• Data Modeling Books
• Vendor-Specific Books
• All Data Warehousing Books

Glossary

Site Map

Resources