BIT 551 - Data Warehousing and Business Intelligence

I start this course tonight with Professor Ron Calvaneso

BIT 551 Data Warehousing and Business Intelligence - 3 Credit Hours

This course introduces students to best practices for designing warehousing data structures and databases. Topics include advanced modeling concepts, including ragged and unbalanced hierarchies; conformed dimensions; degenerate dimensions; dimensions with multiple hierarchies; and surrogate and synthetic keys. ETL concepts, transformation goals of integration, cleansing, and granularity change are introduced. Students will perform data analysis, develop reports, and use query tools for data-mining to assist in effective business decision-making.