Skip to content

INFO704 – Data Warehousing and Business Intelligence

Module code
Module title
Data Warehousing and Business Intelligence
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.
  • BI1601
  • BI1804
NZQA Level
Level 7
NZQA Credits
Delivery method
  • Web-Supported
Learning hours
Total learning hours
Resources required
Learning Outcomes
1. Examine and discuss the differences between relational databases and data warehouses

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

Wintec is part of Te Pūkenga - New Zealand Institute of Skills and Technology Learn More

Learn with purpose

Explore Te Pūkenga

Te Kāwanatanga o Aotearoa - New Zealand Government

Te Kāwanatanga o Aotearoa - New Zealand Government

Copyright © 2022 Wintec