ITEC 542 - Data Warehousing, Mining, and Reporting

Credits: (3)

 
Advanced examination of the principles of database systems covering techniques for modeling, managing, and analyzing large data sets. The course covers the architectural components to support enterprise level business intelligence with in-depth coverage of the dimensional model, data integration, reporting, data visualization, performance dashboards, machine learning algorithms, and application of common data mining techniques. Students will design and develop an end-to-end business intelligence application including a data warehouse, an extract, transform, and load (ETL) process, a dashboard, reports, and a data mining application. Students must have completed a database course including hands-on experience with the relational model, SQL, security database design, and stored procedures.