Business Data Mining and Warehousing

Unit code:BCO7004Study level:Postgraduate

Credit points

12
(Generally, 1 credit = 10 hours of classes and independent study.)

Location

City Campus
VU Brisbane
VU Sydney

Prerequisites

(Or equivalent to be determined by unit coordinator)
Co-requisites
(Corequisite units must be studied concurrently with this unit)

Overview

This unit provides students with the knowledge and skills to use data mining tools, techniques and frameworks for analysing and interpreting business data. Students use data mining tools, including applications of data mining in the cloud, to develop business insights to support decision-making. The unit covers important aspects of data warehousing including architecture, design, implementation, optimisation, working with cloud technologies and big data. Students engage in hands-on experience undertaking data warehousing using relational and non-relational management systems for structuring business intelligence data. The data mining applications include working with Application Programming Interface (APIs), data scraping, data aggregation, protocols for storing and transporting data. The unit pays particular attention to data efficacy, open data and wild caught data.

Learning Outcomes

On successful completion of this unit, students will be able to:

  1. Troubleshoot complex business problems through the application of data mining and warehousing solutions using relational databases;
  2. Critically reflect upon data warehousing architecture and multidimensional data models using internal and external business data;
  3. Implement online analytical processing (OLAP) in SQL and devise business intelligence reports using data warehouses and OLAP; and,
  4. Critically evaluate big data processing frameworks and technologies, contextualise the use of NoSQL technologies, implement and critically evaluate streaming methods in big data processing.

Assessment

For Melbourne campuses

Assessment type: Exercise | Grade: 20%

Application of data warehousing solutions

Assessment type: Project | Grade: 40%

Implementation of online analytical processing (OLAP) in SQL

Assessment type: Report | Grade: 40%

Evaluating, developing, and presenting the reporting solutions (in Group) for a Data Warehousing scenario case

Required reading

Selected readings will be made available via the unit VU Collaborate site.

As part of a course

This unit is studied as part of the following course(s):

Search for units, majors & minors