|
|
| BI (Business Intelligence) & DW (Data Warehouse) |
Sales Activity Tracking (SAT)
|
Customers |
- Otis-UK, London
|
The challenge |
Providing an efficient, flexible and secure method of retrieving and viewing Sales Activity data.
|
The solution |
The scope for project consists design, development, deployment and support for OTIS UK for Sales Activity Tracking solution.
SAT is a web-based project, which provides an efficient, flexible and secure method of retrieving and viewing Sales Activity data.
SAT is a useful tool for Business Analysis, which provides support to business decisions at Office, Sales hierarchy and product structure, from strategic planning to performance evaluation of a discrete organizational unit.
The project execution consists of the following phases:
|
- Extraction, Transformation & Loading (ETL) development
using Data Integrator. ETL has transfer of data in 2 phases
- Otis2000E - Gien CLC
- Otis 2000VF-MRL - Cernusco CLC
- Gen2 - China CLC
- Otis2000H – Cernusco CLC
- Universe development: Development of Universes for
each report where dimension, facts and aggregate tables
are used.
- Web Intelligence report development (Business Objects): SAT comprises of 5 system specific reports, which are developed in Business Objects 6.1A as follows: Product Summary, Booking Forecast, Live Portfolio, Market Share, Tender Activity
|
|
Apart from these reports, there are additional 3 exceptional
reports. These exceptional reports provide information on
success of ETL or failure along with proper reasons.
|
The platform
|
Windows 2000, MS SQL Server 2000, Business Objects 6.1, Data Integrator 6.1
|
|
