FIT3003 - Business intelligence and data warehousing
6 points, SCA Band 2, 0.125 EFTSL
Undergraduate Faculty of Information Technology
Leader(s): Dr Damminda Alahakoon
Clayton Second semester 2009 (Day)
This unit provides students with an understanding of Business Intelligence (BI) systems and the infrastructure needed to support them. Over the past decade OLAP tools, data mining and other data analysis techniques have been used to obtain value from data in ways not possible with earlier tools. Topics covered include the nature and purpose of BI, the relationship between BI and data warehousing, design issues related to BI tools and data warehouses, and common data analysis techniques such as OLAP, data mining and other computational techniques. The differences between these kinds of systems and other, more traditional information systems will be highlighted.
To acquire the Knowledge and Understanding of:
- Role of Data Warehousing (DW) as oposed to operational databases;
- The definition and the need of Business Intelligence (BI);
- DW development methodology;
- Dimensional models compared to ER models;
- BUS architecture;
- DW architectures, ETL and data quality issues;
- How DW can support BI;
- BI tools, techniques and OLAP;
- Data Mining (DM) techniques;
- Data Mining Tools.
To develop the following Attitudes, Values and Beliefs:
- Recognise the value of DW and BI for a business organisation;
- Adapt a critical approach to DW and BI technology in a business context;
- Appreciate the value of DW for effective management support and decision making;
- Understand the importance and value of BI tool and techniques compared to traditional data analysis techniques;
- Appreciate the value BI tools and DM for providing knowledge for decision making, in ways unavailable with traditional techniques.
To develop the following Practical Skills:
- Create dimensional models;
- Create DW architectures suitable for different organisations and requirements;
- Interpret results from OLAP and dimensional models;
- Create data analysis models using BI tools;
- Interpret results from BI and DM tools.
In addition, it is expected that the following Relationships, Communication and Team Work skills will be developed and enhanced:
- Document and communicate DW architectures and BI techniques;
- Work in a team during DW architecture design and BI model development;
- Communicate and coordinate during the team activities.
Assignments, class tests and laboratory exercises: 40%
Students must pass the examination in order to pass the unit.
4 x contact hrs/week