Business Analyst: What is a data warehouse for BAs?

Data warehouse — centralized repository for reporting.

Characteristics:

• Subject-oriented.
• Integrated.
• Time-variant.
• Non-volatile.

Architecture:

• ETL — Extract, Transform, Load.
• OLAP — Online Analytical Processing.
• Data marts — subsets.

Example:

BA role:

• Requirements for reports.
• Data modeling.
• Validation.