Hello,
I need this same assignment.
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 (DW) for Huffman Trucking using Microsoft® Visio® that shows the following:
- Integration layers
- The
data warehouse, with a Star Schema showing a Fact table and various
dimension tables with all their needed fields and relationships, as
covered in the class material. - Recommended data marts
Include arrows
to show ETL (extract, transform, and load) locations and direction, and
paste a screen shot of the above Visio Star schema along with the DW
description in a Word document.
Can you help?
0 comments