MIS 587 Business Intelligence

Level

Graduate

Prerequisite(s)

MIS 531 Enterprise Data Management or equivalent database course

The objective of this course is to give students a broad overview of managerial, strategic and technical issues associated with Business Intelligence and Data Warehouse design, implementation, and utilization. Topics covered will include the principles of dimensional data modeling, techniques for extraction of data from source systems, data transformation methods, data staging and quality, data warehouse architecture and infrastructure, and the various methods for information delivery. Critical issues in planning, physical design process, deployment and ongoing maintenance will also be examined. Students will learn how data warehouses are used to help managers successfully gather, analyze, understand and act on information stored in data warehouses. The components and design issues related to data warehouses and business intelligence techniques for extracting meaningful information from data warehouses will be emphasized. The course will use state-of-the-art data warehouse and OLAP software tools to provide hands-on experience in designing and using Data Warehouses and Data Marts. Students will also learn how to gather strategic decision making requirements from businesses, develop key performance indicators (KPIs) and corporate performance management metrics using the Balanced Scorecard, and design and implement business dashboards. This course is also offered via the MISonline program.

Units

3