Business Intelligence using Excel

Module code: ACFI 2424

Module description

This module is designed to provide students with limited or no previous knowledge of Microsoft Excel an opportunity to understand and apply its functions to produce specific business information.

As a consequence of studying this module, students will be introduced to the vast volumes of raw data business organisations can generate and understand how Business Intelligence (BI), specifically Excel, can assist in making this data more meaningful. This module will provide students the ability to use select excel functions to manipulate data and to create tables and charts which can assist decision making.

Contact hours per student per year

  • Computer lab: 44 hours

Assessments

  • Excel-based workbook  (60 minutes): 40%
  • Case study (60 minutes): 60%

Additional costs: No extra costs other than purchase of books