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