FIT5195 Business intelligence and data warehousing
Faculty of Information Technology
FIT5195 Business intelligence and data warehousing is a level 5, 6-credit-point, postgraduate unit from the Faculty of Information Technology, offered in 2021 in Summer A, Semester 1 and Summer B at Clayton, Malaysia and Monash Online. It needs FIT9132.
- Credit points
- 6
- Offered in 2021
- Summer A, Semester 1, Summer B
- Clayton, Malaysia, Monash Online
- Assessment
- Exam 60%
- and 9 other tasks
- Workload
- 144 hours
- per semester
This is the 2021 handbook entry. See the 2023 entry.
Reviews
No reviews yetNo reviews yet. Be the first to review FIT5195.
Requisites
Before FIT5195
Prohibitions
You can't enrol if you have passed any of these.
Prerequisites
Pass these before you enrol.
After FIT5195
No unit lists FIT5195 as a prerequisite in the 2021 handbook.
Overview
This unit is intended to provide you with a framework for understanding business intelligence systems as well as the provision of high quality, integrated data for decision support through data warehousing. The unit has a particular focus on the evolutionary process of developing data warehousing using relational database management systems, and multi-dimensional modelling for structuring business intelligence data. The unit also presents you with coverage of several important aspects of data warehousing, including architecture, design, implementation, and optimisation. The unit will present this material using relevant research, case studies and practical exercises. You will develop data warehouse modelling and OLAP using relational database management systems.
Offerings in 2021
| Teaching period | Campus | Mode |
|---|---|---|
| Summer semester A | Clayton | On campus |
| First semester | Clayton | On campus |
| First semester | Malaysia | Evening |
| Summer semester B | Clayton | On campus |
| Teaching period 1 | Monash Online | Online |
Assessment
- Take home testOtherThreshold hurdle5%
- Major AssignmentAssignmentThreshold hurdle20%
- Moodle QuizOtherThreshold hurdle5%
- Advanced DW Video PresentationPresentationThreshold hurdle5%
- Flux Participation (online quizzes)ParticipationThreshold hurdle5%
- Scheduled final assessment i(2 hours and 10 minutes)ExamThreshold hurdle60%
- Assignment 1aAssignment30%
- Assignment 1bAssignment15%
- Assignment 2Presentation25%
- End of Term QuizOther30%
Learning outcomes
When you finish this unit, you should be able to:
- 1
describe the scope and application of data warehousing
- 2
design data warehousing systems
- 3
design multidimensional data models using star schemas
- 4
implement data warehousing in relational databases
- 5
use OLAP in SQL
- 6
explain the need for data warehousing architecture
- 7
explain query optimisation and its impact on multi-dimensional design
Workload and teaching
- Laboratories24 hours
- Lectures24 hours
- Teaching approachActive learning
Minimum total expected workload to achieve the learning outcomes for this unit is 144 hours per semester typically comprising a mixture of scheduled online and face to face learning activities and independent study. Independent study may include associated reading and preparation for scheduled activities. The unit requires on average three/four hours of scheduled activities per week. Scheduled activities may include a combination of teacher directed learning and online engagement.
Learning resources
Required resources
Students should have access to a Windows or Mac OS computer for work on assignments. Software will be available in student computer labs as well as for download and installation on personal computers. Students working off-campus may be required to install the Monash VPN software to connect to our servers for some tutorial exercises.
Technology resources
Windows or Mac OS computer able to run Oracle DBMS. Software will be available in student computer labs as well as for download and installation on personal devices.
Contacts
- Chief Examiners
- Associate Professor David Taniar
- Unit Coordinators
- Dr Soon Lay Ki
Common questions
What are the prerequisites for FIT5195?
You need FIT9132 before you enrol.
When is FIT5195 offered?
In 2021, FIT5195 runs in Summer A, Semester 1 and Summer B at Clayton, Malaysia and Monash Online, with an online option.
How much work is FIT5195?
The handbook expects about 144 hours of study across the semester. No students have rated its difficulty yet.
Does FIT5195 have an exam?
Yes. The exam is worth 60% of the final mark, alongside 9 other tasks.