Teaching Responsibility

LJMU Schools involved in Delivery:

LJMU Partner Taught

Learning Methods

Online

Module Offerings

6529COMECA-SEP-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.

Learning Outcomes

1.
Investigate the construction of data warehouses in support of business intelligence.
2.
Design reporting solutions for business intelligence.
3.
Develop business intelligence dashboards through service oriented applications.

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
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

Presentation

Technology