Business Intelligence Services

BI System Builders are BI Vendor and Data Agnostic. The exact BI services deployed through a Cornerstone Solution® will depend upon the BI strategy, the BI tools, and the source data but an example is given below.

BI Platform Integration

Integration refers to the installation and configuration of your Business Intelligence platform followed by its integration with your data warehouse or SAP system.  Integration may among others be with legacy source systems, ODS’s, 3NF enterprise data warehouse’s, reference tables, spreadsheets, XML files, third party data, text files and RDBMS platforms such as Oracle or MS SQLServer.  Organisations using SAP Netweaver can expand their Business Intelligence capability beyond the current BEx Query scope by integrating with SAP BusinessObjects and SAP HANA.

Can We Help?

Optimal Data Warehousing Design & Build

Optimal data warehouse design is critical to a successful BI implementation.  Data warehouse design should be driven by user requirements. BI System Builders use the Agile Data Warehouse Design methods published by Lawrence Corr to gather requirements and model. A data warehouse that does not meet end user requirements is not fit for purpose. A data warehouse must have excellent performance, hold trusted data, be loaded in a timely manner and join up the business.

ETL Design For Clean & Trusted Data

Clean and trusted data is achieved through the development of the ETL system which will extract, transform and load data into the data warehouse. This involves extracting data from source systems, cleaning it and transforming it before loading. Cleaning and transforming data encompasses numerous tasks such as fixing ‘dirty’ data by removing duplicates, fixing partial records according to business rules, trapping errors and conforming data etc. The benefit of this is that business users have confidence that they are working with data that can be trusted and that is joined up. There are really two big components to the ETL system. These are the development of the system and the management of the system.


Analytics consuming clean, quality assured, joined up data can be highly valuable. There are three ways to achieve Analytics:  Build, Buy, or Buy and Extend. Analytics may be custom made for you (Build), procured from the SAP BusinessObjects Analytical Applications suite (Buy), or using and customising templates (Build and Extend) which can be used to jump start a BI initiative.

Business Intelligence Services


 Business Intelligence Centre of Excellence

Organisations can protect and grow their Business Intelligence investment by establishing a Centre of Excellence (CoE) often referred to as a Business Intelligence Competency Centre or BICC. BI System Builders have advised large companies on BICC strategy, process and day to management. The BICC is the optimum way to role our and maintain your Business Intelligence initiative.

Business Intelligence Training

BI System Builders can provide bespoke Business Intelligence and SAP BusinessObjects training geared to meet specific needs. This may include end user BI tool training, BI administration, BI system user adoption, data warehousing, and Business Intelligence Competency Centre awareness, orientation, and governance.

BISB Business Intelligence Services

There now follows a list of  the Business Intelligence services of the BI System Builders. All services provided are subject to the availability of a consultant.

Macro-Business Intelligence Services

Business Intelligence Strategy

BI Solution Architecture Design

End to End BI Programme & Project Planning & Management

Business Intelligence End To End Solution Design

Business Intelligence Competency Centre – Design, Process, Implementation, & Governance

Business Intelligence Change Management & End User Adoption

SAP BusinessObjects Business Intelligence Platform Services

Our services include the Installation and configuration of the SAP BusinessObjects Business Intelligence Platform in Single or Multi-machine Deployments

Deployment Across Single or Multiple Environments – Production, Pre-Production, System Test, & Development

High Availability & Clustered Environments

SAP BusinessObjects Administration

SAP BusinessObjects Security Model Design & Implementation

Business Analytics & Report Development Services

SAP BusinessObjects Semantic Layer (Universe) Design (OLAP & Relational)

SAP BusinessObjects Web Intelligence Report Development

SAP BusinessObjects Explorer Development

SAP Crystal Reports Development

SAP BusinessObjects Dashboard Development

SAP BusinessObjects Live Office Development

SAP BusinessObjects Advanced Analysis (OLAP) Development

Ask us about developing with other BI tool sets

 Data Warehousing

Requirements Gathering (ADWD/ BEAM)

Dimensional Modeling

Logical & Physical Models

Conformed Dimension Bus

Enterterprise Data Warehouse Design

Physical Deployment

Data Federation

ETL System

ETL Strategy

Data Services (Data Integrator) & SSIS ETL Package Design & Development

Metadata Management

Master Data Management

Source to Target Field Mapping & Data Dictionaries

Data Profiling

Data Cleansing & Data Quality

Data Governance


Performance Design

Business Intelligence Platform, RDBMS, & ETL Sizing

Hardware Recommendations

Database Table Design Optimisation e.g. Aggregate Design & Monster Dimension Management

ETL System Optimisation

OLAP Cube & Query Design Optimisation

Optimization of All Reporting Tools Listed Under Report Development Services

Enterprise Performance Management

KPI’s, Balance Scorecards & Strategy Maps

Leave a Reply

Your email address will not be published. Required fields are marked *