Design 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.