[an error occurred while processing this directive] [an error occurred while processing this directive]
[an error occurred while processing this directive]
[an error occurred while processing this directive]
Monash University

FIT5093 Business intelligence applications - Semester 2, 2013

This unit is intended to provide students with a framework for understanding business intelligence reporting systems with particular focus on the evolutionary process of developing an OLAP-based business intelligence system.

Mode of Delivery

Caulfield (Day)

Contact Hours

2 hrs lectures/wk, 2 hr laboratory/wk

Workload requirements

Students are expected to spend a total of 12 hours per week during semester on this unit as follows:

  • Lecture: 2 hours per week
  • Tutorial / Laboratory: 2 hours per week
  • Lecture Preparation: Approximately 2 hours before each lecture to read and understand the lecture readings.
  • Tutorial / Laboratory Preparation: Approximately 1 hour before to read and understand the laboratory notes.
  • Other Tasks: Up to 5 hours per week participating in online discussion forums, completing laboratory exercises, working on assignments, and regular preparation for the final examination.

Unit Relationships

Prohibitions

IMS5004

Prerequisites

One of FIT9003, BUS5071, IMS9003 or equivalent

Chief Examiner

Campus Lecturer

Caulfield

Steve Remington

Tutors

Caulfield

Steve Remington

Felix Lizama

Sindy Madrid

Academic Overview

Learning Outcomes

At the completion of this unit students will:
  • understand the scope and application of OLAP technology and business intelligence systems;
  • have knowledge of the major approaches to the development of business intelligence and reporting systems;
  • be able to design simple multi-dimensional databases;
  • be able to develop a simple business intelligence system using an OLAP tool;
  • be able to develop a simple reporting system;
  • be able to communicate and foster realistic expectations of the role of OLAP technology and business intelligence systems in management and decision support.

Unit Schedule

Week Activities Assessment
0 Familiarise yourself with the Moodle-based unit web site and read the Week 1 lecture readings No formal assessment or activities are undertaken in week 0
1 Introduction to the Unit and Introduction to BI Applications Reflective Journal Posts each week
2 The Nature of BI Applications - Industry-Wide Surveys  
3 Multi-Dimensional Modelling (I)  
4 Multi-Dimensional Modelling (II)  
5 Business Performance Measurement (I)  
6 Business Performance Measurement (II)  
7 Methods for BI Application Development Prototype Business Intelligence Application: Part 1 - Design Specification Document
8 The Nature of BI Applications - Organisation Case Studies  
9 BI Application Technology  
10 Designing BI Application User Interfaces (I)  
11 Designing BI Application User Interfaces (II)  
12 Industry Guest Speaker, The future of BI Applications and Exam Overview Prototype Business Intelligence Application: Part 2 - Developed and Implemented Application
  SWOT VAC No formal assessment is undertaken in SWOT VAC. Reflective Journal Posts: last blog entry anytime before the exam.
  Examination period LINK to Assessment Policy: http://policy.monash.edu.au/policy-bank/
academic/education/assessment/
assessment-in-coursework-policy.html

*Unit Schedule details will be maintained and communicated to you via your learning system.

Assessment Summary

Examination (3 hours): 50%; In-semester assessment: 50%

Assessment Task Value Due Date
Prototype Business Intelligence Application: Part 1 Design Specification Document 25% The design specification document must be submitted for marking and feedback at the end of Week 7. The revised version of the design specification (if the student wishes to resubmit it) is due at the end of Week 12.
Prototype Business Intelligence Application: Part 2 Development and Implementation 25% End of Week 12.
Reflective Journal Posts Bonus of a maximum of 3% added to overall assignment mark. Your last blog entry can be made anytime before the exam.
Examination 1 50% To be advised

Teaching Approach

  • Lecture and tutorials or problem classes
    This teaching and learning approach provides facilitated learning, practical exploration and peer learning.
    The lecture stream of the unit will present and critically analyze theories, case studies and industry trends. The lectures will use interactive web 2.0 technology to facilitate interaction.
  • Laboratory-based classes
    This teaching approach is practical learning.
    The laboratory classes will provide an exposure to the major technologies used in business intelligence. They will provide students with the skills required to work on the practical assignments.
  • Problem-based learning
    Students are encouraged to take responsibility for organising and directing their learning with support from their supervisors.
    Many of the concepts and theories in this area can't be understood without experience. The unit features a major practical assignment that provides students with a concrete realistic design and development activity that will help reinforce and clarify the material presented in the unit. 

Assessment Requirements

Assessment Policy

Faculty Policy - Unit Assessment Hurdles (http://www.infotech.monash.edu.au/resources/staff/edgov/policies/assessment-examinations/unit-assessment-hurdles.html)

Academic Integrity - Please see the Demystifying Citing and Referencing tutorial at http://lib.monash.edu/tutorials/citing/

Assessment Tasks

Participation

  • Assessment task 1
    Title:
    Prototype Business Intelligence Application: Part 1 Design Specification Document
    Description:
    This assessment task involves the creation of a documented design specification for a prototype business intelligence application. An application, based on this design specification, will be developed and implemented in Assessment Task 2.

    Students can use the feedback received on the design specification to improve the developed and implemented application.

    Students may choose to revise their design specification based on the feedback received and re-submit it for re-marking in Week 12.

    The Moodle-based unit web site contains details of the submission requirements and the case study on which the prototype business intelligence application will be based.
    Weighting:
    25%
    Criteria for assessment:

    The main criteria used to assess this submission will include:

    1. The ability of the system to answer the business questions posed by the case study.
    2. Quality of the justification of design choices made.
    3. The professionalism, presentation and clarity of the specifiaction.

    See the Moodle-based unit web site for details of the assessment criteria.

    Due date:
    The design specification document must be submitted for marking and feedback at the end of Week 7. The revised version of the design specification (if the student wishes to resubmit it) is due at the end of Week 12.
  • Assessment task 2
    Title:
    Prototype Business Intelligence Application: Part 2 Development and Implementation
    Description:
    Assessment Task 2 involves the development and implementation of a working prototype business intelligence application. The application will be based on the design specification created in Assessment Task 1.

    The Moodle-based unit web site contains details of the required submission and the case study the assignment work will be based on.
    Weighting:
    25%
    Criteria for assessment:

    The main criteria used to assess this submission will include:

    1. The ability of the system to answer the business questions posed by the case study.
    2. The consistency of the system with the design specification (Assessment Task 1).
    3. The application of best-practice design principles to the display of data in the system's views and reports.

    See the Moodle-based unit web site for details of the assessment criteria.

    Due date:
    End of Week 12.
  • Assessment task 3
    Title:
    Reflective Journal Posts
    Description:
    Each student is invited to keep a reflective journal on the either the Moodle-based unit web site or the Faculty blog site http://blog.infotech.monash.edu.au or using a 3rd party site like the http://www.blogger.com system. This blog will provide students the opportunity to reflect on the learning that takes place throughout the unit. Each week you will be able to make a new posting to your blog. The blog entries should include a reflection on what has happened in terms of your progress on assignment and tutorial work, your management of the assignment project and its tasks, what lessons have been learned to date and what you (and the staff) could do differently.

    To obtain the 3% bonus mark for this task you must complete a minimum of 10 weekly blog entries during the semester. Each blog post will be read and assessed by the chief examiner. To get the 3% bonus 6 of these posts should be assessed as "satisfactory".

    The 3% bonus will be added to the assignment component of the mark available for the unit.

    Note: The assignment component cannot exceed 50%. So, for example, a student who obtained 46/50 for their assignment work and who earns the bonus will get 49%. While a student who got 49/50 would get 50/50 - the maximum available - if they earned the bonus.

    For more details, please refer to the Moodle-based unit web site.
    Weighting:
    Bonus of a maximum of 3% added to overall assignment mark.
    Criteria for assessment:
    For more details, please refer to the Moodle-based unit web site.
    Due date:
    Your last blog entry can be made anytime before the exam.

Examinations

  • Examination 1
    Weighting:
    50%
    Length:
    3 hours
    Type (open/closed book):
    Closed book
    Electronic devices allowed in the exam:
    None
    Remarks:
    The exam will be scheduled by the central Monash exams branch during the normal examination period at the end of the semester.

Learning resources

Reading list

Extensive reading will be made available to students using the library's digital scanning service and has been posted on the unit web site.

Useful texts include:

  • Eckerson, W (2006) Performance Dashboards: Measuring, Monitoring, and Managing Your Business Wiley.
  • Thomsen, E. (2002). OLAP Solutions: Building Multidimensional Information Systems (2nd Edition) Wiley.
  • Parmenter, D. (2007) Key Performance Indicators (KPI): Developing, Implementing and Using Winning KPIs Wiley.
  • Vitt, E., Luckevich, M. & Misner, S. (2002). Business Intelligence. Microsoft Press.

Monash Library Unit Reading List
http://readinglists.lib.monash.edu/index.html

Feedback to you

Types of feedback you can expect to receive in this unit are:
  • Informal feedback on progress in labs/tutes
  • Graded assignments with comments
  • Solutions to tutes, labs and assignments

Extensions and penalties

Returning assignments

Assignment submission

It is a University requirement (http://www.policy.monash.edu/policy-bank/academic/education/conduct/plagiarism-procedures.html) for students to submit an assignment coversheet for each assessment item. Faculty Assignment coversheets can be found at http://www.infotech.monash.edu.au/resources/student/forms/. Please check with your Lecturer on the submission method for your assignment coversheet (e.g. attach a file to the online assignment submission, hand-in a hard copy, or use an online quiz). Please note that it is your responsibility to retain copies of your assessments.

Online submission

If Electronic Submission has been approved for your unit, please submit your work via the learning system for this unit, which you can access via links in the my.monash portal.

Required Resources

Please check with your lecturer before purchasing any Required Resources. Limited copies of prescribed texts are available for you to borrow in the library, and prescribed software is available in student labs.

Prescribed Text(s) and Readings

There is no prescribed text for this unit.

The details of prescribed readings for each week's lecture and/or laboratory will be provided in the unit web site.

Required Software and/or Hardware

The unit will make extensive use of a wide variety of OLAP and business intelligence software packages including Microsoft Excel, Crystal Reports and Crystal Dashboard Designer.

The main tool that will be used is Microsoft SQL Server Analysis Services 2008 R2. This product is installed in the computer laboratories we will be using, and is available for loan under a license agreement from Microsoft - so that students can install a copy on their personal computer for use on assignment and tutorial work.

A useful link: http://infotech.monash.edu/itsupport/msdnaa.html

Other Information

Policies

Graduate Attributes Policy

Student services

Monash University Library

Disability Liaison Unit

Students who have a disability or medical condition are welcome to contact the Disability Liaison Unit to discuss academic support services. Disability Liaison Officers (DLOs) visit all Victorian campuses on a regular basis.

Your feedback to Us

Previous Student Evaluations of this Unit

The unit is well established. There are no major changes - other than updates of the content where appropriate - planned this year. Student (and staff) evaluations of the unit have in the past been very positive.

If you wish to view how previous students rated this unit, please go to
https://emuapps.monash.edu.au/unitevaluations/index.jsp

[an error occurred while processing this directive]