CIS429
Preview: CIS429 : Data Warehouse Planning
Course Guide
Prerequisites
Course Description
Instructional Materials
Course Learning Outcomes
Weekly Course Schedule
Week 1 - To Do List
Introductions: Introduce yourself to your peers and professor.
Learn: Read Exam
Ref
70-767
Implementing
a
SQL
Data
Warehouse,
Chapter 1, Skill 1.1.
Learn: View CBT Nuggets videos.
Assignment: Complete CBT Nuggets Virtual Labs 4 and 6.
CIS111
This course covers the principles, approaches and critical issues in planning, designing and deploying data warehouses. Topics include data extraction,
data cleansing, data transformation, architecture and infrastructure. Students will examine recent trends in data warehousing, metadata and
architectural components.
Required Resources
Jose Chinchilla; 2018. Exam
Ref
70-767
Implementing
a
SQL
Data
Warehouse. Pearson Education.
CBT Nuggets. No date. Microsoft SQL Data Warehouse Implementation (70-767). https://www.cbtnuggets.com
Note: A student code is required and must be purchased through the Strayer Bookstore. The Strayer Bookstore will distribute this code to each
registered student’s email address. Students should check their junk mail folder as well as their inbox folder for the email.
Design, implement, and maintain a data warehouse infrastructure.
1
Design extract, transform, and load (ETL) solutions for a data warehouse.
2
Build data quality solutions using best practices.
3
NOTE: The links in this document do not function. Please refer to your course to view/download linked content.
Week 1 - To Do List
Quiz: Complete the weekly quiz.
Discussion: Participate in the weekly debriefing discussion.
Week 2 - To Do List
Learn: Read Exam
Ref
70-767
Implementing
a
SQL
Data
Warehouse, Chapter 1, Skills 1.2 and 1.3.
Learn: View CBT Nuggets videos.
Assignment: Complete CBT Nuggets Virtual Labs 12 and 13.
Quiz: Complete the weekly quiz.
Discussion: Participate in the weekly debriefing discussion.
Week 3 - To Do List
Learn: Read Exam
Ref
70-767
Implementing
a
SQL
Data
Warehouse,
Chapter 1, Skills 1.4 and 1.5.
Learn: View CBT Nuggets videos.
Assignment: Complete CBT Nuggets Virtual Labs 16 and 17.
Quiz: Complete the weekly quiz.
Discussion: Participate in the weekly debriefing discussion.
Week 4 - To Do List
Learn: Read Exam
Ref
70-767
Implementing
a
SQL
Data
Warehouse, Chapter 2, Introducing SSIS and Skill 2.1.
Learn: View CBT Nuggets videos.
Assignment: Complete CBT Nuggets Virtual Labs 21 and 23.
Quiz: Complete the weekly quiz.
Discussion: Participate in the weekly debriefing discussion.
Week 5 - To Do List
Week 5 - To Do List
Learn: Read Exam
Ref
70-767
Implementing
a
SQL
Data
Warehouse, Chapter 2, Skill 2.1 (Part 2).
Learn: View CBT Nuggets videos.
Assignment: Complete CBT Nuggets Virtual Labs 26 and 29.
Quiz: Complete the weekly quiz.
Discussion: Participate in the weekly debriefing discussion.
Week 6 - To Do List
Learn: Read Exam
Ref
70-767
Implementing
a
SQL
Data
Warehouse, Chapter 2, Skill 2.2.
Learn: View CBT Nuggets videos.
Assignment: Complete CBT Nuggets Virtual Labs 32 and 33.
Quiz: Complete the weekly quiz.
Discussion: Participate in the weekly debriefing discussion.
Week 7 - To Do List
Learn: Read Exam
Ref
70-767
Implementing
a
SQL
Data
Warehouse, Chapter 2, Skills 2.3 and 2.4.
Learn: View CBT Nuggets videos.
Assignment: Complete CBT Nuggets Virtual Labs 38 and 39.
Quiz: Complete the weekly quiz.
Discussion: Participate in the weekly debriefing discussion.
Week 8 - To Do List
Learn: Read Exam
Ref
70-767
Implementing
a
SQL
Data
Warehouse,
Chapter 2, Skills 2.5 and 2.6.
Learn: View CBT Nuggets videos.
Assignment: Complete CBT Nuggets Virtual Labs 40 and 41.
Week 8 - To Do List
Quiz: Complete the weekly quiz.
Discussion: Participate in the weekly debriefing discussion.
Week 9 - To Do List
Learn: Read Exam
Ref
70-767
Implementing
a
SQL
Data
Warehouse,
Chapter 3, Skills 3.1 and 3.2.
Learn: View CBT Nuggets videos.
Assignment: Complete CBT Nuggets Virtual Labs 45 and 47.
Quiz: Complete the weekly quiz.
Discussion: Participate in the weekly debriefing discussion.
Week 10 - To Do List
Learn: Read Exam
Ref
70-767
Implementing
a
SQL
Data
Warehouse, Chapter 3, Skills 3.1 and 3.2.
Learn: View CBT Nuggets videos.
Assignment: Complete CBT Nuggets Virtual Labs 50 and 51.
Quiz: Complete the weekly quiz.
Discussion: Participate in the weekly debriefing discussion.
Week 11 - To Do List
Discussion: Participate in the weekly debriefing discussion.
Grading Scale
Participation Total Points % of Grade
Discussion Participation 200 20%
Assignment Total Points % of Grade
w01a1 - CBT Nuggets Virtual Labs 4 and 6 40 4%
w01q1 - Skill 1.1 Quiz 40 4%
w02a1 - CBT Nuggets Virtual Labs 12 and 13 40 4%
Participation Total Points % of Grade
w02q1 - Skills 1.2 and 1.3 Quiz 40 4%
w03a1 - CBT Nuggets Virtual Labs 16 and 17 40 4%
w03q1 - Skills 1.4 and 1.5 Quiz 40 4%
w04a1 - CBT Nuggets Virtual Labs 21 and 23 40 4%
w04q1 - Skill 2.1 (Part 1) Quiz 40 4%
w05a1 - CBT Nuggets Virtual Labs 26 and 29 40 4%
w05q1 - Skill 2.1 (Part 2) Quiz 40 4%
w06a1 - CBT Nuggets Virtual Labs 32 and 33 40 4%
w06q1 - Skill 2.2 Quiz 40 4%
w07a1 - CBT Nuggets Virtual Labs 38 and 39 40 4%
w07q1 - Skills 2.2 and 2.3 Quiz 40 4%
w08a1 - CBT Nuggets Virtual Labs 40 and 41 40 4%
w08q1 - Skills 2.5 and 2.6 Quiz 40 4%
w09a1 - CBT Nuggets Virtual Labs 45 and 47 40 4%
w09q1 - Skills 3.1 and 3.2 Quiz 40 4%
w10a1 - CBT Nuggets Virtual Labs 50 and 51 40 4%
w10q1 - Skills 3.3 and 3.4 Quiz 40 4%
Totals 1000 100%
Final Course Grade
Points Percentage Grade
900 - 1000 90% - 100% A
800 - 899 80% - 89% B
700 - 799 70% - 79% C
600 - 699 60% - 69% D
0 - 599 59% and below F
Unique Course Features
Grading Scale Notation
Please consult the University Catalog and your academic advisor to determine the final grade needed in this class to satisfy your specific degree
conferral requirements.
Retired Certification Exam
Microsoft announced that due to its intention to move towards role-based certifications, exams associated with Microsoft Certified Solutions Associate (MCSA),
Microsoft Certified Solutions Developer (MCSD), and Microsoft Certified Solutions Expert (MCSE) certifications will be retired. The exams associated with these
certifications are scheduled to retire on January 31, 2021.
The content in this course aligns with the Microsoft certification exam 70-767, which is a retired exam. Students should disregard any and all references to the
Microsoft certification in course materials. However, as the content itself is still relevant and valuable in the industry, students will be expected to demonstrate
competency through the completion of all course activities and assignments, including labs, quizzes, and discussions.
Assignments
w01a1 - CBT Nuggets Virtual Labs 4 and 6
Summary
Click the linked activity title to access this assignment.
Text
For help with your lab reports, see this week's lab report guide. Each guide is tailored to a specific lab assignment, so please read this each week:
Week 1 Lab Report [PDF].
Labs
Click each link below and then Launch Virtual Lab on the CBT Nuggets page that appears to launch the following labs:
Lab 4: Installing and Configuring SQL Server With SSIS (lab report required).
Lab 5: Fact and Dimension Tables.
Lab 6: Star and Snowflake Schemas (lab report required).
Lab 8: Dimension Table Details.
Note: You are highly encouraged to complete all of the labs. Lab reports are only required as indicated.
How to Submit Your Lab Reports
To successfully submit your lab results, follow these directions:
Complete the CBT Nuggets virtual labs assigned this week.
Take screenshots of your results as prescribed by this week's Lab Report guide.
Collect your screenshots for the required labs into a single document.
Don't forget to highlight the specific information.
Submit your document to this assignment.
Note: Failure to submit the result into the assignment submission area within the Strayer online courseroom will result in 0 points for the assignment.
Evidence of purposely skipped answers, incomplete answers, or limited effort is at the instructor's discretion, and may result in partial or incomplete
credit for the assignment.
Scoring Guide
Complete lab and submit with all required materials. 100 %
Unacceptable
Completed less than 60%
of the lab submission.
Needs Improvement
Completed 60–69% of the
lab submission.
Satisfactory
Completed 70–79% of the
lab submission.
Competent
Completed 80–89% of the
lab submission.
Exemplary
Completed 90–100% of the
lab submission.
w02a1 - CBT Nuggets Virtual Labs 12 and 13
Summary
Click the linked activity title to access this assignment.
Text
For help with your lab reports, see this week's lab report guide. Each guide is tailored to a specific lab assignment, so please read this each week:
Week 2 Lab Report [PDF].
Labs
Click each link below and then Launch Virtual Lab on the CBT Nuggets page that appears to launch the following labs:
Lab 10: Designing Fact Tables.
Lab 12: Clustered vs. Non-Clustered Indexes (lab report required).
Lab 13: Rowstore vs. Columnstore Indexes (lab report required).
Note: You are highly encouraged to complete all of the labs. Lab reports are only required as indicated.
How to Submit Your Lab Reports
To successfully submit your lab results, follow these directions:
Complete the CBT Nuggets virtual labs assigned this week.
Take screenshots of your results as prescribed by this week's Lab Report guide.
Collect your screenshots for the required labs into a single document.
Don't forget to highlight the specific information.
Submit your document to this assignment.
Note: Failure to submit the result into the assignment submission area within the Strayer online courseroom will result in 0 points for the assignment.
Evidence of purposely skipped answers, incomplete answers, or limited effort is at the instructor's discretion, and may result in partial or incomplete
credit for the assignment.
Scoring Guide
Complete lab and submit with all required materials. 100 %
Unacceptable
Completed less than 60%
of the lab submission.
Needs Improvement
Completed 60–69% of the
lab submission.
Satisfactory
Completed 70–79% of the
lab submission.
Competent
Completed 80–89% of the
lab submission.
Exemplary
Completed 90–100% of the
lab submission.
w03a1 - CBT Nuggets Virtual Labs 16 and 17
Summary
Click the linked activity title to access this assignment.
Text
For help with your lab reports, see this week's lab report guide. Each guide is tailored to a specific lab assignment, so please read this each week:
Week 3 Lab Report [PDF].
Labs
Click each link below and then Launch Virtual Lab on the CBT Nuggets page that appears to launch the following labs:
Lab 16: Implementing Partition Functions and Schemes (lab report required).
Lab 17: Implementing a Sliding Partition Window (lab report required).
Note: You are highly encouraged to complete all of the labs. Lab reports are only required as indicated.
How to Submit Your Lab Reports
To successfully submit your lab results, follow these directions:
Complete the CBT Nuggets virtual labs assigned this week.
Take screenshots of your results as prescribed by this week's Lab Report guide.
Collect your screenshots for the required labs into a single document.
Don't forget to highlight the specific information.
Submit your document to this assignment.
Note: Failure to submit the result into the assignment submission area within the Strayer online courseroom will result in 0 points for the assignment.
Evidence of purposely skipped answers, incomplete answers, or limited effort is at the instructor's discretion, and may result in partial or incomplete
credit for the assignment.
Scoring Guide
Complete lab and submit with all required materials. 100 %
Unacceptable Needs Improvement Satisfactory Competent Exemplary
Completed less than 60%
of the lab submission.
Completed 60–69% of the
lab submission.
Completed 70–79% of the
lab submission.
Completed 80–89% of the
lab submission.
Completed 90–100% of the
lab submission.
w04a1 - CBT Nuggets Virtual Labs 21 and 23
Summary
Click the linked activity title to access this assignment.
Text
For help with your lab reports, see this week's lab report guide. Each guide is tailored to a specific lab assignment, so please read this each week:
Week 4 Lab Report [PDF].
Labs
Click each link below and then Launch Virtual Lab on the CBT Nuggets page that appears to launch the following labs:
19: Introducing SSIS.
20: Introducing Flows.
21: Connection Manager (lab report required).
22: Precedence and Expression Constraints.
23: SSIS in Action (lab report required).
Note: You are highly encouraged to complete all of the labs. Lab reports are only required as indicated.
How to Submit Your Lab Reports
To successfully submit your lab results, follow these directions:
Complete the CBT Nuggets virtual labs assigned this week.
Take screenshots of your results as prescribed by this week's Lab Report guide.
Collect your screenshots for the required labs into a single document.
Don't forget to highlight the specific information.
Submit your document to this assignment.
Note: Failure to submit the result into the assignment submission area within the Strayer online courseroom will result in 0 points for the assignment.
Evidence of purposely skipped answers, incomplete answers, or limited effort is at the instructor's discretion, and may result in partial or incomplete
credit for the assignment.
Scoring Guide
Complete lab and submit with all required materials. 100 %
Unacceptable
Completed less than 60%
of the lab submission.
Needs Improvement
Completed 60–69% of the
lab submission.
Satisfactory
Completed 70–79% of the
lab submission.
Competent
Completed 80–89% of the
lab submission.
Exemplary
Completed 90–100% of the
lab submission.
w05a1 - CBT Nuggets Virtual Labs 26 and 29
Summary
Click the linked activity title to access this assignment.
Text
For help with your lab reports, see this week's lab report guide. Each guide is tailored to a specific lab assignment, so please read this each week:
Week 5 Lab Report [PDF].
Labs
Click each link below and then Launch Virtual Lab on the CBT Nuggets page that appears to launch the following labs:
Lab 24: File Tasks.
Lab 25: Web Service Tasks.
Lab 26: Variables (lab report required).
Lab 27: Transactions.
Lab 28: Checkpoints.
Lab 29: Profiling the Source Data (lab report required).
Lab 30: Parallelism.
Note: You are highly encouraged to complete all of the labs. Lab reports are only required as indicated.
How to Submit Your Lab Reports
To successfully submit your lab results, follow these directions:
Complete the CBT Nuggets virtual labs assigned this week.
Take screenshots of your results as prescribed by this week's Lab Report guide.
Collect your screenshots for the required labs into a single document.
Don't forget to highlight the specific information.
Submit your document to this assignment.
Note: Failure to submit the result into the assignment submission area within the Strayer online courseroom will result in 0 points for the assignment.
Evidence of purposely skipped answers, incomplete answers, or limited effort is at the instructor's discretion, and may result in partial or incomplete
credit for the assignment.
Scoring Guide
Complete lab and submit with all required materials. 100 %
Unacceptable
Completed less than 60%
of the lab submission.
Needs Improvement
Completed 60–69% of the
lab submission.
Satisfactory
Completed 70–79% of the
lab submission.
Competent
Completed 80–89% of the
lab submission.
Exemplary
Completed 90–100% of the
lab submission.
w06a1 - CBT Nuggets Virtual Labs 32 and 33
Summary
Click the linked activity title to access this assignment.
Text
For help with your lab reports, see this week's lab report guide. Each guide is tailored to a specific lab assignment, so please read this each week:
Week 6 Lab Report [PDF].
Labs
Click each link below and then Launch Virtual Lab on the CBT Nuggets page that appears to launch the following labs:
Lab 31: Basic Transformations.
Lab 32: Pivot (lab report required).
Lab 33: Aggregations (lab report required).
Lab 34: Fuzzy Data Transformations .
Lab 35: Slowly Changing Dimension (SCD) Data Flows.
Note: You are highly encouraged to complete all of the labs. Lab reports are only required as indicated.
How to Submit Your Lab Reports
To successfully submit your lab results, follow these directions:
Complete the CBT Nuggets virtual labs assigned this week.
Take screenshots of your results as prescribed by this week's Lab Report guide.
Collect your screenshots for the required labs into a single document.
Don't forget to highlight the specific information.
Submit your document to this assignment.
Note: Failure to submit the result into the assignment submission area within the Strayer online courseroom will result in 0 points for the assignment.
Evidence of purposely skipped answers, incomplete answers, or limited effort is at the instructor's discretion, and may result in partial or incomplete
credit for the assignment.
Scoring Guide
Complete lab and submit with all required materials. 100 %
Unacceptable
Completed less than 60%
of the lab submission.
Needs Improvement
Completed 60–69% of the
lab submission.
Satisfactory
Completed 70–79% of the
lab submission.
Competent
Completed 80–89% of the
lab submission.
Exemplary
Completed 90–100% of the
lab submission.
w07a1 - CBT Nuggets Virtual Labs 38 and 39
Summary
Click the linked activity title to access this assignment.
Text
For help with your lab reports, see this week's lab report guide. Each guide is tailored to a specific lab assignment, so please read this each week:
Week 7 Lab Report [PDF].
Labs
Click each link below and then Launch Virtual Lab on the CBT Nuggets page that appears to launch the following labs:
Lab 36: SSIS Merge and Lookups (lab report required).
Lab 37: Incremental Loading With T-SQL MERGE (lab report required).
Lab 38: Enabling Change Data Capture.
Lab 39: Implementing CDC.
Note: You are highly encouraged to complete all of the labs. Lab reports are only required as indicated.
How to Submit Your Lab Reports
To successfully submit your lab results, follow these directions:
Complete the CBT Nuggets virtual labs assigned this week.
Take screenshots of your results as prescribed by this week's Lab Report guide.
Collect your screenshots for the required labs into a single document.
Don't forget to highlight the specific information.
Submit your document to this assignment.
Note: Failure to submit the result into the assignment submission area within the Strayer online courseroom will result in 0 points for the assignment.
Evidence of purposely skipped answers, incomplete answers, or limited effort is at the instructor's discretion, and may result in partial or incomplete
credit for the assignment.
Scoring Guide
Complete lab and submit with all required materials. 100 %
Unacceptable
Completed less than 60%
of the lab submission.
Needs Improvement
Completed 60–69% of the
lab submission.
Satisfactory
Completed 70–79% of the
lab submission.
Competent
Completed 80–89% of the
lab submission.
Exemplary
Completed 90–100% of the
lab submission.
w08a1 - CBT Nuggets Virtual Labs 40 and 41
Summary
Click the linked activity title to access this assignment.
Text
For help with your lab reports, see this week's lab report guide. Each guide is tailored to a specific lab assignment, so please read this each week:
Week 8 Lab Report [PDF].
Labs
Click each link below and then Launch Virtual Lab on the CBT Nuggets page that appears to launch the following labs:
40: Debugging and Troubleshooting (lab report required).
41: Securing SSIS Packages (lab report required).
Note: You are highly encouraged to complete all of the labs. Lab reports are only required as indicated.
How to Submit Your Lab Reports
To successfully submit your lab results, follow these directions:
Complete the CBT Nuggets virtual labs assigned this week.
Take screenshots of your results as prescribed by this week's Lab Report guide.
Collect your screenshots for the required labs into a single document.
Don't forget to highlight the specific information.
Submit your document to this assignment.
Note: Failure to submit the result into the assignment submission area within the Strayer online courseroom will result in 0 points for the assignment.
Evidence of purposely skipped answers, incomplete answers, or limited effort is at the instructor's discretion, and may result in partial or incomplete
credit for the assignment.
Scoring Guide
Complete lab and submit with all required materials. 100 %
Unacceptable
Completed less than 60%
of the lab submission.
Needs Improvement
Completed 60–69% of the
lab submission.
Satisfactory
Completed 70–79% of the
lab submission.
Competent
Completed 80–89% of the
lab submission.
Exemplary
Completed 90–100% of the
lab submission.
w09a1 - CBT Nuggets Virtual Labs 45 and 47
Summary
Click the linked activity title to access this assignment.
Text
For help with your lab reports, see this week's lab report guide. Each guide is tailored to a specific lab assignment, so please read this each week:
Week 9 Lab Report [PDF].
Labs
Click each link below and then Launch Virtual Lab on the CBT Nuggets page that appears to launch the following labs:
Lab 43: Installing Data Quality Services (DQS).
Lab 44: Data Quality Knowledge Base (DQKB) Domains, and Attributes.
Lab 45: DQS Data Cleaning (lab report required).
Lab 46: DQS Data Flow Tasks in SSIS.
Lab 47: Handling Duplicates in DQS (lab report required).
Note: You are highly encouraged to complete all of the labs. Lab reports are only required as indicated.
How to Submit Your Lab Reports
To successfully submit your lab results, follow these directions:
Complete the CBT Nuggets virtual labs assigned this week.
Take screenshots of your results as prescribed by this week's Lab Report guide.
© 2020 Strategic Education, Inc.
Collect your screenshots for the required labs into a single document.
Don't forget to highlight the specific information.
Submit your document to this assignment.
Note: Failure to submit the result into the assignment submission area within the Strayer online courseroom will result in 0 points for the assignment.
Evidence of purposely skipped answers, incomplete answers, or limited effort is at the instructor's discretion, and may result in partial or incomplete
credit for the assignment.
Scoring Guide
Complete lab and submit with all required materials. 100 %
Unacceptable
Completed less than 60%
of the lab submission.
Needs Improvement
Completed 60–69% of the
lab submission.
Satisfactory
Completed 70–79% of the
lab submission.
Competent
Completed 80–89% of the
lab submission.
Exemplary
Completed 90–100% of the
lab submission.
w10a1 - CBT Nuggets Virtual Labs 50 and 51
Summary
Click the linked activity title to access this assignment.
Text
For help with your lab reports, see this week's lab report guide. Each guide is tailored to a specific lab assignment, so please read this each week:
Week 10 Lab Report [PDF].
Labs
Click each link below and then Launch Virtual Lab on the CBT Nuggets page that appears to launch the following labs:
Lab 48: Installing Master Data Services (MDS).
Lab 49: Managing Master Data.
Lab 50: System Administration, MDS Hierarchies and Business Rules (lab report required).
Lab 51: Importing and Exposing Data in MDS (lab report required).
Note: You are highly encouraged to complete all of the labs. Lab reports are only required as indicated.
How to Submit Your Lab Reports
To successfully submit your lab results, follow these directions:
Complete the CBT Nuggets virtual labs assigned this week.
Take screenshots of your results as prescribed by this week's Lab Report guide.
Collect your screenshots for the required labs into a single document.
Don't forget to highlight the specific information.
Submit your document to this assignment.
Note: Failure to submit the result into the assignment submission area within the Strayer online courseroom will result in 0 points for the assignment.
Evidence of purposely skipped answers, incomplete answers, or limited effort is at the instructor's discretion, and may result in partial or incomplete
credit for the assignment.
Scoring Guide
Complete lab and submit with all required materials. 100 %
Unacceptable
Completed less than 60%
of the lab submission.
Needs Improvement
Completed 60–69% of the
lab submission.
Satisfactory
Completed 70–79% of the
lab submission.
Competent
Completed 80–89% of the
lab submission.
Exemplary
Completed 90–100% of the
lab submission.
