MIS 430: Data Warehousing Master Syllabus
Course Instructor:
Office Number:
Office Hours:
Email:
Course Meeting Times:
Textbook and Course Site
This course uses open educational resources (OERs). There is no book to purchase.
Course Description
Deals with the challenges faced by businesses in managing large amounts of data and making meaningful use of this data for informed decision making. Introduces students to data warehousing fundamentals, practices, and technologies; and their application to solving business problems. Specific emphasis is on designing of data warehouse to meet the business requirements and hands-on learning of the design principles through implementation on commercially used data warehouse technologies. Also introduces students to OLAP solutions and data mining approaches to supporting business decision making. Notes: Term project required. A third attempt will require academic advisor approval. Offered by Information Sys and Ops Mngmnt. Limited to two attempts.
Course Objectives
Upon completion of this course, students will be able to
- Understand the difference in the role of transaction databases and data warehouses, their objectives and how it influences the process of design and implementation of each
- Explain the architecture of data warehouses, and associated decision support systems
- Design approaches for data warehousing, with specific focus on relational data warehouse design
- Implement and operationalize data warehouses
- Evaluate and tune performance of data warehouses
- Create reports and OLAP using data warehouses
- Create business intelligence reports
- Develop extract, transform, and load processes
- Create solutions that the management of structured and unstructured data
- Describe big data and its use cases
MIS (Management Information Systems) Learning Goals
- Apply knowledge of information technology, operations, and business functions to assess, design and improve business processes.
- Effectively manage projects, including information technology projects.
- Understand the overall systems development life cycle and be able to recommend IT solutions.
BS Business Learning Goals
- The social, global, ethical, and legal contexts of business and will be able to reflect on the role of the individual in business.
- The ability to apply knowledge of professional skills necessary for success in business including effective business writing.
- Technical and analytic skills appropriate for success in business.
- The ability to apply knowledge of core business disciplines including accounting, finance, information systems, management, marketing, and operations management.
- How research in the business disciplines contributes to knowledge and how such research is conducted.
Grading Policy
| Assignment | Value |
|---|---|
| Homework (4) | 20 points |
| Quizzes (2) | 20 points |
| Exam (2) | 40 points |
| Project (1) | 20 points |
| Total | 100 points |
| Semester Grade Scale | |||
|---|---|---|---|
| A+ | 97 to 100 points | B- | 80 to 82.99 points |
| A | 93 to 96.99 points | C+ | 77 to 79.99 points |
| A- | 90 to 92.99 points | C | 73 to 76.99 points |
| B+ | 87 to 89.99 points | D | 60 to 69.99 points |
| B | 83 to 86.99 points | F | Below 60 points |
Reading Assignments
Students are required to study the course materials posted via MIS 430 Canvas course website.
MIS 430 Topical Outline
| Date | Lesson |
|---|---|
| 1 | SQL SQL Server Components Physical Database Architecture Transactions |
| 2 | Normal Form Modeling Indexes Constraints |
| 3 | Views Partitioning |
| 4 | Introduction to Data Warehousing |
| 5 | Star Schemas Dimensions |
| 6 | ETL |
| 7 | Snowflake Schemas Facts |
| 8 | Midterm Exam |
| 9 | SSAS Cubes |
| 10 | Reports and Business Intelligence |
| 11 | Introduction to Big Data |
| 12 | Pig |
| 13 | Hive |
| 14 | Data Mining Predictive Analytics |
| 15 | Final exam |
To print: Right-click and choose “Print,” then follow your browser’s print settings.
To download: Right-click and choose “Print,” then select “Save as PDF.”