MIS903: Business Intelligence

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. Areas to be covered 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. Others areas around components and design issues relating 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.