Syllabus for DTM-532
Data Warehouse Design
Corporate data is used to make strategic business decisions. Business Intelligence (BI) is used to present data in such a way as to help businesses survive in a competitive market. A data warehouse (DW) is a read-only analytical database that is used as the foundation for BI systems and is designed to consolidate data from the various data stores supported by an organization. This course will focus on the design and technical aspects of building a data warehouse. The topics covered will include the data warehousing life cycle, data warehouse architectures, system planning, warehouse requirements gathering, schema development, warehouse design, and other implementation issues.
After completing this course, you should be able to:
CO1 Explain the concepts, techniques, structures, and methodologies used in data warehousing.
CO2 Assess user requirements in the design of data warehouse systems based on organizational structure.
CO3 Design dimensional models and physical databases to roll out a data warehouse.
CO4 Generate a plan to develop an extract, transform, load (ETL) system from the data warehouse.
CO5 Evaluate the implementation issues for data warehouse systems.
CO6 Evaluate the tools and techniques used for business intelligence and data warehousing.
You will need the following materials to complete your coursework. Some course materials may be free, open source, or available from other providers. You can access free or open-source materials by clicking the links provided below or in the module details documents. To purchase course materials, please visit the University's textbook supplier.
ISBN: 978-0470149775
Data Warehouse Design is a three-credit online course, consisting of six modules. Modules include an overview, topics, learning objectives, study materials, and activities. Module titles are listed below.
For your formal work in the course, you are required to participate in online discussion forums, complete written assignments, and complete a course project. See below for details.
Consult the Course Calendar for due dates.
One or more of your course activities may utilize a tool designed to promote original work and evaluate your submissions for plagiarism. More information about this tool is available in this document.
You will be required to participate in ten graded online discussion assignments. There is also one ungraded but required Introductions Forum in Module 1.
Discussion forums are on a variety of topics associated with the course modules. The purpose of the discussion forums is to help make the connection between the course concepts and the goals of the course. In discussion posts, you express your opinions and thoughts, provide support and evidence for the position(s) you take on a subject, and have the opportunity to ask questions and expand on insights provided by your classmates. Active participation is vital to your overall success in this course.
Located within the Evaluation Rubrics section of the course website is the online discussion forum rubric used to aid in the grading of all online discussion assignments.
You are required to complete six written assignments. The written assignments are on a variety of topics associated with the course modules.
You are required to develop a data warehouse project of your own choosing. This course project includes five milestones and you complete one milestone in each module from Module 2 to Module 6. The topics covered in milestones include project description, expected outcome, requirements and technical architecture, entity-relationship diagram (ERD) and star schema, physical database, and ETL plan. The final milestone will combine and integrate the four milestones into one final paper. For details of each milestone of the course project, please refer to the Course Project area of the course website.
Your grade in the course will be determined as follows:
All activities will receive a numerical grade of 0–100. You will receive a score of 0 for any work not submitted. Your final grade in the course will be a letter grade. Letter grade equivalents for numerical grades are as follows:
A | = | 93–100 | B | = | 83–87 | |
A– | = | 90–92 | C | = | 73–82 | |
B+ | = | 88–89 | F | = | Below 73 |
To receive credit for the course, you must earn a letter grade of C or higher on the weighted average of all assigned course work (e.g., assignments, discussion postings, project). Graduate students must maintain a B average overall to remain in good academic standing.
To succeed in this course, take the following first steps:
Consider the following study tips for success:
To ensure success in all your academic endeavors and coursework at Thomas Edison State University, familiarize yourself with all administrative and academic policies including those related to academic integrity, course late submissions, course extensions, and grading policies.
For more, see:
Copyright © 2017 by Thomas Edison State University. All rights reserved.
