BCS 425: Business Intelligence and Data Warehousing

Business Intelligence is the transformation of data into actionable information. This information is used by businesses to drive high-level decision making. This course is concerned with extracting data from the information systems that deal with the day-to-day operations and transforming it into data that can be used for decision making. Students will learn how to design and create a data warehouse, and how to utilize the process of extracting, transforming, and loading (ETL) data into data warehouses. Students will design and construct dynamic reports using the data warehouse and multi-dimensional online analytical processing (OLAP) cubes as the data source. Credits: 3.00

Prerequisite

BCS 260 with a grade of C or higher.

Course Objectives

At the completion of this course, students will:

1. Understand the business reasons for creating data warehouses and OLAP cubes.
2. Understand the characteristics of online transaction processing databases, data warehouses, and OLAP cubes and the reasons for creating them.
3. Understand, design, and construct an ETL solution.
4. Design and construct a BI system that includes a data warehouse and an OLAP cube.
5. Understand, design, and construct a solution that will populate a data warehouse and an OLAP cube.
6. Design and construct a dynamic reporting solution.

Textbooks

• Delivering Business Intelligence with Microsoft SQL Server 2012, by Brian Larson, published by McGraw-Hill, 2012.