INFO704

Module code

INFO704

Module title

Data Warehousing and Business Intelligence

Prescription

To enable students to examine the main components of data warehousing and apply it to business intelligence applications, enabling them to provide solutions which incorporate extracting data from different sources, storing data in a data warehouse and developing applications for business decision-making.

Programmes

BI1601
BI1804

NZQA Level

Level 7

NZQA Credits

15

Delivery method

Web-Supported

Learning hours

Total learning hours: 150

Resources required

Learning Outcomes: 1. Examine and discuss the differences between relational databases and data warehouses
concepts

2. Design and create a data warehouse using the latest technologies to support querying,
reporting and analysis tools to support critical business questions

3. Examine and apply OLAP and multidimensional databases to improve performance

4. Obtain practical knowledge of Industry based recent tools for data warehouse and
business intelligence
Content: - Introduction to OLTP, Data Warehouse and OLAP
- The need for data warehouses
- The need for OLAP
- Querying and reporting
- Trade-off: cost of resources and the running time of queries and reporting

- Business requirements for Business Intelligence
- Goals and strategies
- Valuation models
- Analytics

- Data warehouse architectures and processes
- Retrieving data from various sources
- Quality of data
- ETL architecture and processes
- Dimensional modelling (e.g. Star and snowflakes schemas)
- Data warehouse challenges

- OLAP architecture
- Multidimensional OLAP and Relational OLAP
- Queries and reporting
- Performance and analysis
- Mining data warehouses
Teaching and Learning Strategy: Teaching methods will involve theoretical and practical classes which may include but not limited to lectures, class discussions, tutorials, case studies, simulations, computer laboratory work, group activities, face-to-face and online activities.
Assessment Criteria: In order to receive a passing grade, students must achieve a minimum 40% average over all supervised tests and achieve 50% overall for the module.
Learning and Teaching Resource: Wintec Learning Management Systems, Computer Laboratory
Required Textbooks: An extended reading list will be supplied by the tutor at commencement of the module. This will be updated annually.

INFO704 – Data Warehousing and Business Intelligence