Data Warehouse for Huffman Trucking Maintenance
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 Maintenance using Microsoft® Visio® that shows the following:
The data warehouse (DW), with a Star Schema showing a Fact table and various dimension tables with all their needed fields and relationships
Recommended data marts
Include arrows to show ETL (extract, transform, and load) locations and direction, and paste a screen shot of the above Visio DW Star schema along with the DW description in a Word document.