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. It isn't offered in 2023. It needs FIT9132.
- Credit points
- 6
- Offered in 2023
- Not offered
- Assessment
- Exam 60%
- and 5 other tasks
- Workload
- 144 hours
- per semester
The 2027 handbook has no page for FIT5195. This is its 2023 entry, the latest one.
Reviews
No reviews yetNo reviews yet. Be the first to review FIT5195.
Requisites
Before FIT5195
Prerequisites
Pass these before you enrol.
Prohibitions
You can't enrol if you have passed any of these.
After FIT5195
No unit lists FIT5195 as a prerequisite in the 2023 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 2023
The 2023 handbook lists no offerings for FIT5195.
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 (2 hours and 10 minutes)ExamThreshold hurdle60%
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
- Lectures24 hours
- Laboratories24 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 teaching activities.
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
Common questions
What are the prerequisites for FIT5195?
You need FIT9132 before you enrol.
When is FIT5195 offered?
FIT5195 has no offerings listed in the 2023 handbook.
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 5 other tasks.