Designing a data warehouse: Supporting customer relationship management (Q2703783)

First the author introduces notions connected with data warehouses and shows how they can help in better Customer Relationship Management (CRM). Dimensional analysis using a star schema is conducted. A general conceptual model and also a logical model for a CRM-focused data warehouse are presented. The author discusses various ways of the logical implementation of solutions proposed in the conceptual model. Starting from architecture he presents the physical implementation of data warehouse taking into account possible difficulties. He describes managing of the data warehouse project. All issues are illustrated by the Wine Club example.