Data warehouses are designed to provide organisations with an integrated set of high-quality data to support decision-makers. They should support flexible and multi-dimensional retrieval and analysis of data. Topics covered include data warehousing and decision-making, data warehouse design, data warehouse implementation, data sourcing and data quality, online analytical processing (OLAP), dashboards, data warehousing for customer relationship management, and case studies of data warehousing practice.
Intended learning outcomes
On completion of this subject, students should be able to:
Understand the main concepts underlying data warehouse design and implementation, data quality and retrieval and analysis of data.
Be familiar with data warehousing and its relationship to decision-making.
Design a Data warehouse
Be familiar with the role of data warehousing in customer relationship management.