IT 7200 BD WAREHOUSES AND DIMENSIONAL MODELING (3) (Second Concentration Only)

Students are provided an introductory overview of data warehousing principles, data warehouse techniques, and business intelligence systems. Data warehouse planning, design, implementation, and administration issues in a case study format will be explored. Topics include an introduction to the data warehouse and ETL process, data modeling, and online analytic processing, which includes; OLAP, ROLAP, MOLAP, HOLAP, designing tools to build a data warehouse, database types, modeling types, schemas, queries, software for package initiation such as airflow and SQL agent.