DSS/BI/Data
Warehousing
BCIS
5610/5900
Spring
2008
Instructor: Dr. Jack D. Becker
Office: 338E
Telephone: Office: (940) 565-3113/3110
Fax: Office:
(940) 565-4935
E-mail: Use WebCT
VISTA: http://webctvista.unt.edu for all e-mail;
becker@unt.edu (emergency)
Tue/Thur:
http://www.teradata.com/t/page/144826/index.html
This course provides an overview of
the different components to Business Intelligence. The course is designed to
provide a thorough understanding of the business potential of data warehousing,
data mining, forecasting, BPM, Predictive Analytics, Analytics, Dashboards
& Scorecards, ETL, & CRM. These objectives are met through a combination
of class lectures, readings, case studies, and outside speakers.
|
20% |
100
points |
|
|
Midterm
Exam |
25% |
125 points |
|
Final
Examination |
25% |
125 points |
|
Individual
Project |
10% |
50 points |
|
Team
Project: Term Paper |
20% |
100 points |
|
Totals |
100% |
500 points |
Individual Project:
Students
will need to logon to Teradata Student Network (TSN/TUN )and questions using the SQL statements provided.
Students will be given access to the SAMS DB with a Logon/ Password.
Team Project:
Work in
teams of 4 to 5. Each team will be assigned a topic or may chose a topic
related to the data warehousing and business intelligence trend. The project
requires a completion of a 12-15 page Term Paper and a 30-minute presentation
of the topic. All Articles, References and Additional materials must be turned
in with the Term Paper in a 3-ring Binder.
The exams
will be closed-book. Early or late final
exams will not be given. Make-up exams will not be given. Final examination will be comprehensive of
all subject matter.
Problems,
cases, and readings will be assigned to support and supplement course subject
matter. Each assignment which you turn
in must have a separate cover sheet when submitted. This cover page must contain the following
information which is typed and centered on the page - your name (Last Name First), the assignment
number, the due date for the assignment, the topic of the assignment, Text
Title (if any), Chapter (if any) and page number (if any), place a computer
generated date stamp on all computer output. Late or early assignments will not
be accepted. All assignments are due at the beginning of class on the date
due.
All
assignments must reflect your original work.
Team assignments will include a team member evaluation sheet, which each
team member must complete.
Students
will turn in a 1 page summary report each week based on the assigned reading.
Students must be prepared to discuss the reading in class the day it is due.
Article Reading Assignments (available on Teradata Student Network):
|
Week |
Due Date |
Topics |
Article Reading |
|
1 |
|
BI |
Williams,
Steve. “Accessing BI Readiness: A key to BI ROI.” |
|
2 |
|
Analytics |
|
|
3 |
|
Predictive
Analytics |
Krantik Das and G. S. Vidyashankar.
“Competitive Advantage in Retail Through Analytics: Developing Insights,
Creating Value.” |
|
4 |
|
Data Mining |
Zaima, Arlene and Kashner,
James. “A data mining Primer for the Data Warehouse Professional.” |
|
5 |
|
Data
Warehouses |
Gartner
Research. “Key Issues for Data Warehousing, 2007.” |
|
6 |
|
CRM |
Baseline
Insight. “What is CRM?” |
|
7 |
|
BPM |
Gregory,
Marianne A. “Keys to Successful Performance Management: Getting Past the
Excitement of Technology to Achieve Results.” |
|
8 |
|
Dash Board
& Scorecards |
Eckerson, Wayne. “The New Face of Business
Intelligence: Dashboards and Scorecards.” |
|
9 |
|
Forecasting |
Gartner
Research. “Selecting Analytics Technologies for Sales Organizations.” |
|
10 |
|
ETL |
Gartner
Research. “Who Who in Extraction, Transformation & Loading.” |