Undergraduate - UnitFIT3003 - Business intelligence and data warehousing

At the completion of this unit students will have -

A knowledge and understanding of:

• the role of Data Warehousing (DW) as opposed to operational databases;
• the definition and the need of Business intelligence (BI);
• DW development methodology;
• dimensional models compared to ER models;
• DW architectures, ETL and data quality issues;
• how DW can support BI;
• BI tools, techniques and OLAP;
• Data Mining (DM) techniques;
• Data Mining Tools.

Developed attitudes that enable them to:

• 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.

Gained practical skills to:

• 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.

Demonstrated the communication skills necessary to:

• 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.