Business Intelligence Course

Home

In today’s highly competitive and increasingly uncertain world, the quality and timeliness of an organization’s “Business Intelligence (BI)” can mean not only the difference between profit and loss but even the difference between survival and bankruptcy. The term BI is relatively new but it is synonymous with a range of applications that have been around for years: On-Line Transaction Processing, Data Warehousing, Data Mining, Intelligent Decision Support System, Intelligent Agent, Knowledge Management System, Supply Chain Management, Customer Relationship Management, Enterprise Resource Planning, Enterprise Information Management and so on. BI is the conversion of data into information in such a way that the business is able to analyze the information to gain insight and take action. in other words BI exquisites data and information for use in decision-making activities. The course provides an introduction to above tools, techniques and applications. The course also studies related concepts such as data cleaning, data cleansing and so on.

Prerequisites

Students are expected to have good knowledge of Databases, Artificial Intelligence and software engineering concepts

Instructor

Prof. Ahmad Abdollahzadeh Barforoush

Teaching Assistant

Meisam Nazariani

Course Topics

No	Topics
1	Introduction to Business Intelligence (معرفی هوش تجاری)
2	Business Intelligence Architecture (معماری هوش تجاری)
3	Introduction to Data Warehouse (معرفی پایگاه داده تحلیلی)
4	Data Warehouse Lifecycle (چرخه حیات پایگاه داده تحلیلی)
5	Requirements Engineering in Information Systems (مهندسی نیازمندی ها در سیستم های اطلاعاتی)
6	Data Warehouse Architecture (معماری پایگاه داده تحلیلی)
7	Introduction to Multi-Dimensional Data Model (معرفی مدل داده چند بعدی)
8	Extract-Transform-Load in Data Warehouse (استخراج-تبدیل-بارگذاری در پایگاه داده تحلیلی)
9	ETL Tools, Applications and Techniques (ابزارها، کاربردها و تکنیک های ETL)
10	Principles and Concepts of Data Quality (اصول و مفاهیم کیفیت داده)
11	Introduction to Information Dashboards (معرفی داشبورد های اطلاعاتی)
12	Principles of Information Dashboards Design and Implementation (اصول تحلیل و طراحی داشبورد های اطلاعاتی)
13	Information Representation Tools, Applications and Techniques (ابزارها، کاربردها و تکنیک های نمایش اطلاعات)
14	Introduction to Decision Support Systems (معرفی سیستم های تصمیم یار)
15	Introduction to Data Mining (معرفی داده کاوی)
16	Data Mining Tools, Applications and Techniques (ابزارها، کاربردها و تکنیک های داده کاوی)
17	Knowledge Management (مدیریت دانش)
18	Business Intelligence Project Lifecycle (چرخه حیات پروژه های هوش تجاری)
19	Phase 1: Justification (مرحله اول: بررسی اولیه)
20	Phase 2: Planning (مرحله دوم: طرح ریزی)
21	Phase 3: Business Analysis (مرحله سوم: تحلیل کسب و کار)
22	Phase 4: Design (مرحله چهارم: طراحی)
23	Phase 5: Construction (مرحله پنجم: ساخت)
24	Phase 6: Deployment (مرحله ششم: نصب و استقرار)

By the end of this course, you will know:

what ideas, what new trends and what new possibilities are offered by BI and related tools, techniques, applications and concepts.

Evaluation Criteria

Criteria	Total Mark	Comments
Homework	20%
Project	35%
Midterm	20%
Final Exam	25%

References

Text Books:

Larissa T. Moss, Shaku Atre, “Business Intelligence Roadmap: The Complete Project Lifecycle for Decision Support Applications” , Addison Wesley, 2003.
Efraim Turban, Ramesh Sharda, Dursun Delen, David King, “Business Intelligence: A Managerial Approach” , 2nd Edition, Prentice Hall, 2010.
Abraham Silberschatz, Henry F. Korth, S. Sudarshan, “Database System Concepts”, 6th Edition, McGrow Hill, 2011.
Stephen Few, “Information Dashboard Design” , 1st Edition, O’Reilly, 2006.
Ralph Kimball, Margy Ross, Warren Thornthwaite, Joy Munday, Bob Becker, “The Data Warehouse Lifecycle Toolkit” , 2nd Edition, Wiley, 2008.