Conceptual view of a data warehouse
Design a high-level conceptual view of a data warehouse (DW) for Huffman Trucking using Microsoft Visio that shows the following:
a) Integration layers
b) 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.
c) 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.