ISQS 6339 Lecture Notes

 

Instructor: Zhangxi Lin

 

------- + ------ + ------- + ------- + ------- + -------

 

Lecture 1 & 2, 03/21/2017, Tuesday

 

Topic: Introduction

1)       Basic BI Concepts

2)       BI trend

 

Review questions:

 

1)     What is BI?

2)     Why is BI getting hot?

 

Topic: Database vs. data warehousing

 

1)       Database vs. data warehousing

2)       Big data

 

Terminology: data, information, knowledge, business intelligence, big data, artificial intelligence, data ware housing

 

Reading:

1)     How Much Information? 2003” (http://www2.sims.berkeley.edu/research/projects/how-much-info-2003/execsum.htm)

2)     Find a BI application case from the web, and understand how it works.

3)     Find paper “CACM2011 Overview of BI.pdf” in the network drive under ~\Texts\Readings\. Read it carefully.

 

------- + ------ + ------- + ------- + ------- + -------

 

Lecture 3 & 4, 03/23/2017, Thursday

 

Topic: Anatomy of Business Intelligence

 

1)       DW concepts

2)       Data warehousing with Microsoft SQL Server 2008

 

Topic: Data warehousing

 

1)       Demonstration

2)       Concepts of data warehousing

3)       Architecture of data warehouse

4)       Data Integration

5)       Hadoop & Spark

6)       Exercise 0 – database review using IMW data

 

References:

1)     SQL Server Data Warehousing http://technet.microsoft.com/en-us/sqlserver/dd421879.aspx

2)     SQL Server Tutorial for Beginners http://www.youtube.com/watch?v=ZNObiptSMSI&list=PL08903FB7ACA1C2FB

 

------- + ------ + ------- + ------- + ------- + -------