Teaching Responsibility

LJMU Schools involved in Delivery:

Computer Science and Mathematics

Learning Methods

Lecture
Practical

Module Offerings

6229COMP-SEP-CTY

Aims

To investigate the role and functionality of data warehouses in support of business intelligence. To gain insights into the process of extract, transform & loading in the construction of data warehouses. To study various platforms available for business intelligence reporting. To experience the development of service-oriented applications that support business intelligence dashboards.

Learning Outcomes

1.
Critically review methods for the construction of data warehouses in support of business intelligence
2.
Apply appropriate design methods in the development of complex reporting solutions for business intelligence
3.
Plan and implement a set of business intelligence dashboards to solve a business analysis problem

Module Content

Outline Syllabus:Introducing Business Intelligence & OLAP -Analytical Limitations of OLTP Multi-Dimensional Modelling -Star & Snow Flake Schemas -Cubes -Aggregations -MOLAP, ROLAP & HOLAP Analytical Extensions of SQL Extracting, Transforming & Loading Platforms for Reporting -Web Based Reporting Services -Supporting XML & JSON Platforms for Business Intelligence Dashboards -Object Relationship Mapping -Web Services -Serializing & De-Serializing Objects -Manipulating & Presenting Data
Module Overview:
This module works with a growing area of database systems, that of the analytical database. The module begins by enabling you to explore the rapid growth of business intelligence data and the complex data models that are needed to support it. The module continues by exploring the platforms and processes that report such data through both web based and service oriented platforms.
Additional Information:The module works with a growing area of database systems, that of the analytical database. The module begins by exploring the rapid growth of business intelligence data and the complex data models that are needed to support it. The module continues by exploring the platforms and processes that report such data through both web based and service oriented platforms.

Assessments

Technology
Technology