INFO704 – Data Warehousing and Business Intelligence

Print
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
Directed hours
48
Self directed hours
102
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.