KUMASI TECHNICAL UNIVERSITY
COURSE OUTLINE
Faculty: APPLIED SCIENCE AND TECHNOLOGIES
Department: COMPUTER SCIENCE
Programme: BACHELOR OF TECHNOLOGY
Academic Year: ………..2024/2025 Semester: ONE
Module Title………………………………………..………….… Credit Load: 3
Course Title: …..DATA WAREHOUSING Course Code …..BCT 351
Lecturer(s) Email(s) Telephone №
a: Emmanuel Oppong Afriyie
[email protected] 0553599059
b
c.
Course Description: Course Overview, Data Warehousing Fundamentals Data Warehouse
Requirements, Data preprocessing, Modelling the Data Warehouse, what is data mining? Data Mining
Techniques, Cluster analysis, Distributed & Multimedia Data Bases
Mode of Delivery / Course Teaching and Learning Activities
a. Face to Face
b. Online thru V-Class /Telegram
c. Presentations
Course Objectives a. to explain the concepts of data warehousing and data mining,
b. Study the dimensional modelling technique for designing a data warehouse,
c. Study data warehouse architectures,
d. OLAP and the project planning aspects of building a data warehouse,
Competencies to a.
Acquire b.
COURSE CONTENT (List Major Topics, Teaching Areas, Workshop Activities, Laboratory Practical and
Field Trips of the Course to cover the entire Semester)
Week Topics Practical/Skills/Knowledge to Acquire
1. Introduction to Data Warehousing Overview of Data Warehousing
Importance and Applications
Key Concepts and Terminology
2. Data Warehouse Architecture Data Warehouse Architecture
Components
Data Storage and Management
Data Integration
3. Data Warehouse Design Data Modeling Techniques
Star Schema and Snowflake Schema
Fact and Dimension Tables
4. Extract-Transform-Load (ETL) Processes ETL Concepts and Processes
ETL Tools and Technologies
Data Cleaning and Transformation
5. Data Cubes and OLAP Introduction to Data Cubes
OLAP Operations (Roll-up, Drill-
down, Slice, Dice)
OLAP Tools
6. Data Marts Concept of Data Marts
Types of Data Marts
Designing Data Marts
7. Business Intelligence Systems Introduction to Business Intelligence
(BI)
BI Tools and Technologies
BI Applications
8. Data Warehouse Implementation Steps in Data Warehouse
Implementation
Challenges and Best Practices
Case Studies
9. Advanced ETL Techniques Incremental ETL
Real-time ETL
ETL Performance Optimization
10. Data Quality and Governance Data Quality Management
Data Governance Frameworks
Data Security and Privacy
11. Big Data and Data Warehousing Big Data Concepts
Integration of Big Data with Data
Warehouses
Tools and Technologies for Big Data
Warehousing
12.
Assessment Type Description Date and Weight
COURSE LEARNING OUTCOMES
a.
b.
ESSENTIAL READINGS: (Textbooks, Journals, textbooks, website addresses etc.)
• Hoffer, J. A., Ramesh, V., & Topi, H. (2020). Modern Database Management. Pearson
Education Limited.
• The Data Warehouse Toolkit by Ralph Kimball - John Wiley & Sons Publications.
• Decision Support in the Data Warehouse by Paul Gray, Hugh J. Watson - Prentice Hall.
• Hoffer, J. A., Ramesh, V., & Topi, H. (2020). Modern Database Management. Pearson
Education Limited.
[1] Data Warehouse Concepts and Principles | Toptal®
[2] What is a Data Warehouse? | IBM
[3] The Ultimate Guide to Data Warehouse Design - Integrate.io
[4] What is ETL? - Extract Transform Load Explained - AWS
[5] What Is a Data Cube? - 365 Data Science
[6] What is a Data Mart? - Data Mart Explained - AWS
[7] What is business intelligence (BI)? - IBM
[8] What is ETL (extract, transform, load)? - IBM
[9] What Is Data Warehousing? Concepts, Best Practices, and Tools
