Data warehouse

An organization has several operational systems: Customer Relationship Management (CRM) for marketing and sales, Enterprise Resource Planning (ERP), and Supply Chain Management (SCM). They also have external customer data. A wide variety of departments utilize this data: sales, marketing, procurement, human resources, R&D, and senior management.

Design a high-level conceptual view of a data warehouse using Microsoft® Visio® that shows the following:

Integration layers The data warehouse Recommended data marts

Include arrows to show ETL (extract, transform, and load) locations and direction.