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 2025 in Semester 2 at Clayton and Malaysia. It needs FIT2094 or FIT3171.
- Credit points
- 6
- Offered in 2025
- Semester 2
- Clayton, Malaysia
- Assessment
- Exam 40%
- and 3 other tasks
- Workload
- 144 hours
- per semester
This is the 2025 handbook entry. See the 2027 entry.
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 2025 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 2025
| Teaching period | Campus | Mode |
|---|---|---|
| Second semester | Clayton | Flexible |
| Second semester | Malaysia | On campus |
Assessment
- Assessment 1Quiz / TestThreshold hurdle10%
- Assessment 2ArtefactThreshold hurdle40%
- Assessment 3Quiz / TestThreshold hurdle10%
- Scheduled final assessment (2 hours and 10 minutes)ExaminationThreshold hurdle40%
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
- Laboratories24 hours
- Seminars24 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 5 areas of study in the 2025 handbook.
- COMPUSC07Advanced computational science electivesComputational scienceNo reviews yet
- COMPUSC08Computer science electivesComputational scienceNo reviews yet
- DATASCI10Level 3 elective unitsData scienceNo reviews yet
- DATASCAI01Level 3 electivesData science and artificial intelligenceNo reviews yet
- SFTWRENG01Software engineering technical electivesSoftware engineeringNo reviews yet
Contacts
- Unit Coordinators
- Dr Soon Lay Ki
- Isma Farah Siddiqui
- Chief Examiners
- Associate Professor David Taniar
Common questions
When is FIT3003 offered?
In 2025, 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 Computational science; Data science; Data science and artificial intelligence; and Software engineering.