BUAD 5772 - Databases and Data Warehouses for Business Intelligence

(4) Prerequisite(s): BUAD 5112 - Competing Through Business Analytics

This course covers fundamental topics related to developing and using databases and data warehouses to provide business intelligence (BI). The course includes: in-depth coverage of structured query language (SQL), stored programs, and database design and implementation, data warehousing concepts, dimensional modeling (star schemas), the extraction/transformation/load (ETL) process, and online analytical processing (OLAP)/ BI functionalities. As a final project, students build a small data warehouse, populate it with data, and create a dashboard to analyze and communicate the data to a broad audience.