Toolbar
  • Layout
     
     

BI Reporting System

The purpose of the UWC BIRS project is to ensure that flexible reporting is possible throughout the UWC operational systems environment.

 

 

Client:
University of Western Cape

Project:
The purpose of the UWC BIRS project is to ensure that flexible reporting is possible throughout the UWC operational systems environment.

In order to do this the environment must deliver:

  • A UWC data warehouse. Initially this is a 'light' version of the LINK database modeled in such a way that it is suitable for reporting with acceptable performance.
  • A Business Metadata Layer. This layer will house the business logic of the various underlying systems and make flexible reporting a reality.
  • Standard Reports that provide insight into the student administration system.

The provided solution must as far as possible be built using software based on open source principles. As this is an adopted strategy of the university, this is a very important requirement. It is in this light that the UWC BIRS Technical Architecture document endeavours to report on findings and make recommendations in the regard to the best software solution.

Duration:
The architecture component of this solution was completed in 2 months.

Maersk DW System



An end to end implementation of a data warehouse solution for the Maersk Document Operational Workflow System.

 

 

Client:
Maersk

Project:
An end to end implementation of a data warehouse solution for the Maersk Document Operational Workflow System.

The Maersk Document Operational Workflow System Data mart project is an enhancement to the MDWS application, the main objective to allow flexible reporting on a “light” version of the MDWS database specifically around the areas of performance of the GSC’s (Global Service Centres) or SSC’s (Shared Service Centres), countries, booking agents and users.

Duration:
This project was implemented in 24 months.

Technical:
The solution was presented and implemented as a Business Objects on Microsoft SQL Server solution utilising the following technologies:

    Reporting - Business Objects
    ETL - Microsoft DTS controlled SQL Server procedures and functions
    Database - Microsoft SQL Server
    Environment - Windows Web Server and Database Server

Application Services

QLC Application Services offers a full range of innovative e-business solutions designed to meet the specific needs of our customers. We have a primary methodology for implementing solutions and maximizing quality.

We define the software components needed to build end-to-end solutions that meet specific business needs. Each Architecture has been designed, tested, and documented, so users can reduce the complexity, costs, and risks of deploying new technology in their enterprises.

Reduce costs, increase service levels, and improve manageability with our proven methodology, products and technologies - designed to help you consolidate to a common architecture of fewer, more powerful and better-utilized systems.

Our Security Architecture boasts a secure access and authentication with a consistent, scalable security model providing identity management, identity and service provisioning and application security.

Quantum Leap Consulting

To financially and intellectually empower all those associated with QLC

About Us

Quantum Leap Consulting (QLC) is a Level One rated BEE software-technology Company based in Cape Town, South Africa. QLC specialises in providing world-class services in the areas of Application Services, Network Services, as well as providing Resource Solutions to corporate Southern Africa.

QLC People Login