Universitatea Babeş-Bolyai Cluj-Napoca
Facultatea de Matematică şi Informatică
Ciclul de studii: Licenţă
Domeniul: Calculatoare şi tehnologia informaţiei
Programul de studii: Ingineria informatiei - in limba engleza
Limba de predare: Engleză

SYLLABUS

I. General data
Code	Subject	
MII0022	Intelligent Decision Support Systems	

Semester	Hours: C+S+L+P	Category	Status	
8	2+0+1+1	speciality	optional	

II. Full status faculty members
Name and	Scientific	Didactic	Chair	Type of activity	
surname	title	title		C	S	L	
GOG Anca-Mirela	Ph.D.	Lect.	Computer Systems	*			

Associated faculty members
Name and	Scientific	Institution	Type of	Type of activity	
surname	title		position	C	S	L	

III. Course objectives
At the end of this course the student should be able to build a Business Intelligence application using SQL Server 2005 BI technologies. More specifically, the student should know what makes Business Intelligence systems different from transaction systems, how to integrate data into Data Warehouses, how to build and load information into an OLAP database, dimensional modeling concepts, querying OLAP cubes, data mining concepts and BI application development steps.	

IV. Course contents
1. Business Intelligence foundations
2. Online transaction processing (OLTP)
3. Data warehouses and data integration (managing very large data warehouses)
4. Online analytical processing (OLAP)
5. Dimensional modeling
6. MDX query language
7. Data mining
8-10. BI development steps (justification, planning, business analysis, design, construction, deployment)
11. Managing changing data
12. Real-time BI – case study	

V. Bibliography
John C. Hancock, Roger Toren, Practical Business Intelligence with SQL Server 2005, Addison Wesley Professional, 2006.

Larissa T. Moss, Shaku Atre, Business Intelligence Roadmap: The Complete Project Lifecycle for Decision-Support Applications, Addison Wesley Professional, 2003.

Ralph Kimball, Margy Ross, The Data Warehouse Toolkit. The Complete Guide to Dimensional Modeling, Wiley Computer Publishing, 2002.

Brian Larson, Delivering Business Intelligence with Microsoft SQL Server 2005, McGraw-Hill/Osborne, 2006.

Jay Liebowitz, Strategic Intelligence. Business Intelligence, Competitive Intelligence, and Knowledge Management, Auerbach Publications, 2006.

Lynn Langit, Foundations of SQL Server 2005 Business Intelligence, Apress, 2007.	

VI. Thematic of didactic activities per weeks
Course:
1. Business Intelligence foundations
2. Online transaction processing (OLTP)
3. Data warehouses and data integration (managing very large data warehouses)
4. Online analytical processing (OLAP)
5. Dimensional modeling
6. MDX query language
7. Data mining
8-10. BI development steps (justification, planning, business analysis, design, construction, deployment)
11. Managing changing data
12. Real-time BI – case study

Laboratory:
Microsoft SQL Server 2005 tools for business intelligence
1.	Introduction to SQL Server 2005
2.	Building a Data Warehouse
3.	Data integration process
4.	Building an online analytical processing database (OLAP)
5.	Reporting Services

Project:
An application that uses SQL Server 2005 Business Intelligence technologies to solve a real-world problem.	

VII. Didactic methods used
The main teaching methods used in the course are: exposition, discussions, individual study, home-works, quizzes, practical projects.	

VIII. Assessment
The final grade is a weighted mean between a technical report which accounts for 30% of the final grade and the lab projects average which accounts for 70% of the final grade.

Course requirements and details can be found on the course web-site:
http://www.cs.ubbcluj.ro/~anca/bi	

IX. Additional references

	Dean,							Chair head,

	Date,							Course responsible,
								Lect. GOG Anca-Mirela, Ph.D.