FIT3003 Business intelligence and data warehousing
Faculty of Information Technology
FIT3003 Business intelligence and data warehousing is a level 3, 6-credit-point, undergraduate unit from the Faculty of Information Technology, offered in 2027 in Semester 2 at Clayton and Malaysia. It needs FIT2094 or FIT3171.
- Credit points
- 6
- Offered in 2027
- Semester 2
- Clayton, Malaysia
- Assessment
- Exam 40%
- and 3 other tasks
- Workload
- 144 hours
- per semester
Reviews
No reviews yetNo reviews yet. Be the first to review FIT3003.
Requisites
Before FIT3003
Prerequisites
Pass these before you enrol.
After FIT3003
No unit lists FIT3003 as a prerequisite in the 2027 handbook.
Overview
Automation and the use of technological tools have resulted in the accumulation of vast volumes of data by modern business organisations. Data warehouses have been set up as repositories to store this data and improved techniques now result in the speedy collection and integration of such data. OLAP technology has resulted in the faster generation of reports and more flexible analysis based on the data repositories. This unit will explore the concepts of data warehousing and OLAP, covering the data processing technological requirements for data warehousing and OLAP and will provide hands on experience on designing data warehousing and OLAP systems.
Offerings in 2027
| Teaching period | Campus | Mode |
|---|---|---|
| Second semester | Clayton | Flexible |
| Second semester | Malaysia | On campus |
Assessment
- Assessment 1Quiz / Test10%
- Assessment 2Artefact40%
- Assessment 3Quiz / Test10%
- Scheduled final assessment (2 hours and 10 minutes)Examination40%
Assessment details may change. Please refer to the assessment information in Moodle closer to the start of the teaching period.
Learning outcomes
When you finish this unit, you should be able to:
- 1
Design multi-dimensional databases and data warehouses;
- 2
Use fact and dimensional modelling;
- 3
Implement online analytical processing (OLAP) queries;
- 4
Explain the roles of data warehousing architecture and the concepts of granularity in data warehousing;
- 5
Create business intelligence reports using data warehouses and OLAP.
Workload and teaching
- Seminars24 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
Technology resources
ORACLE DBMS for applying the ETL process and building a star schema.
Where it fits
FIT3003 is part of 2 areas of study in the 2027 handbook.
Contacts
- Chief Examiners
- Associate Professor David Taniar
- Unit Coordinators
- Dr Isma Farah Siddiqui
- Dr Soon Lay Ki
Common questions
When is FIT3003 offered?
In 2027, FIT3003 runs in Semester 2 at Clayton and Malaysia.
How much work is FIT3003?
The handbook expects about 144 hours of study across the semester. No students have rated its difficulty yet.
Does FIT3003 have an exam?
Yes. The exam is worth 40% of the final mark, alongside 3 other tasks.
Which majors and minors include FIT3003?
FIT3003 is part of Data science and Software engineering.