DBT530 Data Warehousing and Business Intelligence

This course explores a number of topics in business intelligence systems, especially data warehousing. Students learn the principles underlying efficient utilization of modern business intelligence systems, and apply these principles using the latest technologies provided by industrial DBMSs such as Microsoft's SQL Server and IBM's DB2. Students learn how to integrate data from various sources, use controlled denormalization to design efficient data warehouses and data marts, analyze and mine data, and design appropriate reports.

Credits

4 credits

Prerequisite

DBT230 Databases II or equivalent