|
|
Syllabus: ISQS 6339, Fall 2007 Data Management & Business Intelligence Home | Schedule | Sign-up/Update | Students
| Records | Lecture notes Group
Sign-up | View
Groups | Projects |
Schedule: TTh 12:30-13:50p, BA 363 (Computer Lab)
or BA 271 (Lectures)
Instructor:
Email: zhangxi.lin@ttu.edu, zhangxi.lin@gmail.com, MSN: zhangxi.lin@hotmail.com, Google talk
ID: zhangxi.lin
Course Description:
Data management comprises all the disciplines related to
managing data as a valuable resource. Business intelligence (BI) is referred to
as applications and technologies which are used to gather, provide access to,
and analyze data and information about their company operations. Business
intelligence systems can help companies have a more comprehensive knowledge of
the factors affecting their business, such as metrics on sales, production,
internal operations, and they can help companies to make better business
decisions. This course is to be based on the contents covered by database
management to further train students the skills methodologies, and knowledge
how to accomplish data management tasks with the applications of BI tools and
techniques. The main components of this course include:
- Principles of data warehousing
- Dimensional data model
- Information integration and flow design in the ETL
(extraction, transformation, and loading) process
- Online analytical processing (OLAP)
- Data reporting and query techniques
- Data preparation for analytics
The course is lectured with cases and tools use.
Learning objectives:
- Understanding
the general principles of business intelligence
- Being
able to construct a data warehouse
- Developing
the skills for ETL
- Mastering
general data preparation skills and tools for analytic tasks
Prerequisites: Any database courses
Software tools to be
used: Microsoft SQL Server 2005,
Base SAS, SAS Enterprise Guide V4.1
Textbook:
Required: The Microsoft
Data Warehouse Toolkit, Joy Mundy and Warren Thornthwaite,
Wiley, 2006, ISBN 0-471-26715-5
Optional:
·
Business Intelligence: The Savvy Manager's Guide; Morgan Kaufmann (June 2003); ISBN:
155860916
·
Data Preparation for Analytics Using SAS, Gerhard Svolba, SAS Press Series, ISBN 978-1-59994-047-2
·
Business Intelligence – A Managerial Approach, Efraim
Turban, Ramesh Sharda, Jay
E. Aronson, David King, Pearson Prentice Hall, 2008, ISBN 13: 978-0-13-234761-7
Deliverable and
Grading Policy:
- Five
quizzes out of six (100 points)
- In-class
exercises (80 points)
- Homework
(20 points)
- Two
projects (120 points)
- Open-book
final Exam (100 points)
The total is 420 points.
Extra bonus credit: up to 30 points based on the evaluation
of the involvement in the class activities.
Projects:
Projects will be conducted in the basis of group. Each
project group consists of 2-3 students.
References:
- Textbook
website: http://www.msftdwtoolkit.com/
or http://www.msftdwtoolkit.com/ToolsandUtilities/ToolandUtilities.htm
- Querying and Reporting Using
SAS®
- Online
SAS references
- Selected
online resources:
1.
StatLib: http://lib.stat.cmu.edu/
2.
MLnet: http://www.mlnet.org/
3. KDNuggets: http://www.kdnuggets.com/
4. Weka: http://www.cs.waikato.ac.nz/ml/weka/
5. Open source data mining projects: http://www.kdkeys.net/forums/72/ShowForum.aspx
6. Open source data mining tools: http://dmoz.org/Computers/Software/Databases/Data_Mining/Public_Domain_Software/
·
Microsoft
SQL Server 2005 Express (SSE) Edition: Review,
Download,
Comparison
·
Microsoft
SQL Server Management Studio Express (SSMSE): Download
·
Download
samples and sample databases from the Microsoft
Download Center
·
Beginning SQL Server 2005 Express
for Developers: From Novice to Professional, Robin Dewson, 464 pages, Apress (
·
Microsoft
BI Cases, SAS Cases
·
Oracle
Database 10g Express Edition
·
BI
Application Case: Playing
by the Numbers: Baseball and BI, By Mel Duvall,
Oct 29, 2007,
-
Job Market Trend:
Data warehousing and business intelligence are hot
topics in the job market. A
search of “business intelligence” in monster.com showed 5000+ listings (http://jobsearch.monster.com).