Data Warehousing Fundamentals

---
name: data-warehousing-fundamentals
description: "Use when learning data warehousing fundamentals."
version: 1.0.0
author: Hermes Agent
license: MIT
platforms: [linux, macos, windows]
metadata:
  hermes:
    tags: [database, data-warehouse, etl]
    related_skills: [general]
---

## Overview
Key concepts and principles. Build data warehouses.

## When to Use
- "Data Warehousing Fundamentals design and implementation"
- "Best practices for Data Warehousing Fundamentals"
- "Data Warehousing Fundamentals optimization and scaling"
- "Data Warehousing Fundamentals troubleshooting"

## Key Approaches
1. Define requirements
2. Choose tools
3. Implement modular
4. Test thoroughly
5. Document
6. Monitor

## Common Pitfalls
1. **Not accounting for constraints**
2. **Ignoring standards**
3. **Poor alignment**
4. **Inadequate testing**
5. **No documentation**
6. **Over-engineering**
7. **No rollback plan**
8. **Insufficient monitoring**
9. **No scalability plan**
10. **Missing validation**

## Verification Checklist
- [ ] Requirements validated
- [ ] Standards applied
- [ ] Design reviewed
- [ ] Tests defined
- [ ] Docs complete
- [ ] Monitoring configured
- [ ] Rollback plan
- [ ] Security review
- [ ] Post-deploy verification
- [ ] Stakeholder signoff