Assignment Preparation: Activities include completing the SkillSoft courses, independent student reading, and research.
Complete Appendix B, "Business Intelligence from 1960 to Today," of the SkillSoft course, "Business Analysis for Business Intelligence."
Complete Appendix C, "The 101 on Data Warehousing," of the SkillSoft course, "Business Analysis for Business Intelligence."
Complete Appendix D, "Survey for a BI Project for the Purchasing Department," of the SkillSoft course, "Business Analysis for Business Intelligence."
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:
The data warehouse
Recommended data marts
Include arrows to show ETL (extract, transform, and load) locations and direction.