[Advanced Database] Syllabus
[Fall 2018/2019]
Instructor |
Email |
Office Location & Hours |
[Mouhib.alnoukari@gmail.com] |
[Location, Hours, Days] |
The main goal of this course is to introduce the main concepts of Business Intelligence & Data Warehousing. The student will learn enough knowledge and practices on how to design and create a data warehouse, use Extract, Transform and Load (ETL) tools, understand and implement data mining algorithms, and finally understand and use the data visualization tools.
1- Introduction to Business Intelligence & Data Warehousing
2- Business Analytics
3- Data Warehousing & ETL
4- Data Mining Algorithms
5- Data Visualization
· Inmon W. H.: Building the Data Warehouse, Wiley &Sons.
· Silberschatz, Korth, & Sudarshan: Data Base System Concepts, 5th edition, McGraw-Hill.
· Kimball R., Ross M.: The Data Warehouse Toolkit. The Complete Guide to Dimensional Modeling, Wiley &Sons.
|
Week |
Topic |
Reading |
Exercises |
1 |
22/9- 26/9 |
Introduction to Business Intelligence & Data Warehousing |
Inmon – Ch. 1 |
SQL Server Analysis Services (SSAS) |
2 |
29/9- 03/10 |
Business Analytics |
Inmon – Ch. 1 |
SQL Server Analysis Services (SSAS) |
3 |
06/10- 10/10 |
Business Analytics |
Inmon – Ch. 1 |
SQL Server Analysis Services (SSAS) |
4 |
13/10- 17/10 |
Data Warehousing |
Inmon – Ch. 2 |
SQL Server DW |
5 |
20/10- 24/10 |
Data Warehousing |
Inmon – Ch. 2 |
SQL Server DW |
6 |
03/11- 07/11 |
Data Modeling |
Inmon – Ch. 3 |
SQL Server OLAP |
7 |
10/11- 14/11 |
Data Modeling |
Inmon – Ch. 3 |
SQL Server OLAP |
8 |
17/11- 21/11 |
ETL |
Inmon – Ch. 4 |
SQL Server Integration Services |
9 |
24/11- 28/11 |
Data, Text and Web Mining |
Silberschatz - Ch. 20 |
SQL Server Integration Services |
10 |
01/12- 05/12 |
Data Mining Algorithms |
Silberschatz - Ch. 20 |
SQL Server Data Mining |
11 |
15/12- 19/12 |
Data Mining Algorithms |
Silberschatz - Ch. 20 |
SQL Server Data Mining |
12 |
22/12- 26/12 |
Data Mining Algorithms |
Silberschatz - Ch. 20 |
SQL Server Data Mining |
13 |
22/12- 26/12 |
Data Mining Algorithms |
Silberschatz - Ch. 20 |
SQL Server Data Mining |
14 |
29/12- 02/01 |
Data Visualization |
Inmon – Ch. 10 |
Microsoft Power BI |
15 |
|
|
|
|
Test |
Date |
Subject |
Reading |
Type |
language |
% of final grade |
Quizz 1 |
27/10-1/11 |
Introduction to Business Intelligence & Data Warehousing, Business Analytics, Data Warehousing |
Inmon – Ch. 1, 2 |
MCQ/written |
Arabic/English |
10 |
Quizz 2 |
8/12-13/11 |
Data Modeling, ETL |
Inmon – Ch. 3, 4 |
MCQ/written |
Arabic/English |
10 |
Final Exam |
5/1-17/1 |
Data, Text and Web Mining, Data Mining Algorithms, Data Visualization |
Silberschatz - Ch. 20, Inmon – Ch. 20 |
MCQ/written |
Arabic/English |
50 |
|
|
|
|
|
|
|
Syrian Private University - Faculty of of Computer and Information Engineering @ 2024 by Syrian Monster - Web Service Provider | All Rights Reserved