MIS-636 – A

Data Warehousing and Business Intelligence

Course Syllabus

Contact Information

Phone: 201-216-5304

Email: jmorabit@stevens.edu

II. Required Course Materials

4. “DW packets” of design and management templates

Suggested Readings

All other readings, exercises, and assignments are posted to our electronic course site.

III. Course Objectives and Learning Goals

This course will focus on the design and management of data warehouse (DW) and business intelligence (BI) systems. The DW is the central element in collecting, integrating, and making sense – knowledge discovery – of an organization’s data. BI concerns the full range of analytical applications and its delivery to the desktop of users. Each of these areas is fundamentally different in character – business, architectural, and technical – from traditional databases and applications. Together they form the basis of modern business analytics and decision making in organizations today.

3. Data Design (Star-schema, Surrogate Keys, ODS)

4. Real-time Partitioned Tablespaces, Aggregations

9. Designing and Managing Very Large Rapidly Changing Dimensions

10. Implementation (ETL, Data Staging, and Physical Design)

Data design skills: Additional learning objectives include the assessment of a business or application domain and the design of a corresponding multi-dimensional database. Emphasis is placed on developing advanced design techniques.

Team skills: The final project is a team presentation of an end-to-end business intelligence system, from source systems through database design to data visualization formats for end users.

The course is organized around the following themes:

1. Analytics & Competitive Advantage

6. Project Management & Requirements

7. Architecture & Tool Selection

12. Big Data

13. Deployment & Growth

3. Accreditation Assignment (Individual) 10%

3. Class Participation, Exercises, and Homework (Team) 20%

Ethical Conduct

Reference: The Graduate Student Handbook, Stevens Institute of Technology.

Consistent with the above statements, all homework exercises, tests and exams that are designated as individual assignments must contain the following signed statement before they can be accepted for grading. ____________________________________________________________________

Grading Scale

We expect professional, high-quality work on all assignments. Writing style, grammar, spelling, and overall presentation will be considered in determining your grades. Unless otherwise noted, all written assignments must be typed on a computer, with a 12-point font and one-inch margins.

All assignments must be submitted either in person (for face-to-face classes) or as an attachment in Moodle’s email system (for Web Campus classes).

Late Penalties:

1. Introduction. Data as a Source of Advantage

2. Database design – Review

Data Warehouse Maturity Stages

4. Business Intelligence and the Value Chain

Initiate the Final Team Presentation

8. Technical Architecture & Product Selection

13. BI Application Development

14. Data Visualization

18. Final Team Presentations

SCHEDULE

- Real-time BI at Continental Airlines

- Advanced BI at Cardinal Health

- Analytics and business performance (revisited)

- Internal and external processes (revisited)

• Enterprise planning with applications by industry

• Project planning

• The multidimensional data model

- Multidimensional modeling: Star schema and “cube”

- Physical design and architecture

- Meta-data

• Surrogate keys

• Methods for tracking history

- Extended dimension and fact table design

• Data staging and extract, transformation, and load (ETL)

- Techniques for building dimensions - flattening hierarchies

- Streaming data

- MDDB and aggregation design

- Access tools and portal design

- Complex query design – operationalizing drill-across with outer-joins and cubes

- Data mining