Teaching Responsibility

LJMU Schools involved in Delivery:

LJMU Partner Taught

Learning Methods

Lecture
Practical

Module Offerings

6628YCOM-JAN-PAR

Aims

To investigate the role and functionality of data warehouses in support of business intelligence. To evaluate the process of extract, transform & loading in the construction of data warehouses. To investigate the differing platforms available for business intelligence reporting. To develop service oriented applications that support business intelligence dashboards.

Module Content

Outline Syllabus:Analytical Limitations of Relational Databases Systems Business Intelligence & Analytical Database Multi-Dimensional Modelling Star & Snow Flake Schemas. Cubes Aggregations MOLAP, ROLAP & HOLAP Analytical Extensions to SQL Extract Transform & Loading Reporting Platforms Web Based Reporting Services Thin/Fat Clients & Servers Platforms for Business Intelligence Dashboards Web Services Object Relationship Mapping Object Oriented Programming Presentation of Data
Additional Information:This module explores a growing area of database systems, that of the analytical database. It explorers 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

Report
Artefacts