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.