Description
Australian School Of Business Information Systems, Technology And Management Business Intelligence (BI)
INFS 5991 – Business Intelligence
1
INFS 5991
BUSINESS INTELLIGENCE (BI)
Course Outline
Semester 1, 2012
Australian School of Business
Information Systems, Technology and
Management
INFS 5991 – Business Intelligence
2
Table of Contents
PART A: COURSE-SPECIFIC INFORMATION 4
1 STAFF CONTACT DETAILS 4
2 COURSE DETAILS 4
2.1 Teaching Times and Locations 4
2.2 Units of Credit 4
2.3 Summary of Course 4
2.4 Course Aims and Relationship to Other Courses 4
2.5 Student Learning Outcomes 5
3 LEARNING AND TEACHING ACTIVITIES 5
3.1 Approach to Learning and Teaching in the Course 6
3.2 Learning Activities and Teaching Strategies 6
4 ASSESSMENT 7
4.1 Formal Requirements 7
? ATTAIN A COMPOSITE MARK OF AT LEAST 50%, 7
? ATTEND AT LEAST TEN SCHEDULED TUTORIAL CLASSES, 7
? MAKE A SATISFACTORY ATTEMPT AT ALL ASSESSMENT TASKS (SEE 4.2 BELOW). A MARK
OF 45 PERCENT OR HIGHER IS NORMALLY REGARDED AS SATISFACTORY, 7
? ATTAIN A MARK OF AT LEAST 45% IN THE FINAL EXAM, AND 7
? IN THE CASE OF PEER ASSESSED GROUP WORK, THE MARK ASSIGNED TO EACH MEMBER
OF THE GROUP MAY BE SCALED BASED ON PEER ASSESSMENT OF EACH MEMBER'S
CONTRIBUTION TO THE TASK. 7
4.2 Assessment Details 7
5 COURSE RESOURCES 8
6 COURSE EVALUATION AND DEVELOPMENT 9
7 COURSE SCHEDULE 10
PART B: KEY POLICIES, STUDENT RESPONSIBILITIES AND SUPPORT 11
1 ACADEMIC HONESTY AND PLAGIARISM 11
2 STUDENT RESPONSIBILITIES AND CONDUCT 11
2.1 Workload 11
2.2 Attendance 11
2.3 General Conduct and Behaviour 12
2.4 Occupational Health and Safety 12
2.5 Keeping Informed 12
3 SPECIAL CONSIDERATION AND SUPPLEMENTARY EXAMINATIONS 12
4 STUDENT RESOURCES AND SUPPORT 12
INFS 5991 – Business Intelligence
3
INFS 5991 – Business Intelligence
4
PART A: COURSE-SPECIFIC INFORMATION
1 STAFF CONTACT DETAILS
Position Name Email Room Phone
Lecturer-in-
charge
Dr. Farhad
Daneshgar
[email protected] QUAD, 2106 9385-
4241
Tutor Mr. Damrongsak
Naparat (Neo)
[email protected] TBA NA
The best way to contact your lecturer or tutor is via email or during their consultation times.
Please note that only your UNSW email account will be used for formal notices and
correspondence regarding the course.
Consultation Times:
Monday 13:00 – 14:00
Tuesday: 11:00 – 12:00
2 COURSE DETAILS
2.1 Teaching Times and Locations
Lectures start in Week 1 (to Week 12). The Time and Location are:
Tuesday 18:00am-20:00, ASB 114
Tutorials start in Week 2 (to Week 13). The Time and Locations are:
Tutorial: Tuesday 20:00-21:00 EE218
2.2 Units of Credit
The course is worth 6 units of credit.
There is no parallel teaching in this course.
2.3 Summary of Course
This course examines the process of decision making and work group activity by professional
and managerial people; the tools and techniques available in information technology to support
these processes and when they can be advantageously used; some of the reasons why so
many executive support systems do not achieve their intended objectives; and the cultural and
organisational issues involved in the use of Information Technology tools and techniques. The
course has a technical component in which students gain practical knowledge and experience in
decision support and business intelligence systems using BI software (e.g., EXCEL,
PlannersLab, Pentaho and J Report software systems).
2.4 Course Aims and Relationship to Other Courses
? To introduce students to the concepts, processes and practice of decision making at both
individual and group levels in relation to the appropriate utilisation of the ICT in today’s
organisations;
? To provide an understanding of the senior management perspective regarding the use of
business intelligence (BI) systems, and
INFS 5991 – Business Intelligence
5
? To encourage students to consider the strategic use of BI technology for strategic
advantage, and to provide practical understanding of the BI concepts and technologies in
business organisations.
Achieving the above aims is expected to produce the following student learning outcomes.
These learning outcomes in turn, are expected to enhance students’ graduate attributes by
transforming students into knowledgeable human resources.
2.5 Student Learning Outcomes
In this course, learning is about application, insight, understanding, research, professionalism,
and personal development. Learning in this course is NOT about simply acquiring knowledge,
nor memorising and long-term retention. More specifically, by the end of the course, you should
be able to:
1. Apply theoretical concepts of the course materials (e.g., textbook, journal articles, etc) to the
decision-making and BI processes and technologies in order to prepare students for making
appropriate managerial decisions in future real-life situations. Through applying the
practices of the project management students will be able to understand how “text book
theory” works “in today’s business practices”. Ultimately, it will be up to student to relate the
theory and associated readings to the practical business applications.
2. Undertake systematic investigation/research related to the decision support and BI systems
and technologies for today’s dynamic business environment.
3. Develop professional attitudes in students in relation to the team work, interpersonal
communication, and business ethics.
ASB Graduate Attributes
This course contributes to your development of the following Australian School of Business
Graduate Attributes, which are the qualities, skills and understandings we want you to have by
the completion of your degree:
Student
Learning
Outcomes
ASB Graduate Attributes
1, 2 1. Critical thinking and problem solving
3 2. Communication
3 3. Teamwork and leadership
3 4. Social, ethical and global perspectives
1, 2 5. In-depth engagement with relevant disciplinary knowledge
1, 3 6. Professional skills
It is important for students to understand the relationship that exists between the course aims,
student learning outcomes (and supportive learning activities and assessment components as
explained below), and the graduate attributes, to the overall requirements of students’ degree
course, and students’ future study/professional goals. It is intended that all these issues are
addressed in this document by adopting an integrated and inclusive approach to satisfying
students’ learning needs. The lecturer will be more than happy to further discuss these issues
with students and to provide assistance in understanding the above matters.
To see how the ASB Graduate Attributes relate to the UNSW Graduate Attributes, refer to the
ASB website (Learning and Teaching >Graduate Attributes).
3 LEARNING AND TEACHING ACTIVITIES
INFS 5991 – Business Intelligence
6
3.1 Approach to Learning and Teaching in the Course
The formal learning component of this course involves active and collaborative participation in,
and contribution to, all forms of classroom, team, and virtual learning activities including
lectures, discussion forums, workshops, individual learning activities, and group projects. The
formal component comprises a three-hour weekly block consisting of a 2-hour lecture and a
one-hour tutorial session. An academic staff member called the Tutor will work with one group
of 15-20 students throughout the semester, and will conduct weekly workshops. Each student is
required to attend one (1) lecture AND one (1) tutorial/workshop per week. In addition, students
are expected to complete both individual self-directed, as well as group learning activities each
week, and to carry out reading and research for assignments and workshop preparation, all in
direct relation to the course objectives and associated learning outcomes and ASB Graduate
Attributes as discussed later. All the topics covered in lectures and tutorials, as well as
individual/group-directed learning activities are assessable.
Lectures (2 hours per week): These are typically comprised of material that address assignment
and quiz content. Lectures will provide an overview of major topics and current issues within the
field of BI technologies and decision support systems.
Tutorials (1 hour per week): Tutorials are allocated for providing hands on experience to
students in applying BI technologies in professional contexts. The tutorial; activities are normally
related to the materials that are covered in the lectures but also introduces students to
additional technological practices that are expected from today’s typical business managers.
The Tutor will work closely with students and assist them in their tutorial learning activities.
Final Note: Students are expected to read the relevant text chapters and associated readings
BEFORE the lecture and workshops. Students are also required to attend the workshop in
which they are enrolled. In the case more than one tutorial class is available you will only
receive credit for your participation in the tutorial class that you are enrolled in. Please note that
you are required to attend at least 10 of the twelve workshops otherwise you will automatically
fail the course.
3.2 Learning Activities and Teaching Strategies
One strategy for achieving the above learning outcomes is to adopt a learning-centric approach
where both lecturer and students are engaged in an active, challenging, collaborative,
democratic, critically reflective, and transforming educational encounters. In the process, deep
learning is encouraged for concepts that relate to solving real-life decision environments. As a
result, a great portion of lectures, major assessments and tutorial tasks will be spent on case
studies and application of the theories to the real-life situations. However, low cognitive level
activities and surface learning, such as working with certain computer programs, will
supplement the above cognitive process during the tutorial classes.
Assignments are expected to develop a sense of teamwork and collaborative achievement of
project aims (see section 4.2 for more details). Appropriate collaborative ubiquitous virtual
environments such as the course discussion forums at both classroom and project levels are
provided for the general discussions and project-specific discussions. As a result of the adoption
of a collaborative learning strategy for this course, the teaching staff will be able to further guide
student activities towards the achievements of the assessment learning objectives ubiquitously.
During consultation times a similar assistance will be provided in order to support those group
activities that are performed in physical environments.
Note: the above collaborative learning-centric strategy will produce best results if students
actively participate in all teaching and learning activities that are specifically designed for the
achievement of specific learning outcomes.
INFS 5991 – Business Intelligence
7
4 ASSESSMENT
4.1 Formal Requirements
In order to pass this course, you must:
? attain a composite mark of at least 50%,
? attend at least ten scheduled tutorial classes,
? make a satisfactory attempt at all assessment tasks (see 4.2 below). A mark of 45
percent or higher is normally regarded as satisfactory,
? attain a mark of at least 45% in the final exam, and
? in the case of peer assessed group work, the mark assigned to each member of the
group may be scaled based on peer assessment of each member's contribution to the
task.
The School reserves the right to scale final marks to a mean of 60%.
It should be noted that group members are expected to work in a harmonious and professional
fashion which includes adequate management of non-performing members.
4.2 Assessment Details
Assessment
Task
Weight Learning
Outcomes
addressed
ASB
Graduate
Attributes
assessed
Due date Method of assessment
Tutorials/
Workshops
15% 1, 2 1, 2
Conducted in
tutorial classes
starting at wk2
Tasks and Participation: up to 15%
Lecture
(Group)
Assignment 1
15% 1, 2, 3 1, 3, 6
Week 6 –
delivered in
the lecture
Case Study analysis: applying learnt
materials to the case
Lecture
(Group)
Assignment 2
15% 1, 2, 3 1, 3, 5, 6
Week 11 –
delivered in
the lecture
A Case Study that also requires
systematic review of the literature.
Final Exam 55% 1, 2 1, 5 TBA One essay and one long case study
(both selected from the textbook) total
of 25/55 marks. Two short questions
and two small case studies (half from
the textbook) total of 20/55 marks (5
marks each). Five multiple-choice
questions (may also include
Diagrams/models from the textbook)
total of 10/55 marks
Details of each assessment task:
Workshop tasks and the lecture notes will be available progressively on the course website.
There is an assessment component in this course for “participation” in the tutorial classes. You
are expected to actively participate in the workshops and perform assessed tasks (15%). The
tutorial/workshop tasks involve modelling activities to produce managerial reports using BI
system. Some of the weekly tutorial tasks will have to be performed at home and will be
assessed at the end of tutorials. Failure to comply with these requirements will result in failure
of that component of the course as mentioned before. Both the hard and soft copies of the
tutorial homework must be brought to the workshop session for collection and marking. Please
INFS 5991 – Business Intelligence
8
do not show the electronic version of the workshop task to the tutor as a substitute for the paper
copy as that will not be acceptable and you will receive a mark of zero.
The two group assignments are designed to develop required skills to practice team-work, as
well as locating, evaluating and using relevant information to analyse a BI problem (see the
above table for relevant learning outcomes and graduate attributes). Paper copies of
assignments are to be handed in the lecture room by the due date. For additional safety, each
group must post an electronic version of their assignment on the group’s private discussion
forum prior to attending that lecture. The electronic version of the assignment will not be
marked and is used for detecting plagiarism and violations of copyright issues. Assignments
must be presented in professional format with appropriate referencing and full respect to the
copyrights of the cited references. All the references will be checked for integrity and
correctness. Assignment 1 will carry 20% mark for professional presentation (style, ethical
practices, and correctness), 30% for group work (professional behaviour, team-work and
‘lessons learnt’), and 50% for analysis and academic rigour. Assignment 2 will carry 10% mark
for professional presentation, 20% for group work, and 70% for analysis, academic rigour, and
the quality of the referencing and literature review.
Note: UNSW Assessment Policy requires that students receive clear assessment instructions
and criteria at the beginning of the course. However, if assessment information is very long
(e.g. case scenarios, data sets, detailed instructions or style guides) or cannot be finalised
before the commencement of the course (e.g. because the details will be negotiated with the
cohort or will reflect changing external conditions), basic information addressing the bullet
points should be included in this section and students should be given clear instructions here as
to what additional information is available elsewhere (and why) and when and where it will be
provided, with relevant links included e.g. to Blackboard.
5 COURSE RESOURCES
The website for this course is on UNSW Blackboard at:
https://lms-blackboard.telt.unsw.edu.au/webapps/portal/frameset.jsp
Prescribed textbook: (students are strongly advised not to purchase the older versions of the
book as they exclude recent ICT topics and case studies that we frequently discuss in the
course)
Decision Support and Business Intelligence Systems: International Edition, 9
th
edition ( the
latest version as of November 2011) by: Efraim Turban, Ramesh Shadra, and Dursun Delen;
Pearson Publishing, 2011.
Additional reference:
Electronic J ournals will be used in this course; links to relevant online journals will be provided
in the course website.
Additional materials uploaded in the Blackboard:
Case Studies, weekly workshop exercises, links to relevant library resources available to the
UNSW students, announcements, discussion forums, and more …...
Quality Assurance
The ASB is actively monitoring student learning and quality of the student experience in all
its programs. A random selection of completed assessment tasks may be used for quality
assurance, such as to determine the extent to which program learning goals are being
achieved. The information is required for accreditation purposes, and aggregated findings
will be used to inform changes aimed at improving the quality of ASB programs. All material
used for such processes will be treated as confidential and will not be related to course
grades.
INFS 5991 – Business Intelligence
9
For the Library information/subject guides visit the following web site:
http://info.library.unsw.edu.au/web/services/services.html
6 COURSE EVALUATION AND DEVELOPMENT
Each year feedback is sought from students about the courses offered in the School and
continual improvements are made based on this feedback. UNSW's Course and Teaching
Evaluation and Improvement (CATEI) Process is one of the ways in which student evaluative
feedback is gathered. In this course, we will seek your feedback through end of semester
CATEI evaluations. As a result of similar feedback last year few improvements were made to
this year’s offering.
INFS 5991 – Business Intelligence
10
7 COURSE SCHEDULE
Lectures start in Week 1 and finish in Week 12.
Week
starting:
Lecture Topic Tutorial Topic References Other Activities/
Assessment
Week 1
27 Feb
Modelling and Analysis Ch. 1 & 4 +
journal
article
All article will be
posted both in
hardcopies as well
as posted on the
Blackboard
Week 2
5 March
Decision Support
Systems (DSS) and
Business Intelligence
(BI)
Introduction to BI
workshop, its logistics,
and working with Oracle’s
Virtual Box
Ch.1 & 4
Week 3
12 March
Decision Making
Process
Basic decision making
modelling with Planners
Labs.
Ch. 2
Week 4
19 March
DSS Concepts, Methods
& Technologies
What-if, goal seek, and
sensitivity analysis with
Planners Labs.
Ch.3 +
journal
article
Week 5
26 March
BI: Data Mining (Part 1) Decision making with
statistical model and
business process
optimisation.
Ch. 5
Week 6
2 April
BI: Data Mining (Part 2) Power Pivot: Integrating
data for business analysis
and data filtering.
Ch. 5 Lecture Assignment
1 Due today (see
note below)
9 April
week
Mid-session Break; no classes this week
Week 7
16 April
BI: Artificial Neural
Network (ANN) and DM
Data integration & Data
cleansing (part 1).
Ch. 6 +
journal
article
Week 8
23 April
BI: Text & Web Mining Data integration & Data
cleansing (part 2).
Ch. 7
Week 9
30 April
BI: Data Warehousing Data mining techniques
for business purposes
(part 1: Knowledge
discovery)
Ch. 8
Week 10
7 May
Collaborative Computer-
Supported Technologies
Data mining techniques
for business purposes
(part 2: Forecasting)
Ch. 10
Week 11
14 May
Knowledge
Management and BI
Building interactive
reports.
Ch. 11 +
journal
article
Lecture Assignment
2 Due today
Week 12
21 May
Expert Systems &
Advanced Intelligent
Systems
Building dashboards. Parts of Ch.
12 & Ch. 13
Week 13
28 May
No Lectures Expert systems
demonstration (web-
based).
Note: details about Tutorial assignments and/or exercises will be available on week 2
INFS 5991 – Business Intelligence
11
PART B: KEY POLICIES, STUDENT RESPONSIBILITIES AND
SUPPORT
1 ACADEMIC HONESTY AND PLAGIARISM
The University regards plagiarism as a form of academic misconduct, and has very strict rules
regarding plagiarism. For UNSW policies, penalties, and information to help you avoid
plagiarism see: http://www.lc.unsw.edu.au/plagiarism/index.html as well as the guidelines in the
online ELISE and ELISE Plus tutorials for all new UNSW students:
http://info.library.unsw.edu.au/skills/tutorials/InfoSkills/index.htm.
To see if you understand plagiarism, do this short quiz:
http://www.lc.unsw.edu.au/plagiarism/plagquiz.html.
For information on how to acknowledge your sources and reference correctly, see:
http://www.lc.unsw.edu.au/onlib/ref.html.
For the ASB Harvard Referencing Guide, see ASB Referencing and Plagiarism webpage (ASB
>Learning and Teaching>Student services>Referencing and plagiarism).
2 STUDENT RESPONSIBILITIES AND CONDUCT
Students are expected to be familiar with and adhere to university policies in relation to class
attendance and general conduct and behaviour, including maintaining a safe, respectful
environment; and to understand their obligations in relation to workload, assessment and
keeping informed.
Information and policies on these topics can be found in the ‘A-Z Student Guide’:
https://my.unsw.edu.au/student/atoz/A.html. See, especially, information on ‘Attendance and
Absence’, ‘Academic Misconduct’, ‘Assessment Information’, ‘Examinations’, ‘Student
Responsibilities’, ‘Workload’ and policies such as ‘Occupational Health and Safety’.
.
2.1 Workload
It is expected that you will spend at least ten hours per week studying this course. This time
should be made up of reading, research, working on exercises and problems, and attending
classes. In periods where you need to complete assignments or prepare for examinations, the
workload may be greater.
Over-commitment has been a cause of failure for many students. You should take the required
workload into account when planning how to balance study with employment and other
activities.
2.2 Attendance
Your regular and punctual attendance at lectures and seminars is expected in this course.
University regulations indicate that if students attend less than 80% of scheduled classes they
may be refused final assessment.
INFS 5991 – Business Intelligence 12
2.3 General Conduct and Behaviour
You are expected to conduct yourself with consideration and respect for the needs of your
fellow students and teaching staff. Conduct which unduly disrupts or interferes with a class,
such as ringing or talking on mobile phones, is not acceptable and students may be asked to
leave the class. More information on student conduct is available at:
https://my.unsw.edu.au/student/atoz/BehaviourOfStudents.html.
2.4 Occupational Health and Safety
UNSW Policy requires each person to work safely and responsibly, in order to avoid personal
injury and to protect the safety of others. For more information, see
http://www.ohs.unsw.edu.au/.
2.5 Keeping Informed
You should take note of all announcements made in lectures, tutorials or on the course web
site. From time to time, the University will send important announcements to your university e-
mail address without providing you with a paper copy. You will be deemed to have received this
information. It is also your responsibility to keep the University informed of all changes to your
contact details.
3 SPECIAL CONSIDERATION AND SUPPLEMENTARY
EXAMINATIONS
You must submit all assignments and attend all examinations scheduled for your course. You
should seek assistance early if you suffer illness or misadventure which affects your course
progress.
General Information on Special Consideration:
1. For assessments worth 20% or more, all applications for special consideration must
go through UNSW Student Central
(https://my.unsw.edu.au/student/academiclife/StudentCentralKensington.html) and
be lodged within 3 working days of the assessment to which it refers.
2. If an assessment task is worth less than 20% of the total course assessment,
UNSW Student Central will not accept the special consideration unless the student
can provide a Medical Certificate that covers three consecutive days.
3. Applications will not be accepted by teaching staff, but you should notify the
lecture-in-charge when you make an application for special consideration through
UNSW Student Central.
4. Applying for special consideration does not automatically mean that you will be
granted a supplementary exam.
5. Special consideration requests do not allow lecturers-in-charge to award students
additional marks.
4 STUDENT RESOURCES AND SUPPORT
The University and the ASB provide a wide range of support services for students, including:
? ASB Education Development Unit (EDU) (www.business.unsw.edu.au/edu).
INFS 5991 – Business Intelligence 13
Academic writing, study skills and maths support specifically for ASB students. Services
include workshops, online and printed resources, and individual consultations. EDU
Office: Room GO7, Ground Floor, ASB Building (opposite Student Centre); Ph: 9385
5584; Email: [email protected].
? Blackboard eLearning Support: For online help using Blackboard, follow the links
from www.elearning.unsw.edu.au to UNSW Blackboard Support / Support for Students.
For technical support, Email: [email protected]; Ph: 9385 1333.
? UNSW Learning Centre (www.lc.unsw.edu.au)
Academic skills support services, including workshops and resources, for all UNSW
students. See website for details.
? Library training and search support services:
http://info.library.unsw.edu.au/web/services/services.html.
? IT Service Centre: Technical support for problems logging in to websites, downloading
documents etc. https://www.it.unsw.edu.au/students/index.html.
UNSW Library Annexe (Ground floor).
? UNSW Counselling and Psychological Services
(http://www.counselling.unsw.edu.au).
Free, confidential service for problems of a personal or academic nature; and
workshops on study issues such as ‘Coping With Stress’ and ‘Procrastination’.
Office: Level 2, Quadrangle East Wing; Ph: 9385 5418.
? Student Equity & Disabilities Unit (http://www.studentequity.unsw.edu.au). Advice
regarding equity and diversity issues, and support for students who have a disability or
disadvantage that interferes with their learning. Office: Ground Floor, J ohn Goodsell
Building; Ph: 9385 4734.
doc_868869172.pdf
Australian School Of Business Information Systems, Technology And Management Business Intelligence (BI)
INFS 5991 – Business Intelligence
1
INFS 5991
BUSINESS INTELLIGENCE (BI)
Course Outline
Semester 1, 2012
Australian School of Business
Information Systems, Technology and
Management
INFS 5991 – Business Intelligence
2
Table of Contents
PART A: COURSE-SPECIFIC INFORMATION 4
1 STAFF CONTACT DETAILS 4
2 COURSE DETAILS 4
2.1 Teaching Times and Locations 4
2.2 Units of Credit 4
2.3 Summary of Course 4
2.4 Course Aims and Relationship to Other Courses 4
2.5 Student Learning Outcomes 5
3 LEARNING AND TEACHING ACTIVITIES 5
3.1 Approach to Learning and Teaching in the Course 6
3.2 Learning Activities and Teaching Strategies 6
4 ASSESSMENT 7
4.1 Formal Requirements 7
? ATTAIN A COMPOSITE MARK OF AT LEAST 50%, 7
? ATTEND AT LEAST TEN SCHEDULED TUTORIAL CLASSES, 7
? MAKE A SATISFACTORY ATTEMPT AT ALL ASSESSMENT TASKS (SEE 4.2 BELOW). A MARK
OF 45 PERCENT OR HIGHER IS NORMALLY REGARDED AS SATISFACTORY, 7
? ATTAIN A MARK OF AT LEAST 45% IN THE FINAL EXAM, AND 7
? IN THE CASE OF PEER ASSESSED GROUP WORK, THE MARK ASSIGNED TO EACH MEMBER
OF THE GROUP MAY BE SCALED BASED ON PEER ASSESSMENT OF EACH MEMBER'S
CONTRIBUTION TO THE TASK. 7
4.2 Assessment Details 7
5 COURSE RESOURCES 8
6 COURSE EVALUATION AND DEVELOPMENT 9
7 COURSE SCHEDULE 10
PART B: KEY POLICIES, STUDENT RESPONSIBILITIES AND SUPPORT 11
1 ACADEMIC HONESTY AND PLAGIARISM 11
2 STUDENT RESPONSIBILITIES AND CONDUCT 11
2.1 Workload 11
2.2 Attendance 11
2.3 General Conduct and Behaviour 12
2.4 Occupational Health and Safety 12
2.5 Keeping Informed 12
3 SPECIAL CONSIDERATION AND SUPPLEMENTARY EXAMINATIONS 12
4 STUDENT RESOURCES AND SUPPORT 12
INFS 5991 – Business Intelligence
3
INFS 5991 – Business Intelligence
4
PART A: COURSE-SPECIFIC INFORMATION
1 STAFF CONTACT DETAILS
Position Name Email Room Phone
Lecturer-in-
charge
Dr. Farhad
Daneshgar
[email protected] QUAD, 2106 9385-
4241
Tutor Mr. Damrongsak
Naparat (Neo)
[email protected] TBA NA
The best way to contact your lecturer or tutor is via email or during their consultation times.
Please note that only your UNSW email account will be used for formal notices and
correspondence regarding the course.
Consultation Times:
Monday 13:00 – 14:00
Tuesday: 11:00 – 12:00
2 COURSE DETAILS
2.1 Teaching Times and Locations
Lectures start in Week 1 (to Week 12). The Time and Location are:
Tuesday 18:00am-20:00, ASB 114
Tutorials start in Week 2 (to Week 13). The Time and Locations are:
Tutorial: Tuesday 20:00-21:00 EE218
2.2 Units of Credit
The course is worth 6 units of credit.
There is no parallel teaching in this course.
2.3 Summary of Course
This course examines the process of decision making and work group activity by professional
and managerial people; the tools and techniques available in information technology to support
these processes and when they can be advantageously used; some of the reasons why so
many executive support systems do not achieve their intended objectives; and the cultural and
organisational issues involved in the use of Information Technology tools and techniques. The
course has a technical component in which students gain practical knowledge and experience in
decision support and business intelligence systems using BI software (e.g., EXCEL,
PlannersLab, Pentaho and J Report software systems).
2.4 Course Aims and Relationship to Other Courses
? To introduce students to the concepts, processes and practice of decision making at both
individual and group levels in relation to the appropriate utilisation of the ICT in today’s
organisations;
? To provide an understanding of the senior management perspective regarding the use of
business intelligence (BI) systems, and
INFS 5991 – Business Intelligence
5
? To encourage students to consider the strategic use of BI technology for strategic
advantage, and to provide practical understanding of the BI concepts and technologies in
business organisations.
Achieving the above aims is expected to produce the following student learning outcomes.
These learning outcomes in turn, are expected to enhance students’ graduate attributes by
transforming students into knowledgeable human resources.
2.5 Student Learning Outcomes
In this course, learning is about application, insight, understanding, research, professionalism,
and personal development. Learning in this course is NOT about simply acquiring knowledge,
nor memorising and long-term retention. More specifically, by the end of the course, you should
be able to:
1. Apply theoretical concepts of the course materials (e.g., textbook, journal articles, etc) to the
decision-making and BI processes and technologies in order to prepare students for making
appropriate managerial decisions in future real-life situations. Through applying the
practices of the project management students will be able to understand how “text book
theory” works “in today’s business practices”. Ultimately, it will be up to student to relate the
theory and associated readings to the practical business applications.
2. Undertake systematic investigation/research related to the decision support and BI systems
and technologies for today’s dynamic business environment.
3. Develop professional attitudes in students in relation to the team work, interpersonal
communication, and business ethics.
ASB Graduate Attributes
This course contributes to your development of the following Australian School of Business
Graduate Attributes, which are the qualities, skills and understandings we want you to have by
the completion of your degree:
Student
Learning
Outcomes
ASB Graduate Attributes
1, 2 1. Critical thinking and problem solving
3 2. Communication
3 3. Teamwork and leadership
3 4. Social, ethical and global perspectives
1, 2 5. In-depth engagement with relevant disciplinary knowledge
1, 3 6. Professional skills
It is important for students to understand the relationship that exists between the course aims,
student learning outcomes (and supportive learning activities and assessment components as
explained below), and the graduate attributes, to the overall requirements of students’ degree
course, and students’ future study/professional goals. It is intended that all these issues are
addressed in this document by adopting an integrated and inclusive approach to satisfying
students’ learning needs. The lecturer will be more than happy to further discuss these issues
with students and to provide assistance in understanding the above matters.
To see how the ASB Graduate Attributes relate to the UNSW Graduate Attributes, refer to the
ASB website (Learning and Teaching >Graduate Attributes).
3 LEARNING AND TEACHING ACTIVITIES
INFS 5991 – Business Intelligence
6
3.1 Approach to Learning and Teaching in the Course
The formal learning component of this course involves active and collaborative participation in,
and contribution to, all forms of classroom, team, and virtual learning activities including
lectures, discussion forums, workshops, individual learning activities, and group projects. The
formal component comprises a three-hour weekly block consisting of a 2-hour lecture and a
one-hour tutorial session. An academic staff member called the Tutor will work with one group
of 15-20 students throughout the semester, and will conduct weekly workshops. Each student is
required to attend one (1) lecture AND one (1) tutorial/workshop per week. In addition, students
are expected to complete both individual self-directed, as well as group learning activities each
week, and to carry out reading and research for assignments and workshop preparation, all in
direct relation to the course objectives and associated learning outcomes and ASB Graduate
Attributes as discussed later. All the topics covered in lectures and tutorials, as well as
individual/group-directed learning activities are assessable.
Lectures (2 hours per week): These are typically comprised of material that address assignment
and quiz content. Lectures will provide an overview of major topics and current issues within the
field of BI technologies and decision support systems.
Tutorials (1 hour per week): Tutorials are allocated for providing hands on experience to
students in applying BI technologies in professional contexts. The tutorial; activities are normally
related to the materials that are covered in the lectures but also introduces students to
additional technological practices that are expected from today’s typical business managers.
The Tutor will work closely with students and assist them in their tutorial learning activities.
Final Note: Students are expected to read the relevant text chapters and associated readings
BEFORE the lecture and workshops. Students are also required to attend the workshop in
which they are enrolled. In the case more than one tutorial class is available you will only
receive credit for your participation in the tutorial class that you are enrolled in. Please note that
you are required to attend at least 10 of the twelve workshops otherwise you will automatically
fail the course.
3.2 Learning Activities and Teaching Strategies
One strategy for achieving the above learning outcomes is to adopt a learning-centric approach
where both lecturer and students are engaged in an active, challenging, collaborative,
democratic, critically reflective, and transforming educational encounters. In the process, deep
learning is encouraged for concepts that relate to solving real-life decision environments. As a
result, a great portion of lectures, major assessments and tutorial tasks will be spent on case
studies and application of the theories to the real-life situations. However, low cognitive level
activities and surface learning, such as working with certain computer programs, will
supplement the above cognitive process during the tutorial classes.
Assignments are expected to develop a sense of teamwork and collaborative achievement of
project aims (see section 4.2 for more details). Appropriate collaborative ubiquitous virtual
environments such as the course discussion forums at both classroom and project levels are
provided for the general discussions and project-specific discussions. As a result of the adoption
of a collaborative learning strategy for this course, the teaching staff will be able to further guide
student activities towards the achievements of the assessment learning objectives ubiquitously.
During consultation times a similar assistance will be provided in order to support those group
activities that are performed in physical environments.
Note: the above collaborative learning-centric strategy will produce best results if students
actively participate in all teaching and learning activities that are specifically designed for the
achievement of specific learning outcomes.
INFS 5991 – Business Intelligence
7
4 ASSESSMENT
4.1 Formal Requirements
In order to pass this course, you must:
? attain a composite mark of at least 50%,
? attend at least ten scheduled tutorial classes,
? make a satisfactory attempt at all assessment tasks (see 4.2 below). A mark of 45
percent or higher is normally regarded as satisfactory,
? attain a mark of at least 45% in the final exam, and
? in the case of peer assessed group work, the mark assigned to each member of the
group may be scaled based on peer assessment of each member's contribution to the
task.
The School reserves the right to scale final marks to a mean of 60%.
It should be noted that group members are expected to work in a harmonious and professional
fashion which includes adequate management of non-performing members.
4.2 Assessment Details
Assessment
Task
Weight Learning
Outcomes
addressed
ASB
Graduate
Attributes
assessed
Due date Method of assessment
Tutorials/
Workshops
15% 1, 2 1, 2
Conducted in
tutorial classes
starting at wk2
Tasks and Participation: up to 15%
Lecture
(Group)
Assignment 1
15% 1, 2, 3 1, 3, 6
Week 6 –
delivered in
the lecture
Case Study analysis: applying learnt
materials to the case
Lecture
(Group)
Assignment 2
15% 1, 2, 3 1, 3, 5, 6
Week 11 –
delivered in
the lecture
A Case Study that also requires
systematic review of the literature.
Final Exam 55% 1, 2 1, 5 TBA One essay and one long case study
(both selected from the textbook) total
of 25/55 marks. Two short questions
and two small case studies (half from
the textbook) total of 20/55 marks (5
marks each). Five multiple-choice
questions (may also include
Diagrams/models from the textbook)
total of 10/55 marks
Details of each assessment task:
Workshop tasks and the lecture notes will be available progressively on the course website.
There is an assessment component in this course for “participation” in the tutorial classes. You
are expected to actively participate in the workshops and perform assessed tasks (15%). The
tutorial/workshop tasks involve modelling activities to produce managerial reports using BI
system. Some of the weekly tutorial tasks will have to be performed at home and will be
assessed at the end of tutorials. Failure to comply with these requirements will result in failure
of that component of the course as mentioned before. Both the hard and soft copies of the
tutorial homework must be brought to the workshop session for collection and marking. Please
INFS 5991 – Business Intelligence
8
do not show the electronic version of the workshop task to the tutor as a substitute for the paper
copy as that will not be acceptable and you will receive a mark of zero.
The two group assignments are designed to develop required skills to practice team-work, as
well as locating, evaluating and using relevant information to analyse a BI problem (see the
above table for relevant learning outcomes and graduate attributes). Paper copies of
assignments are to be handed in the lecture room by the due date. For additional safety, each
group must post an electronic version of their assignment on the group’s private discussion
forum prior to attending that lecture. The electronic version of the assignment will not be
marked and is used for detecting plagiarism and violations of copyright issues. Assignments
must be presented in professional format with appropriate referencing and full respect to the
copyrights of the cited references. All the references will be checked for integrity and
correctness. Assignment 1 will carry 20% mark for professional presentation (style, ethical
practices, and correctness), 30% for group work (professional behaviour, team-work and
‘lessons learnt’), and 50% for analysis and academic rigour. Assignment 2 will carry 10% mark
for professional presentation, 20% for group work, and 70% for analysis, academic rigour, and
the quality of the referencing and literature review.
Note: UNSW Assessment Policy requires that students receive clear assessment instructions
and criteria at the beginning of the course. However, if assessment information is very long
(e.g. case scenarios, data sets, detailed instructions or style guides) or cannot be finalised
before the commencement of the course (e.g. because the details will be negotiated with the
cohort or will reflect changing external conditions), basic information addressing the bullet
points should be included in this section and students should be given clear instructions here as
to what additional information is available elsewhere (and why) and when and where it will be
provided, with relevant links included e.g. to Blackboard.
5 COURSE RESOURCES
The website for this course is on UNSW Blackboard at:
https://lms-blackboard.telt.unsw.edu.au/webapps/portal/frameset.jsp
Prescribed textbook: (students are strongly advised not to purchase the older versions of the
book as they exclude recent ICT topics and case studies that we frequently discuss in the
course)
Decision Support and Business Intelligence Systems: International Edition, 9
th
edition ( the
latest version as of November 2011) by: Efraim Turban, Ramesh Shadra, and Dursun Delen;
Pearson Publishing, 2011.
Additional reference:
Electronic J ournals will be used in this course; links to relevant online journals will be provided
in the course website.
Additional materials uploaded in the Blackboard:
Case Studies, weekly workshop exercises, links to relevant library resources available to the
UNSW students, announcements, discussion forums, and more …...
Quality Assurance
The ASB is actively monitoring student learning and quality of the student experience in all
its programs. A random selection of completed assessment tasks may be used for quality
assurance, such as to determine the extent to which program learning goals are being
achieved. The information is required for accreditation purposes, and aggregated findings
will be used to inform changes aimed at improving the quality of ASB programs. All material
used for such processes will be treated as confidential and will not be related to course
grades.
INFS 5991 – Business Intelligence
9
For the Library information/subject guides visit the following web site:
http://info.library.unsw.edu.au/web/services/services.html
6 COURSE EVALUATION AND DEVELOPMENT
Each year feedback is sought from students about the courses offered in the School and
continual improvements are made based on this feedback. UNSW's Course and Teaching
Evaluation and Improvement (CATEI) Process is one of the ways in which student evaluative
feedback is gathered. In this course, we will seek your feedback through end of semester
CATEI evaluations. As a result of similar feedback last year few improvements were made to
this year’s offering.
INFS 5991 – Business Intelligence
10
7 COURSE SCHEDULE
Lectures start in Week 1 and finish in Week 12.
Week
starting:
Lecture Topic Tutorial Topic References Other Activities/
Assessment
Week 1
27 Feb
Modelling and Analysis Ch. 1 & 4 +
journal
article
All article will be
posted both in
hardcopies as well
as posted on the
Blackboard
Week 2
5 March
Decision Support
Systems (DSS) and
Business Intelligence
(BI)
Introduction to BI
workshop, its logistics,
and working with Oracle’s
Virtual Box
Ch.1 & 4
Week 3
12 March
Decision Making
Process
Basic decision making
modelling with Planners
Labs.
Ch. 2
Week 4
19 March
DSS Concepts, Methods
& Technologies
What-if, goal seek, and
sensitivity analysis with
Planners Labs.
Ch.3 +
journal
article
Week 5
26 March
BI: Data Mining (Part 1) Decision making with
statistical model and
business process
optimisation.
Ch. 5
Week 6
2 April
BI: Data Mining (Part 2) Power Pivot: Integrating
data for business analysis
and data filtering.
Ch. 5 Lecture Assignment
1 Due today (see
note below)
9 April
week
Mid-session Break; no classes this week
Week 7
16 April
BI: Artificial Neural
Network (ANN) and DM
Data integration & Data
cleansing (part 1).
Ch. 6 +
journal
article
Week 8
23 April
BI: Text & Web Mining Data integration & Data
cleansing (part 2).
Ch. 7
Week 9
30 April
BI: Data Warehousing Data mining techniques
for business purposes
(part 1: Knowledge
discovery)
Ch. 8
Week 10
7 May
Collaborative Computer-
Supported Technologies
Data mining techniques
for business purposes
(part 2: Forecasting)
Ch. 10
Week 11
14 May
Knowledge
Management and BI
Building interactive
reports.
Ch. 11 +
journal
article
Lecture Assignment
2 Due today
Week 12
21 May
Expert Systems &
Advanced Intelligent
Systems
Building dashboards. Parts of Ch.
12 & Ch. 13
Week 13
28 May
No Lectures Expert systems
demonstration (web-
based).
Note: details about Tutorial assignments and/or exercises will be available on week 2
INFS 5991 – Business Intelligence
11
PART B: KEY POLICIES, STUDENT RESPONSIBILITIES AND
SUPPORT
1 ACADEMIC HONESTY AND PLAGIARISM
The University regards plagiarism as a form of academic misconduct, and has very strict rules
regarding plagiarism. For UNSW policies, penalties, and information to help you avoid
plagiarism see: http://www.lc.unsw.edu.au/plagiarism/index.html as well as the guidelines in the
online ELISE and ELISE Plus tutorials for all new UNSW students:
http://info.library.unsw.edu.au/skills/tutorials/InfoSkills/index.htm.
To see if you understand plagiarism, do this short quiz:
http://www.lc.unsw.edu.au/plagiarism/plagquiz.html.
For information on how to acknowledge your sources and reference correctly, see:
http://www.lc.unsw.edu.au/onlib/ref.html.
For the ASB Harvard Referencing Guide, see ASB Referencing and Plagiarism webpage (ASB
>Learning and Teaching>Student services>Referencing and plagiarism).
2 STUDENT RESPONSIBILITIES AND CONDUCT
Students are expected to be familiar with and adhere to university policies in relation to class
attendance and general conduct and behaviour, including maintaining a safe, respectful
environment; and to understand their obligations in relation to workload, assessment and
keeping informed.
Information and policies on these topics can be found in the ‘A-Z Student Guide’:
https://my.unsw.edu.au/student/atoz/A.html. See, especially, information on ‘Attendance and
Absence’, ‘Academic Misconduct’, ‘Assessment Information’, ‘Examinations’, ‘Student
Responsibilities’, ‘Workload’ and policies such as ‘Occupational Health and Safety’.
.
2.1 Workload
It is expected that you will spend at least ten hours per week studying this course. This time
should be made up of reading, research, working on exercises and problems, and attending
classes. In periods where you need to complete assignments or prepare for examinations, the
workload may be greater.
Over-commitment has been a cause of failure for many students. You should take the required
workload into account when planning how to balance study with employment and other
activities.
2.2 Attendance
Your regular and punctual attendance at lectures and seminars is expected in this course.
University regulations indicate that if students attend less than 80% of scheduled classes they
may be refused final assessment.
INFS 5991 – Business Intelligence 12
2.3 General Conduct and Behaviour
You are expected to conduct yourself with consideration and respect for the needs of your
fellow students and teaching staff. Conduct which unduly disrupts or interferes with a class,
such as ringing or talking on mobile phones, is not acceptable and students may be asked to
leave the class. More information on student conduct is available at:
https://my.unsw.edu.au/student/atoz/BehaviourOfStudents.html.
2.4 Occupational Health and Safety
UNSW Policy requires each person to work safely and responsibly, in order to avoid personal
injury and to protect the safety of others. For more information, see
http://www.ohs.unsw.edu.au/.
2.5 Keeping Informed
You should take note of all announcements made in lectures, tutorials or on the course web
site. From time to time, the University will send important announcements to your university e-
mail address without providing you with a paper copy. You will be deemed to have received this
information. It is also your responsibility to keep the University informed of all changes to your
contact details.
3 SPECIAL CONSIDERATION AND SUPPLEMENTARY
EXAMINATIONS
You must submit all assignments and attend all examinations scheduled for your course. You
should seek assistance early if you suffer illness or misadventure which affects your course
progress.
General Information on Special Consideration:
1. For assessments worth 20% or more, all applications for special consideration must
go through UNSW Student Central
(https://my.unsw.edu.au/student/academiclife/StudentCentralKensington.html) and
be lodged within 3 working days of the assessment to which it refers.
2. If an assessment task is worth less than 20% of the total course assessment,
UNSW Student Central will not accept the special consideration unless the student
can provide a Medical Certificate that covers three consecutive days.
3. Applications will not be accepted by teaching staff, but you should notify the
lecture-in-charge when you make an application for special consideration through
UNSW Student Central.
4. Applying for special consideration does not automatically mean that you will be
granted a supplementary exam.
5. Special consideration requests do not allow lecturers-in-charge to award students
additional marks.
4 STUDENT RESOURCES AND SUPPORT
The University and the ASB provide a wide range of support services for students, including:
? ASB Education Development Unit (EDU) (www.business.unsw.edu.au/edu).
INFS 5991 – Business Intelligence 13
Academic writing, study skills and maths support specifically for ASB students. Services
include workshops, online and printed resources, and individual consultations. EDU
Office: Room GO7, Ground Floor, ASB Building (opposite Student Centre); Ph: 9385
5584; Email: [email protected].
? Blackboard eLearning Support: For online help using Blackboard, follow the links
from www.elearning.unsw.edu.au to UNSW Blackboard Support / Support for Students.
For technical support, Email: [email protected]; Ph: 9385 1333.
? UNSW Learning Centre (www.lc.unsw.edu.au)
Academic skills support services, including workshops and resources, for all UNSW
students. See website for details.
? Library training and search support services:
http://info.library.unsw.edu.au/web/services/services.html.
? IT Service Centre: Technical support for problems logging in to websites, downloading
documents etc. https://www.it.unsw.edu.au/students/index.html.
UNSW Library Annexe (Ground floor).
? UNSW Counselling and Psychological Services
(http://www.counselling.unsw.edu.au).
Free, confidential service for problems of a personal or academic nature; and
workshops on study issues such as ‘Coping With Stress’ and ‘Procrastination’.
Office: Level 2, Quadrangle East Wing; Ph: 9385 5418.
? Student Equity & Disabilities Unit (http://www.studentequity.unsw.edu.au). Advice
regarding equity and diversity issues, and support for students who have a disability or
disadvantage that interferes with their learning. Office: Ground Floor, J ohn Goodsell
Building; Ph: 9385 4734.
doc_868869172.pdf